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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: