topic Re: Subsetting data with date and string for a do function in SAS Programming

Subsetting data with date and string for a do function

Prash — Sat, 05 Dec 2015 15:23:34 GMT

I am getting error for this code, not knowing where I am missing.

data want;

data have;

if centre in ('Shai','Hub','imen') and Date_of_Birth between mdy(3,01,1953) and mdy(6,30,1974) then status = 'pass';

run;

Not sure where I am missing, I tried with where as well but not succeeding, apart from that also checked with do end , But could not get the required result, Can any one help on this

Thanks

Re: Subsetting data with date and string for a do function

stat_sas — Sat, 05 Dec 2015 16:17:29 GMT

Seems like you need set statement

data want;

set have;

if centre in ('Shai','Hub','imen') and Date_of_Birth between mdy(3,01,1953) and mdy(6,30,1974) then status = 'pass';

run;

Re: Subsetting data with date and string for a do function

Reeza — Sat, 05 Dec 2015 18:09:08 GMT

Also, you can't use BETWEEN with an IF statement, only a WHERE statement. So either change to where or switch the comparison to mdy(3, 1, 1953)<=date_of_birth<=mdy(6, 30, 1974)

Re: Subsetting data with date and string for a do function

Prash — Mon, 07 Dec 2015 08:17:08 GMT

Agree with you,

Actually it has to be

Data want;

set have;

run;

It was a typo sorry for that. However running the mentioned codes by replacing with Set is not deriving the expected result

Re: Subsetting data with date and string for a do function

Prash — Mon, 07 Dec 2015 11:25:32 GMT

Hello Reeza,

I got the solution, However if I use 'between and' for a date, and if I use 'Where' or 'IF' I am not getting the expected results, is it like if I am using 'between and' for a date can't I use 'where' and 'IF'

Thanks,

Re: Subsetting data with date and string for a do function

ballardw — Mon, 07 Dec 2015 18:04:57 GMT

Try:

if centre in ('Shai','Hub','imen') and (mdy(3,01,1953) le Date_of_Birth le mdy(6,30,1974)) then status = 'pass';