Hi all,
I have a dataset that looks something like this:
acc_num year int_2001 int_2002 int_2003 ....
A 2001 0.05
B 2002 0.03 0.04
C 2003 0.01 0.03 0.04
Basically, I want to create a new variable interest that is equal to the interest of that year, so for example, for acc_num "C", I want to have the interest equal to 0.04 because I want to get the interest when year 2003 is the same as the last 4 numbers of the column title "int_2003"
When can I write the program to do that? Thank you very much!
Create an array and assign an index that maps to the year
array int_rate(2001:2003) int_2001 - int_2003;
interest_year = int_rate(year);
Create an array and assign an index that maps to the year
array int_rate(2001:2003) int_2001 - int_2003;
interest_year = int_rate(year);
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.