I've a dataset with visit date format being datetime DATETIME20. and informat YYMMDD10.
I just want to have simple format such as 20051031 or 2005-10-31. I've tried several ways to change the format but the data just appeared in all asterisks as **********. I don't know why the usual solutions didn't work on this dataset this time. I thought it was a simple solution . So thanks in adavance.
ID VisitDate
1 31OCT2005:00:00:00
2 11JAN2006:00:00:00
3 12APR2007:00:00:00
4 18OCT2007:00:00:00
5 10APR2008:00:00:00
The field you are inputting is a datetime field, but you only want to keep the date part. The following would be one way to get what you want:
data have (drop=temp);
informat temp anydtdtm.;
format VisitDate mmddyy10.;
input ID temp;
VisitDate=datepart(temp);
cards;
1 31OCT2005:00:00:00
2 11JAN2006:00:00:00
3 12APR2007:00:00:00
4 18OCT2007:00:00:00
5 10APR2008:00:00:00
;
Thanks a million and for the swift reply. I thought resetting to the date format should work (and it didn't).Didn't realize I needed to create a new variable using the date function. Thanks again.
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.