Hi SAS community!
My data set has a month-date variable (with values 201212,201301,...) but I want to convert this to text or a date.
Hence I want to change 201212 (best12. fromat) to 2012Feb or something in the similar format where it is only month and year that is displayed.
This is the coding I have at this point, but it doesn't seem to work :
data YPValidated_Monthly;
set t01; /*(the data set I'm getting my data from*/
by application_month;
DATE2 = INPUT(PUT(application_month,6.),MONYY.);
FORMAT DATE2 MONYY.;
run;
Any ideas ? :smileygrin:
Have a look at this code:
Have a look at this code:
Thank you once again Bruno :smileygrin: :smileygrin: :smileygrin:!
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.