08-15-2017 11:43 AM - edited 08-15-2017 11:45 AM
Change format from DATEAMPMw. to DATETIMEw. where w is length of output dislaying date and time.
If time is 13:42 there is no need to add PM.
08-15-2017 05:18 PM
08-15-2017 06:36 PM - edited 08-15-2017 06:41 PM
When you use function TIMEPART you have time only, without the date.
format DATETIME is to be used with your variable Open_Date.
Use format time5. or time7. for TIME (as timepart).
Data table1; Set table1; Time =timepart (open _date); Format open_date datetime. time time7.; Run;
Look at next link - formats by categories:
08-16-2017 12:38 PM
08-16-2017 01:52 PM
Time =timepart (open_date);
which gives you a date of 01jan60 - this turns a red light, maybe your variable Open_Date is not a datetime but a time only.
In sas 0 (zero) is equal to Jan 1st 1960.
Data _NULL_; set have; put open_date time9.; run;
and check the log.