not importing variables

[Stavrakakis Nikolaos]

Dear all,

 

I have a very peculiar problem when trying to import variables from other files into a spss dataset. All variables are imported without problem except for 5 specific ones (which have to do with thoracic impedience measures) which the values are not copied into the spss data set.  Checking the original files I can see that the values exist, but for some reason are not copied in spss.  I ve tried changing the variables (from numeric to string etc) but that didn't work.  I ve also thought at the beginning that there was a problem with the commas and dots (since the numbers where with dots while spss had a comma option) changed the settings in spss (so that it can recognise the dots as part of the number and not as a missing value) but still didn't work.  I would appreciate if someone who has encountered a similar problem could give me a couple of suggestions as to what might be going wrong.

 

Thank you for your time

 

Nikolaos

[Art Kendall]

What kinds of files are the other files? character, comma separated, tab separated, fixed position, database (sql), etc?

What actually appears in the SPSS data editor data view and variables view for the problem instances?

Can you make up a minimal dataset that has a few cases and a few variables that demonstrate the problem?

Art Kendall
Social Research Consultants



On 8/27/2010 7:19 AM, Stavrakakis Nikolaos wrote:

Dear all,

 

I have a very peculiar problem when trying to import variables from other files into a spss dataset. All variables are imported without problem except for 5 specific ones (which have to do with thoracic impedience measures) which the values are not copied into the spss data set.  Checking the original files I can see that the values exist, but for some reason are not copied in spss.  I ve tried changing the variables (from numeric to string etc) but that didn't work.  I ve also thought at the beginning that there was a problem with the commas and dots (since the numbers where with dots while spss had a comma option) changed the settings in spss (so that it can recognise the dots as part of the number and not as a missing value) but still didn't work.  I would appreciate if someone who has encountered a similar problem could give me a couple of suggestions as to what might be going wrong.

 

Thank you for your time

 

Nikolaos

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Stavrakakis Nikolaos]

Dear Art,

 

The data set I get looks like that. As you might have noticed all the values that appear have a comma, while the values that do not appear are written with a dot (thats why  I thought at first that it might have something to do with that).  Some variables have only categories -like the Complex or like IBI which is a continuous variable or LVET.

 

 

Part	Complex	Block	ZO	IBI	Ampdzdt	LVET
3	0,0	0	.	738,00	.	276,00
3	1,0	0	.	748,00	.	280,00
3	2,0	0	.	783,00	.	276,00

 

Thanks for your time and efforts

Best

Nikolaos

[Art Kendall]

What program was used to write the file you are trying to read?

What type of file is the file you are trying to read? I.e., what is its extensions  myfile.csv has a csv extension.

Is a period (.) ever used for anything other than a missing value? e.g., embedded in a string.

What is the syntax you are using  to read the file? If you are using the GUI, click <paste>.



Art Kendall
Social Research Consultants

On 8/30/2010 2:53 AM, Stavrakakis Nikolaos wrote:

 

Dear Art,

 

