topic how to get the last two digits of a year in SAS Programming

how to get the last two digits of a year

Celia — Sun, 20 Oct 2013 21:59:46 GMT

I'm trying to pull out the last two digits of a year. I used the following code, but i get the answer of 65. Can anyone suggest a way I could do this?

%let yeartest=2002;

%let yeartest2=%sysfunc(putn(&yeartest,year2.);

I would like to have as the result a variable storing 02

Thanks,

Celia.

Re: how to get the last two digits of a year

Tom — Sun, 20 Oct 2013 23:02:29 GMT

In your example just use %SUBSTR() function.

%let yeartest=2002;

%let yeartest2=%substr(&yeartest,3) ;

If you want to find the last two digits of a DATE value then you can use the YEAR2. format.

%let yeartest2=%sysfunc(today(),year2.);

%let yeartest2=%sysfunc(putn("01JAN1960"d,year2.)) ;

Re: how to get the last two digits of a year

Celia — Mon, 21 Oct 2013 00:50:55 GMT

Thanks for your help Tom. Works a treat.