concatenate macro variable with conditional rule

Ronein — Mon, 19 Jul 2021 04:39:44 GMT

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;

Re: concatenate macro variable with conditional rule

Tom — Mon, 19 Jul 2021 04:47:46 GMT

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?

topic concatenate macro variable with conditional rule in SAS Programming

concatenate macro variable with conditional rule

Re: concatenate macro variable with conditional rule