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);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.