05-07-2012 06:37 AM
If you want AM/PM then you can use dateampm format to display(using Art code and data).
infile cards dsd delimiter="|";
informat dt anydtdtm.;
format dt dateampm16.;
input sex $ dt;
05-07-2012 11:30 AM
Hi, I have the input pipe delimited file in the below format with the fields -> id, sys date, tran_amount
10000000|Oct 14 2011 10:53:09:240PM|0.000000
I need to read the id as -> 10000000
sys_date as -> 14OCT2011 10:53 PM
tran_amount as -> 0.000000
and load the above values in the format defined above into a sas dataset.