topic Creating new dataset with no duplicate values in SAS Programming

Creating new dataset with no duplicate values

kmardinian — Fri, 12 Oct 2018 17:39:54 GMT

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!

Re: Creating new dataset with no duplicate values

ballardw — Fri, 12 Oct 2018 17:46:01 GMT

@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;

Re: Creating new dataset with no duplicate values

novinosrin — Fri, 12 Oct 2018 17:51:12 GMT

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;

Re: Creating new dataset with no duplicate values

kmardinian — Fri, 12 Oct 2018 17:54:24 GMT

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