Would studentId and courseId not have the same values in the 2 tables? Why would something like this not work? Proc SQL; create table all as select * from table1 a, table2 b where a.studentId=b.studentId and a.courseId=b.courseId; quit; run; Unless I've misunderstood you the above should give a table with all student results for all courses for which there were any results

Hello, I have problem with combine 2 tables, let me explain one table repeseent exam terms studentId | course Id | course name | exam day | second table is exam marks studentId | course Id | pass day | mark | problem is there is no unique value to combine data. What i used is pure SQL and LEFT JOIN where i put sometnig like this SELECT field1, field2, field3 FROM first_table LEFT