topic Re: query in SAS Procedures

query

rakeshvvv — Fri, 02 Jan 2015 01:32:25 GMT

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

Re: query

Jagadishkatam — Fri, 02 Jan 2015 02:08:20 GMT

Please try

data want;

set have;

if ref1 ne daref or ref2 ne daref then output;

run;

Thanks,

Jag

Re: query

Patrick — Fri, 02 Jan 2015 02:08:47 GMT

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;