Summary Table/ Proc Tabulate

[gabriel_k]

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 ? 

[Cynthia_sas]

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