Hello
I want to create a macro variable called vector .
Condition 1:
If data set transtbl doesn't exist then vector will get value of 2009+2010+.....+....+current month
(For example: ?If current month is July 2021 then the macro variable will get value 2009+2010+2011+2012+2101+2102+2103+2104+2105+2106+2107)
Condition 2:
If data set transtbl exists then vector will get value of :
one month after min month in data set transtbl +.....................+ current month
(so for example if min month of field date in data set transtbl is 02Mar2021 and current month is July 2021 then vector will get value 2103+2104+2105+2106+2107
Data transtbl ;
Format date date9.;
Input Id date : date9. amount;
cards;
1 18MAY2021 100
2 21FEB2021 200
3 08FEB2021 300
4 11MAR2021 100
5 27FEB2021 400
6 02FEB2021 800
7 20JUN2021 900
8 29MAY2021 100
9 17FEB2021 200
10 15FEB2021 300
;
Run;
So what did you try? How did it not work?
You seem to have left out a key piece of information. What is the meaning of those four digit strings between the plus signs?
Are we supposed to guess what they mean?
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.