Hi
I have following csv data
sample data:
id,created_date,modified_date
1021,12/23/2014 12:12:37 AM,9/21/2015 09:56:02 AM
1024,09/12/2015 04:24:00 PM,10/21/2015 11:44:03 AM
I have code:
DATA sample;
INFILE '/path/file' dsd dlm=',' firstobs=2 ;
ATTRIB
id informat = $5. format=$5.;
created_date informat=mdyampm. format=mdyampm.
modified_date informat=mdyampm. format=mdyampm. ;
INPUT id $ created_date Modified_date;
;run;
in My out put I am getting values for date variables like 9/21/2015 09:56:02 AM.
How Can I get dates like 9/21/2015 21:56:02 or datestamp (24 hours format without AM, PM). What is the right format I need to use for dates.
Thank you
This is a duplicate of this post https://communities.sas.com/t5/Base-SAS-Programming/how-to-read-mdyampm-dates-09-22-2015-20-15-32-AM...
Please delete it and ask your question only once in a single forum.
This is a duplicate of this post https://communities.sas.com/t5/Base-SAS-Programming/how-to-read-mdyampm-dates-09-22-2015-20-15-32-AM...
Please delete it and ask your question only once in a single forum.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.