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
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
;
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
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.
The id datatype is int, sys_date is datetime and tran_amount is decimal(25,6) from the source system.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.