I am having trouble trying to format dates with single-digit days (no leading zero). The date in the dataset, in particular, corresponds to February 1st, 2000. **EDIT** rookie mistake. I forgot to check my log and thought anydtdtew gave an actual output. data want;
format date mmddyy10.;
informat date anydtdte.;
INPUT date;
datalines;
0212000
; Running this code gets me an incorrect date: 06/08/2540 The following output I want is in the format mmddyy10. : 02/01/2000 So I believe the problem lies in the informat anydtdte., however, I am not sure which informat to use. I've tried other types of informats (mmddyy7.) but I can't seem to find the right one. Thanks. ** Solved using CAT and SUBSTR functions to transform the date.
... View more