topic Re: proc means with class YEAR and more variables, how to make individual tables for each variable? in SAS Procedures

proc means with class YEAR and more variables, how to make individual tables for each variable?

silasskovsbo — Fri, 24 Aug 2012 12:59:28 GMT

Hello everybody. I have a problem.

I have a dataset with some variables including the variable YEAR. I want to make some descr. statistics on the other variables for each year.

I use proc means with class YEAR and it works fine but there is a problem. I want to have descr. statistics on all the relevant variables in one PDF but with tables showing the statistics for each variable - so one table for each variable.

I have tried this (see below) but it just makes one table with both variables.

proc means data=XXXXX;

class YEAR ;

var AGE EXPERIENCE ;

run;

Do somebody know how to make this with indivudal tables for each variable??

Thank you!

Best // Silas, Aarhus University, Institute of Economics

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

Tom — Fri, 24 Aug 2012 14:03:13 GMT

Do you just want to run two proc means?

proc means data=xxxx;

class year;

var age ;

run;

proc means data=xxxx;

class year;

var experience;

run;

If more than a hand full then you could do it with a macro.

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

silasskovsbo — Fri, 24 Aug 2012 14:13:48 GMT

I am also ended with that solution now but since there are many variables and very big data set it is a very demanding procedure.

I wondered if there was a solution like when you work with proc freq you can have more variables in one print by this simple code.

proc freq data=XXXX;

tables YEAR*(AGE EXPERIENCE);

run;

And thanks!

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

Tom — Fri, 24 Aug 2012 14:40:52 GMT

Why not just have PROC MEANS output a dataset and the use PRINT or REPORT to display it the way you want?

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

asishgautam — Fri, 24 Aug 2012 15:33:41 GMT

Have you looked into "by group" processing? Note that this will require sorting your data set by the "by groups".

proc means data=XXXXX;

by YEAR ;

var AGE EXPERIENCE ;

run;

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

ballardw — Fri, 24 Aug 2012 21:39:34 GMT

One approach is to reshape your data.

data want (keep year var value);

set have;

array vars (list of your analysis variables);

length variable $32;

do i = dim(vars);

call vname( vars,variable);

value = vars;

output;

end;

run;

This creates a data set with year, the name of the variable as the value of a string variable and the value.

Then sandwich the below code in appropriate ODS PDF or RTF call. Defaults to one table per page.

proc tabulate data=want;

class variable year;

var value;

table variable, /* as first item this will be table level*/

value *(n mean max min std), /* or which ever statistics you want these will be row variables)

year ; /* year would be column variable, if you want year as the row, then reverse the order of these*/

run;

Re: proc means with class YEAR and more variables, how to make individual tables for each variable?

silasskovsbo — Mon, 27 Aug 2012 14:48:39 GMT

Thank you for the help, everybody! I have now found a satisfying solution.