Automate output in Excel

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

Posts: 3
Joined: Sat Jan 22, 2011 6:11 pm

Automate output in Excel

Postby endri81 » Tue May 29, 2012 7:31 am

I have several SPSS variables for which I have to calculate frequencies and then show them as table in Excel file.
Is there any way to automate this process in order for each variable to have its frequency table output in a single Excel sheet.

For example if variables V1 V2 V3...
I need to have frequency table for V1 in sheet1 frequency table for V2 in sheet2 in the same Excel file.

Best regards
Posts: 2750
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Automate output in Excel

Postby statman » Tue May 29, 2012 12:39 pm

The Excel export does have syntax so add that to your freq syntax, that's about as automated as you can get without getting into macros for which I can't help
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statistical Services

Who is online

Users browsing this forum: No registered users and 1 guest