Single table containing separate frequencies for 96 variables

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Single table containing separate frequencies for 96 variables

Ruben Geert van den Berg
Dear all,
I would like to obtain a single frequencies table for a set of 96 (5 point Likert) items. So for each variable, I would like to see the distribution over the answer categories but all in one single table. I've been experimenting with multiple response sets but this only renders summarized statistics over the 96 items. Could anyone please suggest syntax to accomplish this? The GUI isn't going to do since I've (very) many such sets of variables and they're not even adjacent in the data file...
 
Lots of TIA,
 
Ruben v.d. Berg
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
====================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
Reply | Threaded
Open this post in threaded view
|

Re: Single table containing separate frequencies for 96 variables

Anthony Babinec
You can do this in Custom Tables. You stack your variables
in the row dimension, and then go to the Category Position drop
bar and specify Row Labels in Columns.

Anthony Babinec
[hidden email]

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Ruben van den Berg
Sent: Thursday, December 11, 2008 6:30 AM
To: [hidden email]
Subject: Single table containing separate frequencies for 96 variables

Dear all,
I would like to obtain a single frequencies table for a set of 96 (5 point
Likert) items. So for each variable, I would like to see the distribution
over the answer categories but all in one single table. I've been
experimenting with multiple response sets but this only renders summarized
statistics over the 96 items. Could anyone please suggest syntax to
accomplish this? The GUI isn't going to do since I've (very) many such sets
of variables and they're not even adjacent in the data file...

Lots of TIA,

Ruben v.d. Berg
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
=======
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
Reply | Threaded
Open this post in threaded view
|

Re: Single table containing separate frequencies for 96 variables

Anthony Babinec
Here's a thought. It is easier to try to use the GUI.

I'm not sure about the Release that introduced the feature,

but the SPSS Utilities menu lets you define and use Variable

Sets. You define a variable set by providing a name and

a list of variables that comprise that set. Then, if you Use

the variable set(check the named set and uncheck ALLVARIABLES

and NEWVARIABLES) the data window "masks" the other variables in

the file and presents only the subset of variables that comprise the set.

Since these variables are now contiguous in this view,

it is easy to drag them into the Table Builder. So, each of

your lists of variables could be a defined set.



Perhaps others on this discussion list have some suggestions.



Anthony Babinec

[hidden email]



  _____

From: Ruben van den Berg [mailto:[hidden email]]
Sent: Thursday, December 11, 2008 7:16 AM
To: [hidden email]; [hidden email]
Subject: RE: Single table containing separate frequencies for 96 variables



Dear Anthony,

Thanks very much, this works indeed!

However, I cannot use the point-click menus (even one such table would be
way too much work) and the syntax for ctables with 96 variables is very
complex and seems very hard to modify (to me at least) in order to
accomodate desired sets of 96 variables. I've created the varlist in EXCEL
(more or less: item1, item5, item9, item13). Later on, I'll need (item2,
item6, item10, item14). And so on...

Is there any alternative way in which I can copy and paste these variable
lists from EXCEL into my syntax?

Lots of TIA once again!

Best regards,

Ruben

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