Hi Guys, im sure this is out there somewhere but cannot for the life of me find it. Maybe using the wrong key words to search. Anyway... what im looking to do is add in a compute variable in a proc report to show percentage change between two months. I have multiple across variables, at the top there is risk level with options 1, 2 and 3. Then the next across variable is month which is either Current or Previous. I then need a compute variable to show the percentage change. There is also a grouped variable of sectors. My current code is as follows... proc report data=temp;
Title "Table 1.1";
Column sector risk_level , month,(cost);
define sector / group "Sector";
define risk_level / across "";
define month / across "";
define cost / analysis sum format=comma14. "";
rbreak after / dol skip summarize;
run; which gives the below table as an output Risk Level 1 Risk Level 1 Risk Level 2 Risk Level 2 Risk Level 3 Risk Level 3 Sector Current Month Previous Month Current Month Previous Month Current Month Previous Month Sector 1 613,824 55,498 457,137 687,889 817,745 747,244 Sector 2 268,295 644,344 592,035 983,231 179,525 875,174 Sector 3 184,796 557,766 190,897 705,149 984,726 524,934 Sector 4 112,054 117,790 37,873 483,057 723,435 858,327 Sector 5 342,069 995,892 480,019 158,641 597,644 467,956 Sector 6 389,570 398,725 330,186 53,723 296,942 997,574 Total 1,910,606 2,770,016 2,088,146 3,071,690 3,600,015 4,471,210 I have tried something similar to below define change / computed;
compute change;
_c4_ = _c3_ - _C2_;
_c7_ = _c6_ - _C5_;
_c10_ = _c9_ - _C8_;
endcomp; but always get an error. Any ideas?
... View more
