Reading Excel data into SPSS

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

Reading Excel data into SPSS

David Lindsay, Global Perspectives

Good day

 

I have been given a survey for analysis that is in Excel

 

The format is variable name in row 1, the variable label is in row 2 and the data in row 3 onwards. I would appreciate some help in writing a data read statement so that the variable label is written directly into variable labels for the variable in row 1. BTW I only have SPSS v12

 

         id

s1

s2

s3

         id

Completed

Last page seen

Start language

41

en

43

en

45

2012-12-24 13:55:32

6

en

49

2012-12-27 09:47:02

6

en

51

2012-12-27 09:48:45

6

en

53

2012-12-27 09:50:45

6

en

55

2012-12-27 09:52:10

6

en

57

2012-12-27 09:53:50

6

en

 

 

Thanks and regards,
David Lindsay