SPSSX Discussion

Saving Ns, means and standard deviations within groups

Classic

List

Threaded

2 messages Options

lts1

Saving Ns, means and standard deviations within groups

Hi SPSSers,

I have a large multinational dataset that I need to subdivide within country, and then save the Ns, means & standard deviations of several variables. I'm hoping you can help me.

What I have been doing is using Filter to subdivide the data into one of 12 mutually exclusive categories within each country, then I used Descriptives to produce the Ns, means & standard deviations for the variables of interest. That produces them, but it doesn't save them. So, I started copying them into an Excel file. It quickly became evident that to continue with this method will be extremely tedious, especially since I have approximately 80 countries.

Can anyone help me automate this process? Please bear in mind that I have virtually no experience with macros. Also, you should know that although, the countries are numbered, there are some gaps in the numbering sequence.

Thanks in advance.

Best,

Lisa

Lisa T. Stickney, Ph.D.
Assistant Professor
Merrick School of Business
University of Baltimore
Lstickney@...

Bruce Weaver

Re: Saving Ns, means and standard deviations within groups

Administrator

Lisa T. Stickney wrote

Hi SPSSers,

I have a large multinational dataset that I need to subdivide within country, and then save the Ns, means & standard deviations of several variables. I'm hoping you can help me.

What I have been doing is using Filter to subdivide the data into one of 12 mutually exclusive categories within each country, then I used Descriptives to produce the Ns, means & standard deviations for the variables of interest. That produces them, but it doesn't save them. So, I started copying them into an Excel file. It quickly became evident that to continue with this method will be extremely tedious, especially since I have approximately 80 countries.

Can anyone help me automate this process? Please bear in mind that I have virtually no experience with macros. Also, you should know that although, the countries are numbered, there are some gaps in the numbering sequence.

Thanks in advance.

Best,
Lisa

Lisa T. Stickney, Ph.D.
Assistant Professor
Merrick School of Business
University of Baltimore
Lstickney@ubalt.edu

Look up AGGREGATE in the Help Files.

--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING:
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).