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);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.