BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,
I have data like the following with two variables (old and new):

Old New
5 8
2 6
10 3
54 48
25 14
................and so on.
How do I calculate the percent change from the old to the new using SAS?
thanks very much!
1 REPLY 1
deleted_user
Not applicable
data numbers;
input old new;
datalines;
5 8
2 6
10 3
54 48
25 14
run;

data perchange;
set numbers;
perchg = ((New-old)/old)* 100;
run;

I think this should help. Format you perchg to limit the display of the decimals.

APS

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 1 reply
  • 6285 views
  • 0 likes
  • 1 in conversation