LISTWISE command for frequencies

[Paola Chivers-2]

HI,

 

I need to calculate frequencies on a subset of my data that don’t have any missing data across the specified variables X Y Z (actually several variables).  I was able to do this simply for descriptives (see syntax below), but couldn’t work out how to do this for frequencies.  The best I could come up with was ‘include’ – but I don’t want that.    I am using v17 of spss.

 

DESCRIPTIVES VARIABLES= X Y Z

  /STATISTICS=VARIANCE DEFAULT

 /MISSING=LISTWISE.

 

FREQUENCIES VARIABLES=X Y Z

  /ORDER=ANALYSIS

 /MISSING=?????.

 

Why do I want to do this?  I have run a multinomial logistic regression and it uses the listwise subset in its model.  I now want the descriptives / frequencies for that same subset to interpret the model results. 

 

Any advice most welcome.

 

Regards,

Paola

 

 

[Marta Garcia-Granero]

Paola Chivers wrote:

>
> I need to calculate frequencies on a subset of my data that don’t have
> any missing data across the specified variables X Y Z (actually
> several variables). I was able to do this simply for descriptives (see
> syntax below), but couldn’t work out how to do this for frequencies.
> The best I could come up with was ‘include’ – but I don’t want that. I
> am using v17 of spss.
>
> DESCRIPTIVES VARIABLES= X Y Z
>
> /STATISTICS=VARIANCE DEFAULT
>
> /MISSING=LISTWISE.
>
> FREQUENCIES VARIABLES=X Y Z
>
> /ORDER=ANALYSIS
>
> /MISSING=?????.
>

Only solution I can think of:

COUNT filter = X Y Z (SYSMIS) .
TEMPORARY.
SELECT IF (filter=0).
FREQUENCIES VARIABLES=X Y Z
/ORDER=ANALYSIS.

HTH,
Marta García-Granero


--
For miscellaneous statistical stuff, visit:
http://gjyp.nl/marta/

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

[Paola Chivers-2]

Thanks Marta - that did the trick!

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