topic from statement in proc sql in SAS Procedures

from statement in proc sql

GreggB — Tue, 12 Apr 2011 17:08:47 GMT

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;

Re: from statement in proc sql

SAS83 — Tue, 12 Apr 2011 17:22:34 GMT

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

Re: from statement in proc sql

GreggB — Tue, 12 Apr 2011 17:46:41 GMT

thanks. lots of hair pulling over a comma.