topic Re: How to create these maro variable? in New SAS User

How to create these maro variable?

JP1234 — Fri, 11 Jan 2019 16:36:44 GMT

I have a date

%let mydate = 20180112; /*yyyymmdd */

I want to create macro vaiable suffix = 201709_201811; /*(yyyymm-yyyymm)*/

How can i do that?

Thanks,

Jeff

Re: How to create these maro variable?

PaigeMiller — Fri, 11 Jan 2019 16:47:06 GMT

I'm probably not understanding the problem, but ... based on what you said, you create the suffix macro variable as

%let suffix = 201709_201811;

Re: How to create these maro variable?

JP1234 — Fri, 11 Jan 2019 17:02:04 GMT

I want to derive suffix from my_date for later use.

I tried this code but it did not work

%let my_date = 20180112; /* YYYYMMDD */

data suff;

format ref_date date9.;

ref_date = mdy(substr(put(&my_date,$8.),5,2), substr(put(&scoring_date,$8.),7,2), substr(put(&scoring_date,$8.),1,4));

suffix=catx('_','put(intnx('month',ref_date,-16),yymm.));',put(intnx('month',ref_date,-1),yymm.));

 

run;

 

proc sql;

select suffix into :suffix 

from suff;

quit.

it doest work.

Thanks,

Jeff

quit;

Re: How to create these maro variable?

Cynthia_sas — Fri, 11 Jan 2019 17:33:32 GMT

Hi:
Saying it just doesn't work is rather vague. Are you getting ERROR messages or WARNING messages in the SAS log? If so, have you tried to determine why you're getting those messages?

What is the purpose of the SQL step? If you need a macro variable why not create it with CALL SYMPUT in the DATA step program where you are creating SUFFIX?? You don't need a separate SQL step.

What is the disposition of &SUFFIX or, how do you plan to use it? Why is &MY_DATE a macro variable? What is the value for &SCORING_DATE? No one can run your code because you only provide a value for &MY_DATE.

Since no one can run your code without values for &SCORING_DATE and since you have an error in the SQL code (period after quit), It is hard to figure out what you need or why you've used this approach.

Can you clarify?
Thanks,
Cynthia

Re: How to create these maro variable?

ballardw — Fri, 11 Jan 2019 17:33:49 GMT

Why not use

Ref_date= input("&my_date.",yymmdd8);

instead of futzing around with string functions AND not ever turning the strings into the numeric values that MDY requires. Which is what is generating multiple errors in your existing code.

Or changing the value of your my_date variable and using that directly

%let mydate=12JAN2018;

suffix=catx('_','put(intnx('month', "&my_date."d ,-16),yymm.));',put(intnx('month', "&my_date."d ,-1),yymm.));