topic Re: Current year in New SAS User

Current year

yesidgranadosv — Fri, 12 Apr 2019 19:40:09 GMT

I need the current year and save it in a variable %let

novinosrin — Fri, 12 Apr 2019 19:41:39 GMT

Current year from what?

today()?

todatetime()?

yesidgranadosv — Fri, 12 Apr 2019 19:44:47 GMT

/*Año y mes*/
data _null_;
call symputx('Fetch_M', put(intnx ('month',today(),-2),yymmn6.) );
run;

%put Fetch_M = &Fetch_M.;

I have the code that generates me YEAR-MONTH

to need current year in format "2019"

novinosrin — Fri, 12 Apr 2019 19:49:22 GMT

Are you asking

data _null_;
call symputx('Fetch_M', put(intnx ('month',today(),-2),yymmn6.) );
run;

%put Fetch_M = &Fetch_M.;

%put year=%substr( &Fetch_M.,1,4);

Log
5 %put Fetch_M = &Fetch_M.;
Fetch_M = 201902
6 %put year=%substr( &Fetch_M.,1,4);
year=2019

Or in %let

%let year=%substr( &Fetch_M.,1,4);

%put &=year;

yesidgranadosv — Fri, 12 Apr 2019 19:53:10 GMT

great!!!

%let year=%substr( &Fetch_M.,1,4);

%put &=year;

But if I want to subtract it 1 or 2 years ago?

novinosrin — Fri, 12 Apr 2019 19:56:41 GMT

Are you asking for this

data _null_;
call symputx('Fetch_M', put(intnx ('month',today(),-2),yymmn6.) );
run;

%put Fetch_M = &Fetch_M.;

%let year=%substr( &Fetch_M.,1,4);

%let subtracted_year=%eval(&year-2);

%put &=subtracted_year;

Reeza — Fri, 12 Apr 2019 20:54:10 GMT

%let currentYear = %sysfunc(today(), year4.);
%put &currentYear.;

TODAY() returns todays date.

%SYSFUNC() takes two parameter, a SAS function (TODAY()) and the format used. YEAR4 converts it to the year.