Hello,

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

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.

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

Thank you very much in advance.