DATA Step, Macro, Functions and more

Determine if value is consistent by subject

Reply
Occasional Contributor
Posts: 7

Determine if value is consistent by subject

Hello,

 

I need to determine if the lab collection method for each subject in my data set was collected consistently throughout the study.

 

To Illustrate, the variables I will use are "Lab Location" and "Subject ID." Each subject has multiple observations in the data set.

 

I need to determine if the value of "Lab Location" (Character) is the same for all observations per Subject ID. if not, I need to output to view the result. 

 

Example Data:

SubjectID  LabLocation Visit

Subj123     Lab                     1
Subj123     Lab                     2
Subj123     Point of Care      3

 

Can you recommend the best method for doing this?

 

Thank you!

Super User
Posts: 23,683

Re: Determine if value is consistent by subject

proc sql;
create table not_same as
select *
from have
group by subjectID
having not (max(labLocation)=Min(labLocation));
quit;

@mglogan wrote:

Hello,

 

I need to determine if the lab collection method for each subject in my data set was collected consistently throughout the study.

 

To Illustrate, the variables I will use are "Lab Location" and "Subject ID." Each subject has multiple observations in the data set.

 

I need to determine if the value of "Lab Location" (Character) is the same for all observations per Subject ID. if not, I need to output to view the result. 

 

Example Data:

SubjectID  LabLocation Visit

Subj123     Lab                     1
Subj123     Lab                     2
Subj123     Point of Care      3

 

Can you recommend the best method for doing this?

 

Thank you!




Ask a Question
Discussion stats
  • 1 reply
  • 41 views
  • 0 likes
  • 2 in conversation