- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try:
if centre in ('Shai','Hub','imen') and (mdy(3,01,1953) le Date_of_Birth le mdy(6,30,1974)) then status = 'pass';