Using OMS Commands to Export Tables generated using CTABLEs
Locked
Using OMS Commands to Export Tables generated using CTABLEs
 
|
Hi, In my syntax some tables have layers and some tables are without layers. Can I use OMS command to export the tables into excel if there are layers in the tables. If yes, please let me know the command to be used. For your reference I have copied the syntax below. OMS /SELECT TABLES /IF COMMANDS=["CTables"] subtypes=["Custom Table"] /DESTINATION FORMAT=XLS OUTFILE ="C:\manoj~fdrive\try\OMS Command\ctables.xls" /columns DIMNAMES =['LAYERS']. CTABLES /VLABELS VARIABLES=rt Q2A7_1 ct X1 DISPLAY=DEFAULT /TABLE rt [COUNT F40.0] + Q2A7_1[COUNT F40.0, COLPCT.COUNT PCT40.1] BY ct BY X1 /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct X1 ORDER=A KEY=VALUE EMPTY=EXCLUDE /CATEGORIES VARIABLES=Q2A7_1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE="Ques 2A(7_1). Aware about events held - Makeover Monday?" CORNER="All Base" CAPTION="Job Number : Project - )DATE". CTABLES /VLABELS VARIABLES=rt Q2A7_2 ct X1 DISPLAY=DEFAULT /TABLE rt [COUNT F40.0] + Q2A7_2[COUNT F40.0, COLPCT.COUNT PCT40.1] BY ct + X1 /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct X1 ORDER=A KEY=VALUE EMPTY=EXCLUDE /CATEGORIES VARIABLES=Q2A7_2 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE="Ques 2A(7_2). Aware about events held - Thrilling Tuesday?" CORNER="All Base" CAPTION="Job Number : Project - )DATE". OMSEND. Regards Manoj http://www.imrbint.com/disclaimer.html ===================== 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 |
Re: Using OMS Commands to Export Tables generated using CTABLEs
|
|
OMS doesn't care whether there are layers
or not. However, note that if you want a different organization of
the layers in the exported file, note that the OMS COLUMNS subcommand can
be used to pivot the table for the generated dataset.
Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] phone: 720-342-5621 From: "Manoj Arora (DEL/Abacus Analytics)" <[hidden email]> To: [hidden email], Date: 07/24/2014 05:17 AM Subject: [SPSSX-L] Using OMS Commands to Export Tables generated using CTABLEs Sent by: "SPSSX(r) Discussion" <[hidden email]> Hi, In my syntax some tables have layers and some tables are without layers. Can I use OMS command to export the tables into excel if there are layers in the tables. If yes, please let me know the command to be used. For your reference I have copied the syntax below. OMS /SELECT TABLES /IF COMMANDS=["CTables"] subtypes=["Custom Table"] /DESTINATION FORMAT=XLS OUTFILE ="C:\manoj~fdrive\try\OMS Command\ctables.xls" /columns DIMNAMES =['LAYERS']. CTABLES /VLABELS VARIABLES=rt Q2A7_1 ct X1 DISPLAY=DEFAULT /TABLE rt [COUNT F40.0] + Q2A7_1[COUNT F40.0, COLPCT.COUNT PCT40.1] BY ct BY X1 /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct X1 ORDER=A KEY=VALUE EMPTY=EXCLUDE /CATEGORIES VARIABLES=Q2A7_1 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE="Ques 2A(7_1). Aware about events held - Makeover Monday?" CORNER="All Base" CAPTION="Job Number : Project - )DATE". CTABLES /VLABELS VARIABLES=rt Q2A7_2 ct X1 DISPLAY=DEFAULT /TABLE rt [COUNT F40.0] + Q2A7_2[COUNT F40.0, COLPCT.COUNT PCT40.1] BY ct + X1 /SLABELS POSITION=ROW /CATEGORIES VARIABLES=rt ct X1 ORDER=A KEY=VALUE EMPTY=EXCLUDE /CATEGORIES VARIABLES=Q2A7_2 ORDER=A KEY=VALUE EMPTY=EXCLUDE TOTAL=YES LABEL='Answering Base' POSITION=BEFORE /TITLES TITLE="Ques 2A(7_2). Aware about events held - Thrilling Tuesday?" CORNER="All Base" CAPTION="Job Number : Project - )DATE". OMSEND. Regards Manoj
|
| Free forum by Nabble | Edit this page |