Sunday, April 28, 2024
No menu items!
HomeData Analytics and VisualizationSAS: EXCEPT Operator in PROC SQL

SAS: EXCEPT Operator in PROC SQL

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

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments