How to covert charchter string into a date?

Reply
Occasional Contributor
Posts: 17

How to covert charchter string into a date?

I have the following:

Date

_1_2_14

_1_3_14

_1_6_14

_1_7_14

_1_8_14

_1_9_14

_1_10_14

and so on.....

and I want to convert it to a date. How can I do that?

Thanks for all the help!

Super User
Posts: 10,552

Re: How to covert charchter string into a date?

is you date month day year or day month year? Can't tell from the example.

data junk;

input datestr :$9.;

date=mdy((scan(datestr,1,'_')),(scan(datestr,2,'_')),(scan(datestr,3,'_')));

format date mmddyy10.;

datalines;

_1_2_14

_1_3_14

_1_6_14

_1_7_14

_1_8_14

_1_9_14

_1_10_14

;

run;

works for month day year if you don't mind warnings about character to numeric conversion.

SAS Employee
Posts: 15

Re: How to covert charchter string into a date?

Hello letsdoit,

Maybe try:

data want;

  length

    cdate $9;

  format

    date ddmmyys10.;

  input

    cdate $;

  cdate=tranwrd(substr(cdate,2),'_','/');

  date=input(cdate,ddmmyy9.);

  drop

    cdate;

datalines;

_1_2_14

_1_3_14

_1_6_14

_1_7_14

_1_8_14

_1_9_14

_1_10_14

;

run;

Ask a Question
Discussion stats
  • 2 replies
  • 198 views
  • 3 likes
  • 3 in conversation