topic Convert Macro YYYYMM to Dataset variable monyy7. in SAS Programming

Convert Macro YYYYMM to Dataset variable monyy7.

david27 — Fri, 08 Oct 2021 17:16:55 GMT

I have this:

%let yyyymm=202109;
data temp;
format yearmonth monyy7.;
yearmonth=&yyyymm.;
run;

The resulting yearmonth variable has value "MAY2513"

Want:

It should be 'SEP2021'

Re: Convert Macro YYYYMM to Dataset variable monyy7.

Tom — Fri, 08 Oct 2021 17:27:19 GMT

If you want the variable YEARMONTH to work with a date type format, such as MONYY, then it has to have date values, not random numbers like 202,109.

yearmonth=input("&yyyymm.01",yymmdd8.);

Re: Convert Macro YYYYMM to Dataset variable monyy7.

AMSAS — Fri, 08 Oct 2021 17:36:15 GMT

@david27
In SAS 202,109 is a number it is not a date. SAS stores dates as the number of days since 01/01/1960 (day 0), so 202109 is a day in May 2513.
What you need to do is convert 2021-09 into a SAS date value
There's a number of ways to do this, probably the simplest is the MDY function
Please review the documentation links and feel free to ask any additional questions

Re: Convert Macro YYYYMM to Dataset variable monyy7.

Reeza — Fri, 08 Oct 2021 17:36:34 GMT

%let yyyymm=202109;

data temp;
format yearmonth monyy7.;
yearmonth=input("&yyyymm.", yymmn6.);
run;

proc print;run;

@david27 wrote:

I have this:
%let yyyymm=202109;
data temp;
format yearmonth monyy7.;
yearmonth=&yyyymm.;
run;
The resulting yearmonth variable has value "MAY2513"

Want:

It should be 'SEP2021'