Determine if value is consistent by subject

mglogan — Thu, 12 Jul 2018 22:49:29 GMT

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!

Re: Determine if value is consistent by subject

Reeza — Fri, 13 Jul 2018 00:06:39 GMT

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!

topic Re: Determine if value is consistent by subject in SAS Programming

Determine if value is consistent by subject

Re: Determine if value is consistent by subject