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

[ccox4682]

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.

[stat_sas]

proc sql;

select id from have group by id

having count(distinct area_code)>1;

quit;

[ccox4682]

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)?

[slchen]

proc sql;

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

quit;

[stat_sas]

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;