topic Re: Format/informat in SAS Programming

Format/informat

buddha_d — Thu, 13 Jul 2017 17:14:37 GMT

SAS gurus, please help
Input should be 12JUN16:16:30:55 and output should look like 06/12/2016 4:30:55 PM

Informat

buddha_d — Thu, 13 Jul 2017 17:13:09 GMT

SAS gurus., need help
Input should be 12JUN16:16:30:55 and output should look like 06/12/2016 4:30:55 PM

Re: Format/informat

art297 — Thu, 13 Jul 2017 18:02:45 GMT

mdyampm format. see: http://support.sas.com/documentation/cdl/en/leforinforref/64790/HTML/default/viewer.htm#p0o3dznogps6ijn1so9wc441wvxx.htm

Art, CEO, AnalystFinder.com

Re: Format/informat

art297 — Thu, 13 Jul 2017 18:35:06 GMT

You can input using the anydtdtm informat. If you don't need seconds then the format I suggested in previous post will work. Otherwise, you could use proc format to create a specialized picture format (see: http://support.sas.com/kb/24/621.html )

Art, CEO, AnalystFinder.com

Re: Format/informat

buddha_d — Thu, 13 Jul 2017 18:41:46 GMT

Thanks it helps