topic Re: Summary Table/ Proc Tabulate in ODS and Base Reporting

Summary Table/ Proc Tabulate

gabriel_k — Thu, 15 Oct 2015 21:00:51 GMT

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

Year1 Year2 Year3

Modality1

Modality2

Total

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

Re: Summary Table/ Proc Tabulate

Cynthia_sas — Thu, 15 Oct 2015 21:46:50 GMT

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