Dear EG experts, I am a newbie to SAS Enterprise Guide 7.1 slowly learning my way around it. I have no programming knowledge and use the point and click method to do my work. I have been give a project to bench mark some tuition fees with several competitors and one of the components to analyse is the percentage change in fees for the various courses from 2019 to 2020 . The columns in the database that I am interested in looks somewhat like in Table 1 and I want to be able to calculate % change and produce something like Table 2.I have provided screen shots below as an illustration the original data set is much bigger data set and the other columns are not relevant for what i wish to perform. I have also attached a sample excel file Would appreciate any advise as to how I can achieve the results in table 2. For example do I use computed column - advance expression or summary tables I am really stuck on this as I don't know how to do it. Table 1 Raw Data Table 2 (This is the desired outcome required) Thanks for your help much appreciated
... View more