topic Re: if a and not b in Proc Sql in SAS Programming

if a and not b in Proc Sql

lokeshbm — Sat, 12 Mar 2016 07:56:29 GMT

Hi,

I need the below step in Proc Sql

data newdata;

merge dset1(in=a) dset2(in=b);

by subjid visit location pin;

if a and not b;

run;

Re: if a and not b in Proc Sql

LinusH — Sat, 12 Mar 2016 09:35:59 GMT

This must be the oldest SAS question. The are literally thousands of papers and have been discussed Om this forum several times. Do a search her and on support.Sas.com.
Short answer : left join, but it depends on your data.