How to creat a table similar to the attached table?

[HG]

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!

[Reeza]

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

[HG]

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!

[Reeza]

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;