topic Apply a Conditional Value for a New Variable in SAS Programming

Apply a Conditional Value for a New Variable

anissak1 — Fri, 24 Apr 2020 00:54:26 GMT

Hello. I have matched pairs of observations in a long form. I want to create a new variable "Cohort Censor".

For each case (case=1), Cohort Censor should equal walkcensordate. For each control (case=0), it should be the value of the case with that has same match number. Short dataset attached.

This seems easy, but I'm still a relative neophyte and scratching my head how I can reference an indicator variable in a conditional way to create the new variable.

Thank you for any guidance

Anissa

Re: Apply a Conditional Value for a New Variable

anissak1 — Fri, 24 Apr 2020 01:07:37 GMT

I would like to clarify. Each control (case=0) should have a cohortcensor date that is the walkcensordate for its matched case (case=1).

Re: Apply a Conditional Value for a New Variable

PGStats — Fri, 24 Apr 2020 02:18:17 GMT

One way to do this is with SQL:

proc sql;
create table forsas6 as
select *,
	(select walkCensorDate from forsas5 as b where b.matchNumber=a.matchNumber and b.case = 1) as cohortcensorDate 
from forsas5 as a;
quit;

Re: Apply a Conditional Value for a New Variable

sustagens — Fri, 24 Apr 2020 02:24:21 GMT

proc sql;
create table want as 
select t1.*,
(case when t1.case=1 then t1.walkcensordate else t3.walkcensordate end) as cohortcensor
from forsas5 t1 
left join (select t2.* from forsas5 t2 where t2.case=1) t3 
on t1.matchnumber=t3.matchnumber;
quit;

Re: Apply a Conditional Value for a New Variable

anissak1 — Fri, 24 Apr 2020 05:08:46 GMT

Thank you for this code! It worked perfectly. I don’t knOw SQL, but learned a bit from this example. :). Much appreciated!