topic Re: How to covert charchter string into a date? in SAS Programming

How to covert charchter string into a date?

letsdoit — Tue, 01 Jul 2014 17:02:02 GMT

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!

Re: How to covert charchter string into a date?

ballardw — Tue, 01 Jul 2014 17:31:48 GMT

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.

Re: How to covert charchter string into a date?

JasonAllen — Tue, 01 Jul 2014 17:50:39 GMT

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;