The data set I get looks like that. As you might have noticed all the values that appear have a comma, while the values that do not appear are written with a dot (thats why  Ithought at first that it might have something to do with that.  (some variables have only 30 categories -like the complex or like IBI which is a continuous variable or LVET)

 

 

Part	Complex	Block	ZO	IBI	Ampdzdt	LVET
3	0,0	0	.	738,00	.	276,00
3	1,0	0	.	748,00	.	280,00
3	2,0	0	.	783,00	.	276,00

--- On Fri, 8/27/10, Art Kendall [hidden email] wrote:

From: Art Kendall [hidden email]
Subject: Re: [SPSSX-L] not importing variables
To: "Stavrakakis Nikolaos" [hidden email]
Cc: [hidden email]
Date: Friday, August 27, 2010, 1:42 PM

What kinds of files are the other files? character, comma separated, tab separated, fixed position, database (sql), etc?

What actually appears in the SPSS data editor data view and variables view for the problem instances?

Can you make up a minimal dataset that has a few cases and a few variables that demonstrate the problem?

Art Kendall
Social Research Consultants



On 8/27/2010 7:19 AM, Stavrakakis Nikolaos wrote:

Dear all,

 

I have a very peculiar problem when trying to import variables from other files into a spss dataset. All variables are imported without problem except for 5 specific ones (which have to do with thoracic impedience measures) which the values are not copied into the spss data set.  Checking the original files I can see that the values exist, but for some reason are not copied in spss.  I ve tried changing the variables (from numeric to string etc) but that didn't work.  I ve also thought at the beginning that there was a problem with the commas and dots (since the numbers where with dots while spss had a comma option) changed the settings in spss (so that it can recognise the dots as part of the number and not as a missing value) but still didn't work.  I would appreciate if someone who has encountered a similar problem could give me a couple of suggestions as to what might be going wrong.

 

Thank you for your time

 

Nikolaos

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[Stavrakakis Nikolaos]

Dear Art,

 

sorry for the lateness of my reply.  The original file is an .IAR file and by noticing all of the variables that are not imported into spss are like this: 8.29, all other numbers are actually imported.  In the IAR file there are no missing values and we have set the -999 option for spss (so every missing value is recorded as -999).  I am not sure on the syntax used but I will look into it and let you know over the next few days.

 

thank you for your help

Nikolaos 

 

 

--- On Mon, 8/30/10, Art Kendall <[hidden email]> wrote:

From: Art Kendall <[hidden email]>
Subject: Re: [SPSSX-L] not importing variables
To: "Stavrakakis Nikolaos" <[hidden email]>, "SPSSX-L post" <[hidden email]>
Date: Monday, August 30, 2010, 1:19 PM

What program was used to write the file you are trying to read?

What type of file is the file you are trying to read? I.e., what is its extensions  myfile.csv has a csv extension.

Is a period (.) ever used for anything other than a missing value? e.g., embedded in a string.

What is the syntax you are using  to read the file? If you are using the GUI, click <paste>.



Art Kendall
Social Research Consultants

On 8/30/2010 2:53 AM, Stavrakakis Nikolaos wrote:

 

Dear Art,

 

The data set I get looks like that. As you might have noticed all the values that appear have a comma, while the values that do not appear are written with a dot (thats why  Ithought at first that it might have something to do with that.  (some variables have only 30 categories -like the complex or like IBI which is a continuous variable or LVET)

 

 

Part	Complex	Block	ZO	IBI	Ampdzdt	LVET
3	0,0	0	.	738,00	.	276,00
3	1,0	0	.	748,00	.	280,00
3	2,0	0	.	783,00	.	276,00

--- On Fri, 8/27/10, Art Kendall <Art@...> wrote:

From: Art Kendall <Art@...>
Subject: Re: [SPSSX-L] not importing variables
To: "Stavrakakis Nikolaos" <tittiesandbeersplease2@...>
Cc: SPSSX-L@...
Date: Friday, August 27, 2010, 1:42 PM

What kinds of files are the other files? character, comma separated, tab separated, fixed position, database (sql), etc?

What actually appears in the SPSS data editor data view and variables view for the problem instances?

Can you make up a minimal dataset that has a few cases and a few variables that demonstrate the problem?

Art Kendall
Social Research Consultants



On 8/27/2010 7:19 AM, Stavrakakis Nikolaos wrote:

Dear all,

 

I have a very peculiar problem when trying to import variables from other files into a spss dataset. All variables are imported without problem except for 5 specific ones (which have to do with thoracic impedience measures) which the values are not copied into the spss data set.  Checking the original files I can see that the values exist, but for some reason are not copied in spss.  I ve tried changing the variables (from numeric to string etc) but that didn't work.  I ve also thought at the beginning that there was a problem with the commas and dots (since the numbers where with dots while spss had a comma option) changed the settings in spss (so that it can recognise the dots as part of the number and not as a missing value) but still didn't work.  I would appreciate if someone who has encountered a similar problem could give me a couple of suggestions as to what might be going wrong.

 

Thank you for your time

 

Nikolaos