topic Re: Flagging for ID's that appear under more than 1 indicator in SAS Procedures

Flagging for ID's that appear under more than 1 indicator

ccox4682 — Mon, 13 Oct 2014 15:11:44 GMT

There are duplicate identifiers in my dataset. Regardless, each has a different area code. I need to flag where the same id appears under a different area code. I'm sure there's a straightforward solution, just not sure what it is. Can anyone help? Thanks in advance.

Re: Flagging for ID's that appear under more than 1 indicator

stat_sas — Mon, 13 Oct 2014 16:07:35 GMT

proc sql;

select id from have group by id

having count(distinct area_code)>1;

quit;

Re: Flagging for ID's that appear under more than 1 indicator

ccox4682 — Mon, 13 Oct 2014 16:22:01 GMT

Thank you, I figured it would be a proc sql. But, where can I insert a command for a separate column (e.g., diff_area_code_flag = 1)?

Re: Flagging for ID's that appear under more than 1 indicator

slchen — Mon, 13 Oct 2014 16:57:12 GMT

proc sql;

select *,case when count(id)>1 then 1 else 0 end as diff_area_flag from have group by id;

quit;

Re: Flagging for ID's that appear under more than 1 indicator

stat_sas — Tue, 14 Oct 2014 01:36:43 GMT

proc sql;

select *,case when count(distinct area_code)>1 then 1 else 0 end as diff_area_code_flag

from have

group by id;

quit;