from statement in proc sql

[GreggB]

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;

[SAS83]

Delete " , " (comma) after grade in the select statement. That should work..

[GreggB]

thanks. lots of hair pulling over a comma.