01-22-2012 11:58 PM
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.
01-23-2012 12:04 AM
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;
01-23-2012 12:40 AM
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.