Hello,

We, the survey team, are producing results for >200 variables (A1 to A20, B1A to B1Z, Z1_new to Z10_new, etc.) using the same statistical analysis (CSTABULATE) to produce >200 output files.  In the example below, we analyze the C8 variable.

Currently, we are tediously replacing one variable after another variable and click run.  We are wondering how can we write extra lines in syntax (such as loop, repeat, etc.) that make run all variables at a run and produce >200 output files, instead of running one by one? That syntax line will replace another variable in the place of C8.

OMS
/SELECT TABLES
/IF COMMANDS = ['CSTABULATE']
INSTANCES = [LAST]
/EXCEPTIF SUBTYPE = ['NOTES']
/DESTINATION FORMAT = XLSX
OUTFILE = "...\C8_cstab_output.xlsx"
/NOWARN.

MISSING VALUES C8 (66 thru 99).

CSTABULATE
/PLAN FILE='...\weighing2.csaplan'
/TABLES VARIABLES=C8
/CELLS TABLEPCT
/STATISTICS SE CV CIN(95) COUNT
/MISSING SCOPE=TABLE CLASSMISSING=EXCLUDE.
EXECUTE.

OMSEND.

Thank you very much in advance.


------------------------------
Myint Tun
------------------------------

#SPSSStatistics