DATA Step, Macro, Functions and more

Replace date value

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Replace date value

[ Edited ]

Hi,

I want to look at the date value below

Please let me know how to change the date format as it has char type

source

19700101 01:00:00 

 

 

Target

1970-01-01 01:00:00

 

 

 

 


Accepted Solutions
Solution
‎06-30-2016 07:53 AM
Super User
Posts: 6,927

Re: Replace date value

At least in SAS 9.2, the anydtdtm format coughed up with that string, so I resorted to:

data test;
char_var = '19700101 01:00:00';
date_var = dhms(
  input(substr(char_var,1,8),yymmdd8.),
  input(substr(char_var,10,2),2.),
  input(substr(char_var,13,2),2.),
  input(substr(char_var,16,2),2.)
);
format date_var e8601dt19.;
run;

The ISO 8601 format looks almost like that what the OP wanted.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Super User
Posts: 17,737

Re: Replace date value

You would typically use input but I'm not sure your date is in a format SAS will recognize. 

 

Date_var = input(char_var, anydtdtm.);

fomat date_var datetime21.;

 

If that doesn't work you'll have to separately input each portion, date and time, and then stitch them together again. 

Solution
‎06-30-2016 07:53 AM
Super User
Posts: 6,927

Re: Replace date value

At least in SAS 9.2, the anydtdtm format coughed up with that string, so I resorted to:

data test;
char_var = '19700101 01:00:00';
date_var = dhms(
  input(substr(char_var,1,8),yymmdd8.),
  input(substr(char_var,10,2),2.),
  input(substr(char_var,13,2),2.),
  input(substr(char_var,16,2),2.)
);
format date_var e8601dt19.;
run;

The ISO 8601 format looks almost like that what the OP wanted.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 11

Re: Replace date value

Thank u so much. its really helpful

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 281 views
  • 1 like
  • 3 in conversation