Extracting month and year from %sysdate

[chuckdee4]

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

[NickR · Accepted solution]

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.

[chuckdee4]

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

[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.

[chuckdee4]

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

[Vladimir]

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

[Dumitru86]

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;

[may888]

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.

[mkeintz]

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