Calculating Percentage Change in Enterprise Guide 7.1

[TomKari]

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]

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.

[TomKari]

Here are a couple of options.

Tom

https://blogs.sas.com/content/sasdummy/2013/01/21/turn-your-data-set-into-a-data-step-program/ 

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... 

[ghosh]

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