Hi All,
I'm looking for a way to create output using proc tabulate two-way table vertically.
Please find Sample.xlsx attached.
Regards,
Thokozani
Hi
Using the task Summary Tables you can create something like this. The layout definition would look like
It is using sashelp.cars.
And here a code example generated by SAS Enterprise Guide
PROC TABULATE
DATA=SASHELP.CARS
FORMAT=NLNUM14.
;
WHERE( Origin IN ('Asia','Europe'));
VAR Invoice;
CLASS Type / ORDER=UNFORMATTED MISSING;
CLASS Origin / ORDER=UNFORMATTED MISSING;
CLASS DriveTrain / ORDER=UNFORMATTED MISSING;
TABLE /* Row Dimension */
Type={LABEL=""}
ALL={LABEL="Total (ALL)"},
/* Column Dimension */
Origin={LABEL=""}*(
DriveTrain={LABEL=""}*
Invoice={LABEL=""}*
Sum={LABEL=""}
ALL={LABEL="Total (ALL)"}*
Invoice={LABEL=""}*
Sum={LABEL=""});
;
RUN;
Bruno
Hi
Using the task Summary Tables you can create something like this. The layout definition would look like
It is using sashelp.cars.
And here a code example generated by SAS Enterprise Guide
PROC TABULATE
DATA=SASHELP.CARS
FORMAT=NLNUM14.
;
WHERE( Origin IN ('Asia','Europe'));
VAR Invoice;
CLASS Type / ORDER=UNFORMATTED MISSING;
CLASS Origin / ORDER=UNFORMATTED MISSING;
CLASS DriveTrain / ORDER=UNFORMATTED MISSING;
TABLE /* Row Dimension */
Type={LABEL=""}
ALL={LABEL="Total (ALL)"},
/* Column Dimension */
Origin={LABEL=""}*(
DriveTrain={LABEL=""}*
Invoice={LABEL=""}*
Sum={LABEL=""}
ALL={LABEL="Total (ALL)"}*
Invoice={LABEL=""}*
Sum={LABEL=""});
;
RUN;
Bruno
You can't split these two table completely .
data have;
set sashelp.cars;
retain dummy ' ' x .;
run;
proc tabulate data=have;
class Type Origin DriveTrain ;
class dummy /missing style={background=yellow cellwidth=1cm};
classlev dummy /style={background=yellow};
var Invoice x;
table Type all,Origin*Invoice*(n mean std)
dummy=''*x=''*sum=''*{style={background=yellow}}
DriveTrain*Invoice*(n mean std)
/printmiss misstext=' ';
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.