I have a proc tab
option validvarname=any; libname stdnt "E:\SAS\Data\Student"; libname robm "f:\robm"; proc tabulate data=ROBM.dump missing contents = ' ' format=COMMA6.0 S=[foreground=highlight.]; class 'Reporting Year'n 'Responsible College'n 'Reporting Year'n; var 'Final Charge'n; keylabel Sum = " "; table ('Responsible College'n ="") all=Total , (('Reporting Year'n="Reporting Year" )*(('Final Charge'n = "")*F=COMMA12.0)) / contents = ' ' misstext=' ' box={label="test"}; run;
that gives
How do I get a 4th column that is the difference of 2017/2018 – 2016/2017 values?
@robm wrote:
How do I get a 4th column that is the difference of 2017/2018 – 2016/2017 values?
Either use proc report which allows referencing result columns in calculations or do all of the summary before, do the calculation in a datastep and use proc tabulate (or report or print) to display the calculated result.
@robm wrote:
How do I get a 4th column that is the difference of 2017/2018 – 2016/2017 values?
Either use proc report which allows referencing result columns in calculations or do all of the summary before, do the calculation in a datastep and use proc tabulate (or report or print) to display the calculated result.
Thanks Ballard
Summary before is the way i went
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.