topic Macro Variable in SAS Programming

Macro Variable

cbob — Thu, 08 Mar 2012 21:34:59 GMT

Hi,

I have the below macro variable which outputs 1202.

%Let yymm = %sysfunc(putn(%sysfunc(intnx(month,%sysfunc(today()),-1,end)),yymmn4.));

Now I want to use the above macro variable(&yymm.) and output ONLY the year in YYYY format(2012).

%Let yyyy = %sysfunc(year(&yymm.));

I tried the above step and it is giving me 1963 as output. Can someone take a look?

Thanks in advance!.

Macro Variable

KarlK — Thu, 08 Mar 2012 21:44:11 GMT

%let yyyy = %sysfunc(year(%sysfunc(inputn(&yymm,yymmn4.))));

HTH,

Karl

Macro Variable

Patrick — Thu, 08 Mar 2012 21:51:34 GMT

Macro var &yymm contains a string like 1209. The year function expects a SAS date value (date expressed as number of days since 1/1/1960).

1209 days is a date in the year 1963.

If you want to use the year function then you née first to convert you string back to a SAS date (using a information - not sure if there is one for your date format).

Macro Variable

cbob — Thu, 08 Mar 2012 21:55:46 GMT

It worked!!!. Thanks Karl..