topic Re: Week date input problem in SAS Programming

Week date input problem

emrancaan — Mon, 23 Apr 2018 13:15:01 GMT

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;

Re: Week date input problem

Kurt_Bremser — Mon, 23 Apr 2018 13:24:24 GMT

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.

Re: Week date input problem

emrancaan — Mon, 23 Apr 2018 13:37:29 GMT

Hi Kurt,

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

Re: Week date input problem

Kurt_Bremser — Mon, 23 Apr 2018 13:43:49 GMT

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;