Make a unique observation in one row

jcapua2 — Fri, 15 Dec 2017 17:11:15 GMT

I have data set:

PX BMI SMOKE

Patient_1 YES NO

Patient_1 NO YES

And I want:

PX BMI SMOKE

Patient_1 YES YES

Is there a way to make Patient_1 in just one row instead of having multiple rows?

Re: Make a unique observation in one row

Reeza — Fri, 15 Dec 2017 17:09:45 GMT

Is it only Yes/No that you're comparing, or are there other variables that may have other ranges?

If it's Yes/No you can use SQL and MAX function. This will work because Yes is alphabetically after No. If you have other values you'll need a different approach.

proc sql;
create table want as
select px, max(bmi) as bmi, max(smoke) as smoke
from have
group by px;
quit;

@jcapua2 wrote:

I have data set:

PX BMI SMOKE

Patient_1 YES NO

Patient_1 NO YES

And I want:

PX BMI SMOKE

Patient_1 YES YES

Is there a way to make Patient_1 in just one row that having multiple rows?

topic Make a unique observation in one row in SAS Procedures

Make a unique observation in one row

Re: Make a unique observation in one row