Hello everyone, I am Julian and I need to produce a table that shows the layout you can see in this picture. Using the following PROC TABULATE program in SAS Enterprise Guide 7.1 – 32 bits I’ve been able to produce all the columns except for the “Cumulative % of the Sum_Var2” one. PROC TABULATE DATA= Julian.Mydata NOSEPS ;
TITLE1 'Table 3';
WEIGHT weight_var;
CLASS category_var / PRELOADFMT EXCLUSIVE;
VAR Var1 Var2;
TABLE (ALL='TOTAL' category_var=' '),
(SUM='Sum_Var1'*Var1=' '*ALL=' '*F=COMMAX16.0
SUM='Sum_Var2'*Var2=' '*F=dollar16.0
MEAN='Mean_Var2'*Var2=' '*F=dollar16.0
COLPCTSUM='% of the Sum_Var2'*Var2=' ')
/RTS=25 PRINTMISS BOX='Categories' CONDENSE;
FORMAT category_var category_var.;
FOOTNOTE 'Source';
RUN; Do you know a method to create that column without losing the visual features of the PROC TABULATE? Thanks. I will be looking forward to your help.
... View more