topic Re: How to find which variable values are different between duplicates by subjid in SAS Programming

How to find which variable values are different between duplicates by subjid

knveraraju91 — Wed, 16 Jan 2019 05:55:58 GMT

Dear,

I would like to know if i can find a way to find the the variables with different vales. In my data set there are duplicates by 'id' variable vales but other variables values are different. I used proc sort data=one out=two nodupkey;by _all_;run; With this step one of the duplicate for id=3 removed. Now I need to know which variables have different values for other subjects. My data set has close to 200 variables. Please suggest. Thank you

data one;
input id a $ b $ c $ d e;
datalines;
1 a b c 1 2
1 a b c 1 3
2 b b c 1 2
2 c b c 1 3
3 a b c 1 2
3 a b c 1 2
;

Re: How to find which variable values are different between duplicates by subjid

PGStats — Wed, 16 Jan 2019 06:02:23 GMT

What should the output be for your example data?

Re: How to find which variable values are different between duplicates by subjid

knveraraju91 — Wed, 16 Jan 2019 15:12:32 GMT

Thank you very much for your time.

My question was, the data set that i am working is subject level data set which should have only one record for 'id'. In my output there should be only three records. But when i ran 'proc sort data=one out=two nodupkey;by _all_;run; ' i am able to remove only one record which is for id=3. Now i need to find which variables have different values for id=1 and id=2. In the below example, for id=1, the variable 'e' has different values and for id=2, the variable 'a' and 'e' has different values. So i want to output something like below so i can quickly see which variables have different values

output needed

data want;

id a e

1 2,3

2 b,c 2,3

data one;
input id a $ b $ c $ d e;
datalines;
1 a b c 1 2
1 a b c 1 3
2 b b c 1 2
2 c b c 1 3
3 a b c 1 2
3 a b c 1 2;

Re: How to find which variable values are different between duplicates by subjid

Reeza — Wed, 16 Jan 2019 16:01:07 GMT

Does each ID have only two records each, or can there be multiple records per ID? Is there a limit to how many there can be?