topic Re: How to creat a table similar to the attached table? in ODS and Base Reporting

How to creat a table similar to the attached table?

HG — Tue, 02 Oct 2012 15:40:29 GMT

Dear All,

I have attached my sample dataset and the output I would like to produce. What procedures should I use?

Thank you very much for your help!

Re: How to creat a table similar to the attached table?

Reeza — Tue, 02 Oct 2012 15:44:39 GMT

How are the numbers being calculated? ie avg? stdev?

Re: How to creat a table similar to the attached table?

HG — Tue, 02 Oct 2012 16:03:59 GMT

Hi Reeza,

the numbers are counts of var?=1. for example, 234(98.73%), it means that there are 234 var1=1 in 2009, 234/237=98.73%. 237 is the total number in 2009.

Thank you!

Re: How to creat a table similar to the attached table?

Reeza — Tue, 02 Oct 2012 17:26:03 GMT

Use proc means then, but it won't be as nice format, that will take some work

proc means data=have nways;

class year;

output out=want n(var1)=total sum(var)=var1 mean(var1)=pct_var1 sum(var2)=var2 sum(var3)=var3 sum(var4)=var4;

run;