PROC SQL in:

[GreggB]

Can this DATA step be incorporated into the PROC SQL step so that course_numbers beginning with '08' are excluded when table stud4 is created? 

 proc sql;
create table stud4 as 
SELECT S.*,CC.COURSE_NUMBER, CC.SECTION_NUMBER, CC.SCHOOLID as cc_schoolID, T.TEACHERNUMBER, 
       T.LASTFIRST as TEACHER, courses.course_name
FROM stud3b as s
left join myoracle.cc as cc
on s.ID=cc.studentid
left join myoracle.teachers as t
on cc.teacherid=t.ID 
left join myoracle.COURSES as courses
on cc.COURSE_NUMBER=courses.course_number
where cc.termid ge 2800
order by s.student_number;
quit;	
	
data stud4a;
set stud4;
if course_number in:('08') then delete;
run;

[novinosrin]

Perhaps

proc sql;
create table stud4 as 
SELECT S.*,CC.COURSE_NUMBER, CC.SECTION_NUMBER, CC.SCHOOLID as cc_schoolID, T.TEACHERNUMBER, 
       T.LASTFIRST as TEACHER, courses.course_name
FROM stud3b as s
left join myoracle.cc as cc
on s.ID=cc.studentid
left join myoracle.teachers as t
on cc.teacherid=t.ID 
left join myoracle.COURSES as courses
on cc.COURSE_NUMBER=courses.course_number
where cc.termid ge 2800
   having cc.course_number not like ('08%')
order by s.student_number;
quit;		

 EDITED to NOT like

sorry

[novinosrin]

or is it

where cc.termid ge 2800   and cc.course_number not like ('08%')

 EDITED to NOT like

sorry

[GreggB]

doesn't this do the opposite?

[novinosrin]

Don't know your data. I am taking a wild guess

Oops sorry 

should be NOT like

[FreelanceReinh]

Alternatively, you can use a dataset option:

create table stud4(where=(course_number~=:'08')) as

[PGStats · Accepted solution]

If you want the left join to work properly with a where condition on the table on the right side of the join, you must force SQL to apply the condition before operating the join, as such:

proc sql;
create table stud4 as 
SELECT  
    S.*,
    CC.COURSE_NUMBER, 
    CC.SECTION_NUMBER, 
    CC.SCHOOLID as cc_schoolID, 
    T.TEACHERNUMBER, 
    T.LASTFIRST as TEACHER, 
    courses.course_name
FROM 
    stud3b as s left join 
    (   select * 
        from myoracle.cc 
        where 
            course_number net "08" and 
            termid ge 2800  ) as cc on s.ID=cc.studentid left join 
    myoracle.teachers as t on cc.teacherid=t.ID left join 
    myoracle.COURSES as courses on cc.COURSE_NUMBER=courses.course_number
order by s.student_number;
quit;

otherwise, the where condition is applied to the missing values generated by the join and those added records are removed (you end up with the equivalent of an inner join, not a left join)

[GreggB]

Thanks. Never knew about net.

[PGStats]

Me nether... You made me look