topic Re: Create parameter from another parameter in SAS Programming

Define the following parameter of dates (YYMM)

Ronein — Wed, 07 Mar 2018 11:59:44 GMT

Hello

I have the following question

I define the following parameter of dates (YYMM).

%let vector=1708+1707+1706+1612;

I want to create base on vector parameter another parameter called tarr that includes also 4 arguments with + symbol between them.

Each argument is created by subscribing 12 months and take end of month.

The wanted parameter is

'31AUG2016'd+'31JUL2016'd+'30JUN2016'd+31DEC2015'd

Can anyone help to do it please?

Thanks

Re: Hello I have the following question I define the following parameter of dates (YYMM). %let vec

RW9 — Wed, 07 Mar 2018 09:20:55 GMT

To what purpose? Data should go in datasets, datasets and Base SAS are created to manipulate and use data, hence why they have the various formats and functions. Macro is not for processing data it is a text find an replace system. Your wanted is just a more complicated way of refering to the numbers already there.

Now you can do it of course, but it really isn't good practice as your just patching bad code:

%let vector=1707+1708+1706+1608;

data _null_;
  length tmp $2000;
  do i=1 to countw("&vector.");
    tmp=catx('+',tmp,cats("'",put(input(scan("&vector.",i,"+"),best.),date9.),"'d"));
  end;
  call symputx('want',tmp);
run;

%put &want.;

However there is nothing redeeming about coding like that whatsoever.

Create parameter from another parameter

Ronein — Wed, 07 Mar 2018 09:21:31 GMT

Hello

I have the following question

I define the following parameter of dates (YYMM).

%let vector=1708+1707+1706+1612;

I want to create base on vector parameter another parameter called tarr that includes also 4 arguments with + symbol between them.

Each argument is created by subscribing 12 months and take end of month.

The wanted parameter is

'31AUG2016'd+'31JUL2016'd+'30JUN2016'd+31DEC2015'd

Can anyone help to do it please?

I know that in order to find end of month date we can use the function

intnx('month',mon_now_minus12M_date,0,'E')

Thanks

Re: Hello I have the following question I define the following parameter of dates (YYMM). %let vec

Kurt_Bremser — Wed, 07 Mar 2018 09:23:17 GMT

I merged the two identical questions.

Re: Create parameter from another parameter

RW9 — Wed, 07 Mar 2018 09:39:19 GMT

I know that in order to find end of month date we can use the function

intnx('month',mon_now_minus12M_date,0,'E')

Even more reason to use Base SAS then, you have the given formula, use that in code, still don't see what a parameter list fits in?

Re: Hello I have the following question I define the following parameter of dates (YYMM). %let vec

Ronein — Thu, 08 Mar 2018 07:01:16 GMT

Hello

Thanks for your reply.

The code is running well but the output dates are not as we want.

%let vector=1707+1708+1706+1608;

The required output is

%let tarr='31Aug2016'd+'31Jul2016'd+'30Jun2016'd+'31Dec2015'd;

(It is calculated by minus 12 months and taking end of month )

thanks

Ronein

Re: Create parameter from another parameter

RW9 — Thu, 08 Mar 2018 09:38:07 GMT

Ah, ok, then use the intnx function like this:

%let vector=1707+1708+1706+1608;

data test /*_null_*/;
  length tmp $2000;
  do i=1 to countw("&vector.");
    pdate=intnx('month',input(cats(scan("&vector.",i,"+"),"01"),yymmdd8.),-12,"e");
    tmp=catx('+',tmp,cats("'",put(pdate,date9.),"'d"));
  end;
  call symputx('want',tmp);
run;

%put &want.;