query

[rakeshvvv]

I have a dataset with four variables subjid ref1 ref2 and daref....subjid is the identifier....I should write query in such a way to output records where non missing ref1 not equal to non missing daref or non missing ref2 not equal to non missing daref....

In summary  is i should output those records where either of non missing ref1 or ref2 is not equal to daref...All are character variables.....

100030002           95630001             95630001             95630001

140020001           95630001'            95630001'            95630001

140020001           NOT APPLICABLE              NOT APPLICABLE              95630001

140020002           95630001             95630001             95630001

140060001           103013  103013  103013

140060001           103013  103013  100827

180010002           95630001             95630001             95630001

220020001           102340  BOTTLE 1              102340

460010001           95630001             102957  95630001

[Jagadishkatam]

Please try

data want;

set have;

if ref1 ne daref or ref2 ne daref then output;

run;

Thanks,

Jag

[Patrick · Accepted solution]

data have;

  infile datalines truncover dsd;

  input (subjid ref1 ref2 daref) (:$20.);

  if not missing(daref);

  if (not missing(ref1) and ref1 ne daref) or (not missing(ref2) and ref2 ne daref);

  datalines;

100030002,95630001,95630001,95630001

140020001,95630001',95630001',95630001

140020001,NOT APPLICABLE,NOT APPLICABLE,95630001

140020002,95630001,95630001,95630001

140060001,103013,103013,103013

140060001,103013,103013,100827

180010002,95630001,95630001,95630001

220020001,102340,BOTTLE 1,102340

460010001,95630001,102957,95630001

;

run;