SAS Date conversion

Reply
Occasional Contributor
Posts: 9

SAS Date conversion

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


PROC Star
Posts: 7,363

Re: SAS Date conversion

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

;

Super Contributor
Posts: 349

Re: SAS Date conversion

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

Occasional Contributor
Posts: 9

Re: SAS Date conversion

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.


Occasional Contributor
Posts: 9

Re: SAS Date conversion

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

Ask a Question
Discussion stats
  • 4 replies
  • 369 views
  • 0 likes
  • 3 in conversation