SAS Date conversion

[iluvsas]

I have a pipe delimited .txt file with the date in the below format. How do I convert it to a more meaningful sas date - 15DEC2012 9:20 PM

12-15-2011 09:20:30.000000PM

[art297]

data have;

  infile cards dsd delimiter="|";

  informat dt anydtdtm28.;

  format dt datetime21.;

  input sex $ dt;

  cards;

M|12-15-2011 09:20:30.000000PM

F|10-02-2012 08:20:30.000000AM

;

[shivas]

Hi,

If you want AM/PM then you can use dateampm format to display(using Art code and data).

data want;

  infile cards dsd delimiter="|";

  informat dt anydtdtm.;

  format dt dateampm16.;

  input sex $ dt;

  cards;

M|12-15-2011 09:20:30.000000PM

F|10-02-2012 08:20:30.000000AM

;

run;

Thanks,

Shiva

[iluvsas]

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.

[iluvsas]

The id datatype is int, sys_date is datetime and tran_amount is decimal(25,6)  from the source system.