sas (1)

1.

proc tabulate data = tmp_re noseps;
      class RANK;
      table RANK all,(mean*f=8.4)*( &_vlist.);
      var  &_vlist.;
      label RANK='Rank';
      %if &weight~=1 %then %do; weight &weight.; %end;
run;

 

2.

ODS TAGSETS.EXCELXP file="&outfile._&step_num..xls" style=in.Custom ;

%if &selection~=1 %then %do;

ODS TAGSETS.EXCELXP OPTIONS (sheet_name="Sel_Summary"
                 sheet_interval='NONE' Embedded_Titles='YES' zoom='120'
                 absolute_column_width = "10,20,20,10,10,20");