PROC IMPORT OUT= WORK.respiratory
DATAFILE= "C:\Users\Administrator\Desktop\respiratory.xlsx"
DBMS=EXCEL REPLACE;
RANGE="respiratory$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
PROC TABULATE DATA=respiratory;
CLASS status treatment CENTER;
VAR AGE;
TABLE (treatment='' ALL)*(status='' ALL) ,AGE='age'*(CENTER ALL)*(colpctsum mean sum)
/box=[label="treatment & status by age" style=[fontstyle=italic]];
RUN;