%macro contstats(ds=,var=); proc means data = &ds. completetypes nway chartype missing noprint ; class trt02p/missing mlf; var &var; output out = stats&var (drop=_type_ _freq_) n=n mean=Mean stddev=SD median=Median min=Min max=Max ; run; proc transpose data = stats&var out = stat_&var (drop=_label_); id trt02p; run; %mend contstats; %contstats(ds=adsl_,var=age); output I got is trt02p ,n , mean , sd ,median , min , max 10 mg 5 31.9 15.39 24.3 18.6 56 20 mg 5 23.68 6.496 21.9 18.4 34.2 40 mg 5 22.16 3.502 21.5 18.3 27.1 80 mg 4 25.325 3.831 24.4 22 30.5 output I want is column var with value age before trt02p.