topic Re: Help in Proc sql code in SAS Programming

Help in Proc sql code

knveraraju91 — Tue, 03 Jan 2017 06:44:21 GMT

Dear,

I am using following code.

I got the output I need except for one subject .

Assuming that the exstdtc is the last dose given before aesdt.

In my output I need to have the larger dose taken when two different doses taken on same day. Please help in my code

one

id aesdt

1 24SEP2014

id exstdtc exdose

1 2015-08-28 3.5

1 2015-08-28 7

output needed

id aesdt exdose

1 24SEP2014 7

proc sql;
create table dose as
select a.*,b.exdose
from one as a left join ex as b
on a.usubjid=b.usubjid and a.AESDT-b.exstdtc >0
group by a.usubjid,a.aesdt
having a.Aesdt-b.exstdtc=min(a.Aesdt-b.exstdtc);
quit;

Re: Help in Proc sql code

PeterClemmensen — Tue, 03 Jan 2017 07:14:28 GMT

I dont see the variable usubjid in either of your datasets? 🙂

Re: Help in Proc sql code

Astounding — Tue, 03 Jan 2017 08:13:23 GMT

What should happen if a dose was given on the same day as the adverse event? (Use that date vs. ignore it?)

Re: Help in Proc sql code

Ksharp — Wed, 04 Jan 2017 04:08:30 GMT

I would more like to use Data Step.



proc sql;
create table dose as
select usubjid,aesdt,max(exdose) as exdose
from
(
select a.*,b.exdose
from one as a left join ex as b
on a.usubjid=b.usubjid and a.AESDT-b.exstdtc >0
group by a.usubjid,a.aesdt
having a.Aesdt-b.exstdtc=min(a.Aesdt-b.exstdtc)
)
group by usubjid,aesdt;
quit;