topic Re: extact monthdate format from sysdate in sas macros in SAS Programming

extact monthdate format from sysdate in sas macros

BrahmanandaRao — Fri, 14 Apr 2023 11:42:56 GMT

%let date=&sysdate9.;
%put &date;
%let month_year=%sysfunc(inputc("&date",date9.),monyy7.);
%put month_year;

Here i am trying output monyy7. (APR2023) using sysdate9.

required output

APR2023

Re: extact monthdate format from sysdate in sas macros

PaigeMiller — Fri, 14 Apr 2023 12:12:40 GMT

%let month_year=%sysfunc(inputn(&date,date9.),monyy7.);

Re: extact monthdate format from sysdate in sas macros

BrahmanandaRao — Fri, 14 Apr 2023 11:56:12 GMT

hi miller

it shows only text as below i think macro processor cannot read macro variable

month_year

Re: extact monthdate format from sysdate in sas macros

PaigeMiller — Fri, 14 Apr 2023 12:03:25 GMT

@BrahmanandaRao wrote:

hi miller

it shows only text as below i think macro processor cannot read macro variable

month_year

Its really unclear what you mean by this. My code works properly. When something doesn't work, you need to show us the code you are using that isn't working. Saying something doesn't work is never sufficient. We don't know what you did, you have to SHOW us.

Re: extact monthdate format from sysdate in sas macros

Tom — Fri, 14 Apr 2023 13:22:09 GMT

You are working way too hard.

You have a 9 character string and you want the last 7 characters of it.

644  %let month_year=%substr(&sysdate9,3);
645  %put &=sysdate9 &=month_year ;
SYSDATE9=13APR2023 MONTH_YEAR=APR2023