topic Re: Datetime format in SAS Programming

Datetime format

buddha_d — Thu, 13 Jul 2017 16:18:59 GMT

SAS gurus
How to convert date as 06/12/2016 4:30:55 PM (Char 22) From

12JUN16:16:30:55 (numeric 8 information)?

I used informat mdyampm. But it truncates the seconds

Re: Datetime format

data_null__ — Thu, 13 Jul 2017 16:54:49 GMT

The informat creates the correct datetime value. MDYAMPM format does not appear to show seconds but you can see they are there when displayed with DATETIME format.

27         data _null_;
28            x = '06/12/2016 4:30:55 PM';
29            d = input(x,mdyampm22.);
30            put x= d=mdyampm27. d=datetime.;
31            run;

x=06/12/2016 4:30:55 PM d=6/12/2016  4:30 PM d=12JUN16:16:30:55

Re: Datetime format

buddha_d — Thu, 13 Jul 2017 17:02:56 GMT

Input should be 12JUN16:16:30:55 and output should look like 06/12/2016 4:30:55 PM

Re: Datetime format

buddha_d — Thu, 13 Jul 2017 17:03:44 GMT

Please respond soon

Re: Datetime format

data_null__ — Thu, 13 Jul 2017 17:11:37 GMT

You can use the PROC FORMAT and the PICTURE statement to make the format you desire.

Re: Datetime format

ballardw — Thu, 13 Jul 2017 21:57:30 GMT

proc format library=work;
picture Exceldt (default=22)
low-high = '%0m/%0d/%Y %h:%0M:%0S %p' (datatype=datetime);
run;

data _null_;
   x = '12JUN16:16:30:55';
   d = input(x,anydtdtm.);
   put  d= ExcelDt.;
run;

Re: Datetime format

buddha_d — Thu, 13 Jul 2017 22:36:32 GMT

Thank you So much, Ballardw.

I have googled so much to get this, but your experience beats everything. Thanks again. You are great.

Re: Datetime format

buddha_d — Fri, 14 Jul 2017 02:04:56 GMT

Thanks data _null_ it works