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;