The SAS Output Delivery System and reporting techniques

Summary Table/ Proc Tabulate

Reply
Occasional Contributor
Posts: 9

Summary Table/ Proc Tabulate

Hello, use a proc tabulate for summary table creation. Have years in column headers.  

 

                   Year1         Year2         Year3

Modality1

Modality2

Modality2

Total

 

Is there a way to add columns, showing evolution in % from year to year with proc tabulate or any other ? 

 

 

SAS Super FREQ
Posts: 8,641

Re: Summary Table/ Proc Tabulate

Hi:
Proc TABULATE will build each column isolated from the other columns. So you cannot, in TABULATE, divide Year3 by Year2 (as an example) or subtract Year2 from Year3 to find a difference (as another example). You can do things like that with PROC REPORT and a COMPUTE block or a COMPUTED report item. Or, you can pre-summarize your data and calc your % differences in a program and then just arrange everything the way you want and do a simple PROC PRINT, but based on the information you've given, TABULATE won't do what you describe.
cynthia
Post a Question
Discussion Stats
  • 1 reply
  • 250 views
  • 0 likes
  • 2 in conversation