BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
TomKari
Onyx | Level 15

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

SunTall
Calcite | Level 5
Thank you @Tom for the advise will keep it in mind for future, the file i provided is not an original. The data set I attached is fictitious with fictitious names and numbers. Wouldn't mind knowing how I can set the data up as a data step though.
ghosh
Barite | Level 11

/* 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;

Untitled.png 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 18 replies
  • 6479 views
  • 15 likes
  • 6 in conversation