Help using Base SAS procedures

query

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 145
Accepted Solution

query

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


Accepted Solutions
Solution
‎01-01-2015 09:08 PM
Respected Advisor
Posts: 4,173

Re: query

Posted in reply to rakeshvvv

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;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,137

Re: query

Posted in reply to rakeshvvv

Please try

data want;

set have;

if ref1 ne daref or ref2 ne daref then output;

run;

Thanks,

Jag

Thanks,
Jag
Solution
‎01-01-2015 09:08 PM
Respected Advisor
Posts: 4,173

Re: query

Posted in reply to rakeshvvv

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 186 views
  • 0 likes
  • 3 in conversation