Login  Register

Re: Descriptive data from spss dataset in long form

Posted by Maguin, Eugene on Sep 16, 2014; 2:38pm
URL: http://spssx-discussion.165.s1.nabble.com/Descriptive-data-from-spss-dataset-in-long-form-tp5727270p5727274.html

The simplest solution is to convert to wide format (casestovars).

If you don’t want to do that, then you can exploit the indexing which should have three levels: person, occasion within in person (range=1-3) and day within occasion (range: 1 to 3-7).

And then use crosstabs:

Crosstabs occasion by day.

Crosstabs occasion by day by gender.

 

Gene Maguin

 

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Daniel Arvidsson
Sent: Tuesday, September 16, 2014 10:15 AM
To: [hidden email]
Subject: Descriptive data from spss dataset in long form

 

Hi

 

I have my dataset in long form where each individual has three measure occasions and within each measure occasion there are 3-7 measure points (days). Totally there could be 9 to 21 rows (data points) for each individual. If I want to get descriptive data of number of individuals (not the number of measure points) and other information at each measure occasion, what syntax can I use? If I then want to present it by gender and by age-group, how do I do it? (At each measure occasion there are two age-groups)

 

Daniel

 

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

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