topic Re: Extracting month and year from %sysdate in SAS Programming

Extracting month and year from %sysdate

chuckdee4 — Fri, 08 Apr 2011 12:34:54 GMT

Hello,

I am trying to use the current month and year from %sysdate or any other function within a report.
Would anyone know how to extract these values and assign them to a variable or macr variable.

Thanks

Re: Extracting month and year from %sysdate

NickR — Wed, 16 Aug 2017 12:56:13 GMT

Following program creates both data step variables and macro variables.

data test;
month = month(input("&sysdate9",date9.));
year = year(input("&sysdate9",date9.));
call symput('month',compress(put(month,best.)));
call symput('year',compress(put(year,best.)));
run;

%put &year;
%put &month;

And from @ballardw:

And a way to do it without a data step:
%let sysmonth= %sysfunc(month("&sysdate"d));
%let sysyear= %sysfunc(year("&sysdate"d));

%put &sysmonth &sysyear;
Remember that SYSDATE has the start date of the SAS session, not the calendar date at the time of execution.

Re: Extracting month and year from %sysdate

chuckdee4 — Fri, 08 Apr 2011 13:46:24 GMT

Many thanks Nick will apply this and advice on how it goes.

Re: Extracting month and year from %sysdate

ballardw — Fri, 08 Apr 2011 20:54:46 GMT

And a way to do it without a data step:

%let sysmonth= %sysfunc(month("&sysdate"d));
%let sysyear= %sysfunc(year("&sysdate"d));

%put &sysmonth &sysyear;

Remember that SYSDATE has the start date of the SAS session, not the calendar date at the time of execution.

Re: Extracting month and year from %sysdate

chuckdee4 — Mon, 11 Apr 2011 21:21:51 GMT

Nick the codes worked just fine, thanks

Ballardw, many thanks for your suggestion seems to do the sae job with less code, will implement it in future projects

Re: Extracting month and year from %sysdate

Vladimir — Tue, 02 Aug 2016 13:52:10 GMT

I' d like to get month as Jun for example. Is it possible?

Re: Extracting month and year from %sysdate

Dumitru86 — Thu, 13 Oct 2016 11:21:09 GMT

Hi Nick

I have found this very useful, but I recently come across a situation slightly different. The macro returns the below values, but for my code I need it to say "OCT" rather than "10". I have tried formatting but it did not work. Is there a way to amend this code to get it to output the character 3 letter name of the month? Thanks

macro result:

10 2016

format attempt:

proc format;

value $ monthnew '10' ='OCT';

run;

data test;

month = month(input("&sysdate9",date9.));

year = year(input("&sysdate9",date9.));

call symput('month',compress(put(month,monthnew.)));

call symput('year',compress(put(year,best.)));

run;

%put &year;

%put &month;

Re: Extracting month and year from %sysdate

may888 — Fri, 02 Dec 2016 17:49:41 GMT

I'd like to automate a YTD report that pulls data from January to December every year. There is always a 1-month lag.

Run date date parameter for data

December 2016 January to November 2016

January 2017 January to December 2016

February 2017 January to January 2017

Any code you can share is greatly appreciated.

Re: Extracting month and year from %sysdate

mkeintz — Fri, 02 Dec 2016 19:21:49 GMT

Instead of re-activating a zombie topic, start a new one, using appropriate title.