DATA Step, Macro, Functions and more

Identify all records having unexpected change in a data element value

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 120
Accepted Solution

Identify all records having unexpected change in a data element value

Hi there,

For your kind information, I am trying to identify all records of a person who is having changes in the value of a particular data element which is usually not expected in general. Here ID 102 is having LHIN value changed. 

 

data have ;
format date date9.;
input id $ LHIN 2. date date9. pulse 3. ;
datalines;
101 1 01JAN2017 90
101 1 03JAN2017 80
101 1 05JAN2017 70 
102 2 01JAN2017 90
102 2 03JAN2017 70
102 3 05JAN2017 70
;
run;



data want;
format date date9.;
input id $ LHIN 2. date date9. pulse 3. ;
datalines;
102 2 01JAN2017 90
102 2 03JAN2017 70
102 3 05JAN2017 70
;
run;

Thank you in advance for your kind reply.
Regards,
Swain

Accepted Solutions
Solution
‎11-17-2017 08:27 AM
Super User
Posts: 13,542

Re: Identify all records having unexpected change in a data element value

Posted in reply to DeepakSwain

Perhaps

proc sql;
   create table want as
   select b.*
   from (select id 
             from (select distinct id,lhin from have)
             group by id
             having count(*)>1
         ) as a
         left join 
         have as b
         on a.id=b.id
   ;
quit;

View solution in original post


All Replies
Super User
Posts: 23,724

Re: Identify all records having unexpected change in a data element value

Posted in reply to DeepakSwain

So you're looking for ID's where the LHIN changes for the person?

 


DeepakSwain wrote:

Hi there,

For your kind information, I am trying to identify all records of a person who is having changes in the value of a particular data element which is usually not expected in general. Here ID 102 is having LHIN value changed. 

 

data have ;
format date date9.;
input id $ LHIN 2. date date9. pulse 3. ;
datalines;
101 1 01JAN2017 90
101 1 03JAN2017 80
101 1 05JAN2017 70 
102 2 01JAN2017 90
102 2 03JAN2017 70
102 3 05JAN2017 70
;
run;



data want;
format date date9.;
input id $ LHIN 2. date date9. pulse 3. ;
datalines;
102 2 01JAN2017 90
102 2 03JAN2017 70
102 3 05JAN2017 70
;
run;

Thank you in advance for your kind reply.
Regards,

 

Solution
‎11-17-2017 08:27 AM
Super User
Posts: 13,542

Re: Identify all records having unexpected change in a data element value

Posted in reply to DeepakSwain

Perhaps

proc sql;
   create table want as
   select b.*
   from (select id 
             from (select distinct id,lhin from have)
             group by id
             having count(*)>1
         ) as a
         left join 
         have as b
         on a.id=b.id
   ;
quit;
Frequent Contributor
Posts: 120

Re: Identify all records having unexpected change in a data element value

Is it possible to identify the record having the least used LHIN.
e.g. 102 3 05JAN2017 70
Swain
☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 110 views
  • 1 like
  • 3 in conversation