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!
@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 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;
Thank you, that is exactly what I was looking for!
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.