This tutorial explains how to use the INTERSECT operator in PROC SQL in SAS, along with examples.
In PROC SQL, the INTERSECT operator is used to find the common records that exist in tables. The basic syntax of INTERSECT OPERATOR within PROC SQL is as follows :
PROC SQL;
SELECT *
FROM dataset1
INTERSECT
SELECT *
FROM dataset2;
QUIT;
To read this article in full, please click here
Read MoreListenData
