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.
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.);
or
%let yeartest2=%sysfunc(putn("01JAN1960"d,year2.)) ;
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.);
or
%let yeartest2=%sysfunc(putn("01JAN1960"d,year2.)) ;
Thanks for your help Tom. Works a treat.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.