format date

[archibald]

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 · Accepted solution]

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]

oh I see.

Never mind I fixed it. Thanks

[Reeza]

@archibald Please mark the question as solved.