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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.