Week date input problem

[emrancaan]

Please advise how to readin following week date.

Data Test;
input weekdate ; 
format weekdate	DTWKDATX25.;  
datalines; 
Saturday, March 31, 2018
Monday April 2, 2018
;
Run;

[Kurt_Bremser]

You only have dates, so a datetime format won't work.

The anydtdte informat can read a written (US style) date:

data test;
input date anydtdte30.;
format date yymmddd10.;
cards;
march 31,2018
;
run;

You need to remove the weekday first.

[emrancaan]

Hi Kurt,

I want to read Saturday March 31, 2018 and store it in date type variable as it is.

[Kurt_Bremser · Accepted solution]

You need to remove the redundant weekday first with substr(), then anydtdte will recognize the date:

data test;
input datestr $30.;
i = index(datestr,' ');
date = input(substr(datestr,i),anydtdte30.);
drop i;
format date weekdate30.;
cards;
Saturday March 31, 2018
;
run;