topic create dummy to flag obs w/ same address at two time points in SAS Data Management

create dummy to flag obs w/ same address at two time points

UMAnalyst — Mon, 16 Nov 2015 02:09:58 GMT

I need to create a dummy variable that flags cases who lived at the same address in 2012 as in 2010.

Data looks like:

ID year fulladdress

1000001 2010 101 STREET NUM CITY ST ZIP

1000001 2012 101 STREET NUM CITY ST ZIP

1000002 2010 999 STREET NUM CITY ST ZIP

1000002 2012 777 STREET NUM CITY ST ZIP

Thanks for your help

Re: create dummy to flag obs w/ same address at two time points

slchen — Mon, 16 Nov 2015 02:29:52 GMT

data want;
   merge have have(firstobs=2 rename=(id=_id year=_year fulladdress=_fulladdress));
   if id=_id and compbl(fulladdress)=compbl(_fulladdress) then flag=1;
   drop _:;
run;

Re: create dummy to flag obs w/ same address at two time points

stat_sas — Mon, 16 Nov 2015 03:16:04 GMT

proc sql;
create table want as
select *,case when count(distinct fulladdress)=1 then 'Same' else 'Different' end as
flag from have group by id;
quit;

Re: create dummy to flag obs w/ same address at two time points

PGStats — Mon, 16 Nov 2015 04:41:42 GMT

Without assuming the list is limited to 2010 and 2012 addresses :

proc sql;
create table want as
select 
    *, 
    id in ( 
        select a.id from have as a inner join have as b 
        on a.id=b.id and a.fullAddr=b.fullAddr
        where a.year=2010 and b.year=2012) as sameAddr
from have;
quit;

Re: create dummy to flag obs w/ same address at two time points

UMAnalyst — Mon, 16 Nov 2015 11:56:50 GMT

Thank you for your help. I love this forum.