I would try this:
proc sort data=have;
by empid;
run;
data
right
wrong
;
set have;
by empid;
if not first.empid or country not in ('AU','US') or term_date lt hire_date
then output wrong;
else output right;
run;
Since a missing value is lower than any other value, the missing value automatically fulfills the last condition.
Code is untested; for tested code, please supply example data as a data step with datalines, not as Excel files that
are unsafe because of possible malware, so lots of us are wary to download them, and some have them even blocked by their corporate firewalls
do not have fixed attributes for columns and therefore do not tell us important information about SAS datasets
need to be imported into SAS by unreliable means which cause extra work (download, upload to SAS server, process)
A data step only needs a copy/paste and submit and presents unambiguous data. Help us to help you.
... View more