Is there a way to use the tabulate procedure to calculate a value other than one of the default statistics? I would like to calculate the change from the base year. Ideally I would like to calculate some values after the all line.
One way to do this is to create a second table and prefill the second table with summary data from the data layer, however the solution is not a clean as calculating inside of SAS.
I would like to create something like this.
Year | 1 | 2 | 3 |
---|---|---|---|
Total | 4347 | 4470 | 4481 |
% Growth Over Prior Year | 2.80% | 0.20% | |
Cumulative Growth Since base year | 2.80% | 3.10% | |
Not currently a feature in Proc Tabulate.
I often pre-summarize data and use tabulate to display the values but depending on what you are doing that approach might be more work than Proc Report.
proc report? Base SAS(R) 9.4 Procedures Guide, Third Edition is his a compute block
I would strongly prefer to stay with tabulate.
Not currently a feature in Proc Tabulate.
I often pre-summarize data and use tabulate to display the values but depending on what you are doing that approach might be more work than Proc Report.
Hi:
TABULATE does not allow you to compute your own (extra) summary lines at the bottom of the report. ALL is what produces the summary line that you show as TOTAL and the other 2 lines would not normally be possible with TABULATE unless you faked out the data and made your own "extra" observations. PROC REPORT is more flexible and more powerful in allowing you to customize and add extra break lines to the report. As Jaap explained, it is the perfect job for a COMPUTE block.
cynthia
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.