04-13-2016 04:30 PM
I want to convert the datereturned field from text to number type ( to mmddyy10. Format). It has length $ 10. and format $10.I have tried the below SAS code and it doesn’t work.
Still it display as Text instead of number and values shows as .
length _ datereturned $10.;
put _datereturned = date9.;
Thanks in Advance
04-13-2016 04:47 PM
It doesn't work.
NOTE: Invalid argument to function INPUT at line 22 column 21.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
04-13-2016 11:44 PM - last edited on 04-13-2016 11:54 PM by Reeza
Tried the below code and it worked well
data want (drop=LAST_SURVEY_DATE1); set have; format LAST_SURVEY_DATE mmddyy10.; LAST_SURVEY_DATE = input(LAST_SURVEY_DATE1, ?? yymmdd10.); run;
Thanks for all your responses.
Need further help from the community? Please ask a new question.