Import data with variable names on a line other than first line

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

gandalf
Posts: 11
Joined: Mon Apr 16, 2012 12:25 pm

Import data with variable names on a line other than first line

Postby gandalf » Sun May 31, 2015 1:57 am

I have some data in a csv file with some non-necessary information in the first few lines. The variable names and the actual data are reported from line 20. So, Line 20 has the variable names and line 21 has the first case of data. How can I import this data into SPSS and still retain the variable names?
JonPedersen
Posts: 119
Joined: Wed May 25, 2011 7:07 am
Contact:

Re: Import data with variable names on a line other than first line

Postby JonPedersen » Thu Jun 18, 2015 12:32 pm

Hi,
You can import with a data list command and use the option SKIP=20

Or you can import with a get data command and use /FIRSTCASE =20
In both cases you have to specify your variable list.
jon

Who is online

Users browsing this forum: No registered users and 2 guests

cron