Qu. Fetch the customer details who have shopped only in Jan.
Data Jan;
input Customer$ Item$ Amount;
Datalines;
A1 Sandal 110
A3 Watch 210
A5 Shoes 310
;
run;
Data Feb;
input Customer$ Item$ Amount;
datalines;
A1 Dresses 120
A2 Bags 220
A4 Paintings 320
;
run;
Output should be :
Final
Customer Item Amount
A3 Watch 210
A5 Shoes 310
Can any one please help me to write better SQL query.
Regards,
Jai