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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.