topic Re: SAS Date conversion in SAS Programming

SAS Date conversion

iluvsas — Mon, 07 May 2012 03:09:13 GMT

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 — Mon, 07 May 2012 03:25:55 GMT

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 — Mon, 07 May 2012 10:37:50 GMT

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 — Mon, 07 May 2012 15:30:19 GMT

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 — Mon, 07 May 2012 16:10:27 GMT

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