equivalent of full outer join in SAS

admin

Today, I will discuss about “How to design SAS code which is equivalent of full outer join in database”.
We created the two datasets in sql-server.


when we apply full outer join on above data set.


In SAS, create the dataset same as TEST1 and TEST2 tables.
* Always remember to sort the data. Make a habit of this in SAS.



Merge the above datasets using the below code.



See the final output for the same.




Related posts