Descriptive data from spss dataset in long form

[Daniel Arvidsson]

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

[Maguin, Eugene]

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

[David Marso]

I believe you will want to carefully study the AGGREGATE command!
--

Daniel Arvidsson wrote

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