Creating new dataset with no duplicate values

[kmardinian]

Hi, I have a dataset that looks like this:

ID    TRT   VID    OUTCOME

1       0        1             1

1       0        2             0

1       0        1             1

1       0        2             0

2       1        1             1

2       1        2             1

I would like my final dataset to look like this:

ID    TRT   VID    OUTCOME

1       0        1             1

2       1        1             1

I would like to only have unique ID numbers for when outcome=1 in a separate dataset, so that I can then run analyses on those ID numbers. Thank you!

[ballardw · Accepted solution]

---

@kmardinian wrote:

Hi, I have a dataset that looks like this:

ID    TRT   VID    OUTCOME

1       0        1             1

1       0        2             0

1       0        1             1

1       0        2             0

2       1        1             1

2       1        2             1

I would like my final dataset to look like this:

ID    TRT   VID    OUTCOME

1       0        1             1

2       1        1             1

I would like to only have unique ID numbers for when outcome=1 in a separate dataset, so that I can then run analyses on those ID numbers. Thank you!

---

If you don't need the other variables at all easiest may be:

Proc sql;
    create table idonly as
    select distinct id
    from yourdatasetname;
quit;

[kmardinian]

Thank you, that is exactly what I was looking for!

[novinosrin]

data have;
input ID    TRT   VID    OUTCOME;
cards;
1       0        1             1
1       0        2             0
1       0        1             1
1       0        2             0
2       1        1             1
2       1        2             1
;

proc sort data=have(where=(outcome=1)) out=want nodupkey;
by id;
run;