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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.