https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Calculating-percent-change/m-p/4926#M417 Hi,<BR /> I have data like the following with two variables (old and new):<BR /> <BR /> Old New<BR /> 5 8<BR /> 2 6<BR /> 10 3<BR /> 54 48<BR /> 25 14<BR /> ................and so on.<BR /> How do I calculate the percent change from the old to the new using SAS? <BR /> thanks very much! Wed, 03 Oct 2007 16:37:33 GMT deleted_user 2007-10-03T16:37:33Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Calculating-percent-change/m-p/4926#M417 Hi,<BR /> I have data like the following with two variables (old and new):<BR /> <BR /> Old New<BR /> 5 8<BR /> 2 6<BR /> 10 3<BR /> 54 48<BR /> 25 14<BR /> ................and so on.<BR /> How do I calculate the percent change from the old to the new using SAS? <BR /> thanks very much! Wed, 03 Oct 2007 16:37:33 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Calculating-percent-change/m-p/4926#M417 deleted_user 2007-10-03T16:37:33Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Calculating-percent-change/m-p/4927#M418 data numbers;<BR /> input old new;<BR /> datalines;<BR /> 5 8<BR /> 2 6<BR /> 10 3<BR /> 54 48<BR /> 25 14<BR /> run;<BR /> <BR /> data perchange;<BR /> set numbers;<BR /> perchg = ((New-old)/old)* 100;<BR /> run;<BR /> <BR /> I think this should help. Format you perchg to limit the display of the decimals.<BR /> <BR /> APS Wed, 03 Oct 2007 17:31:19 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Calculating-percent-change/m-p/4927#M418 deleted_user 2007-10-03T17:31:19Z