Hi,

I'm doing a data step scenario to show telephone_uid (tel_number in data step code) with more than 1 unique full_name.

Screenshot 2022年03月29日 234340.jpg Here is my data step code:

Screenshot 2022年03月29日 234620.jpg

I need an advice on how to correct my code to show only those tel_number with more than 1 full_name associated on it.

Thank you.

Regards,

Adrian

Below code should work but is untested because you didn't provide sample data in a usable format.

proc sort 
 data=&input_dataset(keep=tel_number full_name)
 out=intermediate
 nodupkey;
 by tel_number full_name;
run;
data &output_dataset;
 set intermediate;
 by tel_number;
 if first.tel_number then name_count=1;
 else name_count+1;
 if last.tel_number and name_count>1 then
 do;
 &message=catx(' ','Telephone : ',tel_number,'Suspicious.... to', name_count,'people...');
 ....
 output;
 end;
run;

For future questions please post your data and code as text and not as screenshots. Use icons

[画像:Patrick_0-1648583285463.png]

to do so.

Would you have been happy if I'd posted my reply as picture?

[画像:Patrick_1-1648583331312.png]

Below code should work but is untested because you didn't provide sample data in a usable format.

proc sort 
 data=&input_dataset(keep=tel_number full_name)
 out=intermediate
 nodupkey;
 by tel_number full_name;
run;
data &output_dataset;
 set intermediate;
 by tel_number;
 if first.tel_number then name_count=1;
 else name_count+1;
 if last.tel_number and name_count>1 then
 do;
 &message=catx(' ','Telephone : ',tel_number,'Suspicious.... to', name_count,'people...');
 ....
 output;
 end;
run;

For future questions please post your data and code as text and not as screenshots. Use icons

[画像:Patrick_0-1648583285463.png]

to do so.

Would you have been happy if I'd posted my reply as picture?

[画像:Patrick_1-1648583331312.png]

Thanks for the reminder @Patrick and thanks for the answer.

Regards,

Adrian