re:
> 2 Proc Means: Here I have two options namely:
> a) Specify a set of one-variable Proc Means and give
> the the variable analysed in a Title statement. If you
> want them all in one spreadsheet, specify:
> ods markup tagset = Excelxp options (sheet_interval =
> “None”);
> as an option for the first Proc Means.
> b) This one is more elegant. Transpose the variables
> s of interest into one column .....
......
another approach for this proc was offered by Myra Oltsik (and some old hack
😉 )This approach makes just a single pass through the data. It is described in the paper at
http://www2.sas.com/proceedings/sugi31/059-31.pdf Paper 059-31 : A Better Means ? The ODS Data Trap