kirsten
I haven't used SPSS before.
This morning I got a disc with the datasets in .SPS and .DAT format. My boss told me to run it in SPSS, so I tried to open that.
I found that the .SPS file contains the code that when I ran it, I got a list of variable names and definitions in the "variable view" window. And the .DAT looks like "&14203410111323027". there's no space, no comma or semicolon between the numbers.
I did the follow to the .DAT:
File-Open-Data
a Wizard window appeared, showed the number look like above
"Does your text file match a predefined format?"-No-Next
"How are your variables arranged?"-Fixed widt
"Are variable names included at the top of your file?"-No-Next
"The first case of data begins on which line number?"-1
"How are your cases represented?"-Each line...
"How many cases do you want to import?"- All...-Next
THEN, according to what .SPS defined, I set the breakpoint on the digits. then Next-Next-Finish.
So I get another sheet with undefined variables and all the data. so i copy the data and paste to the sheet with the right variavle names.
I am not sure whether the data is arranged into the right cells. Also, I think it's too complicated to do it this way.
I believe there must be a simple and accurate way to import the data. Can any one help please?
