topic Re: Replace date value in SAS Programming

Replace date value

goms — Thu, 30 Jun 2016 11:12:18 GMT

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

Re: Replace date value

Reeza — Thu, 30 Jun 2016 11:25:30 GMT

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.

Re: Replace date value

Kurt_Bremser — Thu, 30 Jun 2016 11:49:30 GMT

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.

Re: Replace date value

goms — Thu, 30 Jun 2016 11:53:21 GMT

Thank u so much. its really helpful