topic Re: proc tabulate in SAS Programming

proc tabulate

Ranjeeta — Fri, 30 Nov 2018 19:02:02 GMT

PROC TABULATE DATA=evt_qbp;
WHERE EX_LT90FU=0 AND EX_HISTORY~=1;
FORMAT FLAG_POSTDX YESNO_FMT.;
CLASS FLAG_POSTDX;
CLASS FACILITY_NO / ORDER=FREQ;
VAR HOMETIME;
TABLES FACILITY_NO ALL,
(ALL='Includes In-hospital Strokes' FLAG_POSTDX)*HOMETIME
*(N='Included Cases' MEDIAN );
TITLE1 "EVT Indicator 6: Home Time within 90-Days Following EVT, FY2017/2018";
TITLE2 "Including Deaths within 90 Days Following EVT";
RUN;

Hello

Can someone advise if the code above will correctly calculate the toal cases and the median for only the variable Hometime

Also what happens if I include ne additional in the var statement

will the total and median be calculated for both variables in the var statement

Re: proc tabulate

Kurt_Bremser — Fri, 30 Nov 2018 19:49:19 GMT

@Ranjeeta wrote:

PROC TABULATE DATA=evt_qbp;
WHERE EX_LT90FU=0 AND EX_HISTORY~=1;
FORMAT FLAG_POSTDX YESNO_FMT.;
CLASS FLAG_POSTDX;
CLASS FACILITY_NO / ORDER=FREQ;
VAR HOMETIME;
TABLES FACILITY_NO ALL,
(ALL='Includes In-hospital Strokes' FLAG_POSTDX)*HOMETIME
*(N='Included Cases' MEDIAN );
TITLE1 "EVT Indicator 6: Home Time within 90-Days Following EVT, FY2017/2018";
TITLE2 "Including Deaths within 90 Days Following EVT";
RUN;

Hello

Can someone advise if the code above will correctly calculate the toal cases and the median for only the variable Hometime

Also what happens if I include ne additional in the var statement

will the total and median be calculated for both variables in the var statement

Maxim 4: try it.

Re: proc tabulate

ballardw — Fri, 30 Nov 2018 19:55:20 GMT

Proc Tabulate will only calculate statistics other than the "N" related statistics (N pctn colpctn rowpctn) for variables declared on a VAR statement. "Correctly" depends on what you intend, especially when you say" the total cases "; If you want an overall including both the ROW and the COLUMN values then you want have an ALL on the row dimension as well.

Your code will create one column for each level of FLAG_POSTDX and all combined for each level of the row variable FACILITY_NO ALL.

If weren't aware, the Proc Tabulate will by default remove any record that has a missing value for any of the CLASS variables. So that can also impact "correctly".

Generally to request the same statistics for multiple variables place the variables within parentheses and the statistics in another set of parentheses with the * between them. See an example:

proc tabulate data=sashelp.class;
   class sex;
   var height weight;
   table sex,
         (height weight) *(n max min median)
   ;
run;

if they are not inside () then the variables are treated a separate requests and could request the same or different statistics

proc tabulate data=sashelp.class;
   class sex;
   var height weight;
   table sex,
         height  *(n max min median)
         weight * (mean std)
   ;
run;

Re: proc tabulate

PGStats — Fri, 30 Nov 2018 19:58:20 GMT

What problem (doubt) did you run into with the stated syntax?

What happens when you include another variable in the VAR statement depends on where you include this new variable in the TABLES statement.

If you say

VAR HOMETIME OtherVar;
TABLES FACILITY_NO ALL,
(ALL='Includes In-hospital Strokes' FLAG_POSTDX)*(HOMETIME Othervar)
*(N='Included Cases' MEDIAN );

you will get parallel columns for both VAR variables in each FLAG_POSTDX category and for ALL.