How to convert String to Date value in SAS?

Question

I want to convert a String to Date in SAS, I tried: data _null_; monyy = '05May2013'; date = input(substr(strip(monyy),1,9),yymmdd.);; put date=date9.; run; But it did not work. Can this be done?

Answer 1

Here is the solution:

data raa;

monyy='05May2013';

format date date9.;

date=input(monyy, date9.);

run;

proc contents; run;

notice that in the PROC CONTENTS, monyy is character and date is numeric.