May 2015
Intermediate to advanced
348 pages
11h 31m
English
ODS EXCEL FILE="your-file.xlsx"; ...PROC TABULATE program here ... ODS EXCEL CLOSE;
ODS EXCEL FILE="MULTITABLEFINAL.XLSX"; TITLE "Historical Sales Data"; PROC TABULATE DATA=PRDSALE; BY COUNTRY; VAR PREDICT ACTUAL; CLASS REGION DIVISION PRODTYPE YEAR; TABLE YEAR=[LABEL=' '], REGION*(DIVISION*PRODTYPE ALL=[LABEL='DIVISION TOTAL']) ALL=[LABEL='GRAND TOTAL'], PREDICT=[LABEL='TOTAL PREDICTED SALES']*F=DOLLAR10.*SUM=[LABEL=''] ...