The log is showing an error in the from statement as if enrhist library does not exist. It does exist and table aenr0809 is there. ??
proc sql;
create table aenr as
select distinct schoolattn, datepart(effdate) as effdate, entercode, leavecode, transyear, grade,
from enrhist.aenr0809 where entercode ne '' or leavecode ne '' and effdate ne . and schnum=schoolattn
order by permnum, effdate desc, leavecode desc, entercode, schoolattn;
quit;
run;
... View more
