Re: .csv file and old SPSS

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: .csv file and old SPSS

Parveen Sharma
GET DATA  /TYPE = TXT
 /FILE = 'path of file'
 /DELCASE = LINE
 /DELIMITERS = ","
 /ARRANGEMENT = DELIMITED
 /FIRSTCASE = 2
 /IMPORTCASE = ALL
 /VARIABLES =
 RespIdXYZ F2.1
 AuthKeyXX A10
 ALevelXX A5
 ...
 BCLevelXX A3
 .
CACHE.
EXECUTE.


----------------------Try running above syntax-----------------------
Kindly remember to change the path of the file. Also, include all the
variables in the data (csv) file. under  "/VARIABLES =" with there
respective formats.
This syntax works if your variable names are listed in first row of the
CSV file.

Hope this helps. Though I am using a higher version of SPSS, but i beleive
this should work.

Thanks,
Parveen