Hello,
on my dataset I have a column in date format such as "12Sep07:0:0:0" and I want to convert this in to "Sep07" I tried put(mmyyyyp8.) and another variations but without success.
Do you have any idea how to convert this variable?
Many thanks!
Daniela
How about this,Daniela?
data temp;
date = '12Sep07:00:00:00'dt;*your date;
date_1 = put(datepart(date),monyy.);*your desired date;
run;
Good luck.
Anca.
How about this,Daniela?
data temp;
date = '12Sep07:00:00:00'dt;*your date;
date_1 = put(datepart(date),monyy.);*your desired date;
run;
Good luck.
Anca.
Hello Anca,
it worked! Tahnk you very much.
Kind regards,
Daniela
Great,Daniela.
Would you mark it as answered
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.