This tutorial explains how to use the EXCEPT operator in PROC SQL in SAS, along with examples.
Create Sample Datasets
The following SAS program creates datasets that will be used to explain examples in this tutorial.
data datasetA;
input product $ sales;
cards;
A 60
A 60
A 65
B 36
C 78
D 91
;
run;
data datasetB;
input product $ profit;
cards;
A 60
A 62
D 23
E 25
F 32
G 41
;
run;
To read this article in full, please click here
Read MoreListenData