Hi all,
I am wondering how to scan a series of values for each ID and generate a summary variable for each ID. Essentially, I need to look at all the tests each patient has had, and decide if they have ever been positive. The dataset I have is the following:
ID Test Outcome
1 Positive
1 Positive
1 Negative
2 Negative
2 Negative
3 Negative
3 Negative
3 Positive
3 Negative
And I need one that looks like this:
ID Test Outcome Overall
1 Positive Positive
1 Positive Positive
1 Negative Positive
2 Negative Negative
2 Negative Negative
2 Negative Negative
3 Negative Positive
3 Negative Positive
3 Positive Positive
3 Negative Positive
Thanks in advance!
There are many ways to do this one.
If you're brand new to SAS, easiest approach is:
1. Sort on ID and DESCENDING test outcome
2. Use RETAIN to keep the first value across the ID. If it's POSITIVE it will be the first record because (P is after N alphabetically).
There are many ways to do this one.
If you're brand new to SAS, easiest approach is:
1. Sort on ID and DESCENDING test outcome
2. Use RETAIN to keep the first value across the ID. If it's POSITIVE it will be the first record because (P is after N alphabetically).
Hi,
Using proc sql:
proc sql;
create table want as
select *,case when sum(Test_Outcome="Positive")>0 then "Positive" else "Negative" end as Overall
from have group by id
order by id;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.