topic Re: Missing Variables within By Group in SAS Programming

Missing Variables within By Group

mlogan — Wed, 08 Jun 2016 17:20:29 GMT

Hi All,

I am trying to retrieve the missing variable of Table2 from Table1 (within by group). Can someone help with the code please.

I have the following two datasets:

Table1:

Student_ID Course

101 English

101 Biology

102 Chemistry

103 English

103 Physics

103 Accounting

104 Biology

104 Chemistry

Table2:

Student_ID Course

101 English

102 Chemistry

103 English

103 Accounting

104 Chemistry

Expected Output:

Student_ID Course

101 Biology

103 Physics

104 Biology

Pamela_JSRCC — Wed, 08 Jun 2016 17:38:31 GMT

proc sql;
select a.*
from table1 A
left join table2 B on b.student_id = a.student_id and
b.course = a.course
where missing (b.student_id);

ballardw — Wed, 08 Jun 2016 17:40:10 GMT

proc sql;

create table want as

select * from table1

except

select * from table2

;

quit;

If there are other variables needed you need to do some merging bak from the result to get them and have to replace the * with Student_Id, Course