The SAS Output Delivery System and reporting techniques

How to creat a table similar to the attached table?

Reply
Contributor HG
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!

Attachment
Attachment
Grand Advisor
Posts: 16,411

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

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

Contributor HG
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!

Grand Advisor
Posts: 16,411

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 Smiley Happy

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;

Post a Question
Discussion Stats
  • 3 replies
  • 192 views
  • 3 likes
  • 2 in conversation