08-30-2017 10:06 AM
Depends upon what you want. That is a datetime, not a date. If you want to capture all three you could use something like:
data have; input dt datetime22.; format date date9.; format time time5.; date=datepart(dt); time=timepart(dt); cards; 03JAN2011:00:00:00.000 ;
Art, CEO, AnalystFinder.com
08-30-2017 10:27 AM
If all of the values have the same "time", especially of :00:00:00.000 I would use a DATE9. informat to read the date and discard the time part.
Don't forget to set a display format so humans can see the date in a useable form.
08-30-2017 11:49 AM