topic Re: Macros for YYMMN in SAS Programming

Macros for YYMMN

Nethra — Mon, 17 Jul 2017 09:46:53 GMT

Hi,

Can someone help me to write the macors for 6 months prior to YYYYMM date in YYMMN format which is already there in Temp dataset as shown below.

ID Region YYYYMM

2205500483 3742 201503

1105661211 3411 201410

2010452387 4605 201501

data _null_;

call symput('Hist',"'"||put(intnx('month', YYYYMM, -6), YYMMN.)||"'");

run;

%put &Hist.;

Proc sql;

Create table Test as

Select id, Region, YYYYMM, &Hist. as Effect_date

from Temp

order by id;

quit;

This step is not working.

Re: Macros for YYMMN

RW9 — Mon, 17 Jul 2017 10:13:02 GMT

You appear to be using Macro (a text generation tool) for what should be a datastep process:

data test;
  set temp;
  effect_date=intnx('month',yymm,-6);
  format effect_date yymm6.;
run;

Re: Macros for YYMMN

Nethra — Mon, 17 Jul 2017 10:47:31 GMT

Thanks for the prompt reply!!!

But i get the result in numeric format as 251103, 251012, 251012 even though format is used.

Thanks !!

Re: Macros for YYMMN

RW9 — Mon, 17 Jul 2017 11:10:11 GMT

Dates and times are numeric. Dates are number of days since Jan1960 for example. How you display them is by using the apropriate format, e.g. yymm. If you need a character varaible - i.e. it is no longer a date - then you use put() function:

data test;
  set temp;
  effect_date=put(intnx('month',yymm,-6),yymm6.);
run;

Re: Macros for YYMMN

Nethra — Tue, 18 Jul 2017 06:57:05 GMT

The output for effect_date is showing as 11M03, 10M12, 11M03....Not getting in YearMonth (201409)

Re: Macros for YYMMN

RW9 — Tue, 18 Jul 2017 07:57:44 GMT

I would suggest do some reading on formats, a minor change to the format is all that is required, however you should know how to display data using formats, its a key item:

data test;
  yymm="12Aug2011"d;
  effect_date=put(intnx('month',yymm,-6),yymmn6.);
run;

Re: Macros for YYMMN

Patrick — Tue, 18 Jul 2017 11:09:01 GMT

@Nethra

Read very carefully everything under this link:

http://support.sas.com/documentation/cdl/en/lrcon/69852/HTML/default/viewer.htm#n0q9ylcaccjgjrn19hvqnd9cte8p.htm

It is very important that you fully understand this and it will make your SAS coding life quite a bit easier if you do so,

Re: Macros for YYMMN

Nethra — Thu, 20 Jul 2017 08:16:53 GMT

Thank you all for helping me !!!! The link is useful one.