Hello,
In the practice exam i came across this programming question about sorting.
my answer was :
data results.output27a;
set cert.input27;
country=upcase(country);
if country in("US");
run;
proc sort data=output27a;
by state descending postal_code employee_id;
run;
which gave the answer for employee_id in obs 100 is 121030
but the correct answer was 120781 which used in code
proc sort data=cert.input27
out=results.output27a(where=(upcase(country)='US'));
by state descending Postal_Code employee_ID;
run;