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!


sasmple output.png
Attachment
Super User
Posts: 19,194

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!

Super User
Posts: 19,194

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;

Ask a Question
Discussion stats
  • 3 replies
  • 238 views
  • 3 likes
  • 2 in conversation