Hi, @SunTall
First of all, try not to include Excel or Word files with your messages. Many people are leery about opening them, and some companies won't permit it. Set your data up as a data step, as @novinosrin has done. Then we can easily use it in our programs to solve your questions.
I agree completely with @Reeza 's solution. In case you didn't realize it, every step that she lists can be done using the Enterprise Guide tasks, there's no need to do any SAS programming.
Please note that this is a fairly complex requirement...anything more complex might result in you having to do some SAS programming, so I suggest you try to use some of the SAS free educational materials to at least dip your toe into the topic.
Some of the comments in this discussion may seem a little confusing. The SAS REPORT procedure is incredibly powerful, but because of that it can be very challenging to learn. Save that for a future "stretch" assignment!
Tom
/* Cleaned up */
options missing='-';
proc report data=dat.schoolfees nowd;
columns ('Compare Annual Average Fees' 'School Name'n Course)
'Course Fees'n, 'Fees Year'n ('Y over Y' percent);
define 'School Name'n/group;
define Course /group;
define 'Fees Year'n /across;
define 'Course Fees'n/mean ;
define percent/computed f=percent6.2 '% chg';
Compute percent;
percent=(1-(_C3_/_C4_)); /* Variables for the two years) */
endcomp;
format 'Fees Year'n comma9.0;
run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.