topic Re: format date in SAS Programming

format date

archibald — Tue, 04 Oct 2016 17:20:50 GMT

hi,

I have a character date variable 11292000 wich I would like to convert into 20001129.

I used:

data want ;

set have ;

newdate=input (olddate, yymmdd8. ); but the code does not work.

any ideas? thanks

ballardw — Tue, 04 Oct 2016 17:34:45 GMT

Of course that wouldn't work. You were telling SAS to read the value 1129 as the year.

data want ;
   set have ;
   newdate=input (olddate, mmddyy8. );  
   FORMAT newdate yymmdd8.;
run;

You may get warnings about conversion of numeric to character if your olddate variable is numeric as INPUT expects character values.

archibald — Tue, 04 Oct 2016 17:36:20 GMT

oh I see.

Never mind I fixed it. Thanks

Reeza — Tue, 04 Oct 2016 20:13:31 GMT

@archibald Please mark the question as solved.