DATA Step, Macro, Functions and more

how to read mdyampm. dates (09/22/2015 20:15:32 AM)

Accepted Solution Solved
Reply
Contributor
Posts: 40
Accepted Solution

how to read mdyampm. dates (09/22/2015 20:15:32 AM)

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


Accepted Solutions
Solution
‎10-23-2015 08:32 PM
Respected Advisor
Posts: 4,173

Re: how to read mdyampm. dates (09/22/2015 20:15:32 AM)

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.

View solution in original post


All Replies
Solution
‎10-23-2015 08:32 PM
Respected Advisor
Posts: 4,173

Re: how to read mdyampm. dates (09/22/2015 20:15:32 AM)

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 topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 173 views
  • 0 likes
  • 2 in conversation