Contributor
Posts: 23

# How to creat a table similar to the attached table?

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!

Super User
Posts: 23,323

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

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

Contributor
Posts: 23

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

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!

Super User
Posts: 23,323

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

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;

Discussion stats
• 3 replies
• 250 views
• 3 likes
• 2 in conversation