topic Re: How to convert string variable to date? in SAS Programming

How to convert string variable to date?

o_p — Mon, 21 Sep 2015 18:05:00 GMT

data have;
yearmonth='200801';
run;

What is the best way to have same variable as date?

I mean it must be shown as 200801 again, but in date format.

Thanks,

Re: How to convert string variable to date?

PaigeMiller — Mon, 21 Sep 2015 18:23:57 GMT

Is this what you are looking for?

yearmonth2=input(yearmonth,yymmn6.);

Re: How to convert string variable to date?

ballardw — Mon, 21 Sep 2015 18:45:35 GMT

And use

Format yearmonth2 yymm6.;

for display.

Re: How to convert string variable to date?

PaigeMiller — Mon, 21 Sep 2015 19:00:03 GMT

Good point, @ballardw!

Re: How to convert string variable to date?

o_p — Mon, 21 Sep 2015 20:06:20 GMT

data have;
yearmonth='200801';
yearmonth2=input(yearmonth,yymmn6.);
Format yearmonth2 yymmn6.;
run;

That's OK. 🙂

Re: How to convert string variable to date?

Steelers_In_DC — Tue, 22 Sep 2015 16:44:34 GMT

data have;
yearmonth='200801';
run;

data want;
format date yymmn6. date2 mmddyy10.;
set have;
date = input(put(yearmonth,$6.),yymmn6.);
date2 = intnx('month',date,0,'end');
run;