excel to SPSS

[Suvash Dhakal]

Hi all,

 

I don't know if I can explain this accurately, but I have a data in
excel file in the format displayed below, where each respondent is asked
a grid format question (scale/rating). How can I import this file to
SPSS or desktop reporter so that q1, q2 become my variables (and NOT
pagename)? I have JUST four columns of data but series of question that
ranges from  scale/rating questions to overlapping data (questions with
option of "check all that apply").

 

ID

pagename

testname

response1

 

 

 

 

1

q1

A

2

 

 

 

 

1

q1

B

4

 

 

 

 

1

q1

C

2

 

 

 

 

2

q1

A

8

 

 

 

 

2

q1

B

16

 

 

 

 

2

q1

C

1

 

 

 

 

1

Q2

red

 

 

 

 

 

1                              q2                blue                  

2                              q2                   red

2                              q2              yellow                

 

 

 

Thank you,

Suvash

 

 

====================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

[Richard Ristow]

At 03:44 PM 7/28/2008, Suvash Dhakal wrote:

>I have data in excel file in the format displayed below, where each
>respondent is asked a grid format question (scale/rating).

Here's the data, reformatted to one line per record -- though I'm not
sure I've got it right. (I wonder why data so often comes through
with many extra line breaks?)

ID    pagename testname response1

1       q1       A       2
1       q1       B       4
1       q1       C       2
2       q1       A       8
2       q1       B       16
2       q1       C       1

1       Q2              red
1       q2              blue
2       q2              red
2       q2              yellow

>How can I import this file to SPSS so that q1, q2 become my
>variables (and NOT pagename)?

Import it as you have it, and then use CASESTOVARS (in syntax), or
from the menus,
Data> Restructure...> Restructure selected cases into variables

In either case, use 'pagename' as the index variable; you probably
will have to use formatting options on the command, to get exactly
what you want.

I'm not trying to give a complete solution, because it's not clear
how your data is actually structured.
==========================
APPENDIX:  As far as I got
==========================
DATA LIST LIST/
    ID    pagename testname response1
   (F3,   A2,      A2,      A4).
BEGIN DATA
1       q1       A       2
1       q1       B       4
1       q1       C       2
2       q1       A       8
2       q1       B       16
2       q1       C       1
END DATA.
LIST.
SORT CASES BY ID testname pagename .

CASESTOVARS
  /ID = ID testname
  /INDEX = pagename
  /GROUPBY = VARIABLE .

LIST.

=====================
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