Help using Base SAS procedures

from statement in proc sql

Reply
Super Contributor
Posts: 279

from statement in proc sql

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;
Contributor
Posts: 32

Re: from statement in proc sql

Delete " , " (comma) after grade in the select statement. That should work..
Super Contributor
Posts: 279

Re: from statement in proc sql

thanks. lots of hair pulling over a comma.
Ask a Question
Discussion stats
  • 2 replies
  • 113 views
  • 0 likes
  • 2 in conversation