check if for a given value in column a, the value in column b is the same

[laiguanyu001]

Hi,

I have a dataset that looks like this

A             B

fast         1

fast         1

slow        2

slow        2    

other       3

other       3

fast          4

How can I use a macro step to print an error, where values are not one to one in column a and column b? For example in the above dataset "slow"-2, "other"-3 are one to one, but "fast" -1 is not one to one.

For my output dataset I want:

error

fast -1 is not one to one

[PaigeMiller · Accepted solution]

Macro not needed.

proc sql;
    create table want as select distinct a,b from have order by a,b;
quit;

data _null_;
	set want;
	by a;
	if first.a and not last.a then
		put a= b= "is not one to one";
run;

[laiguanyu001]

Thanks for the quick response! However this method still requires some eyeballing work. Is there a way to directly print out only the lines with error? 

[PaigeMiller]

---

@laiguanyu001 wrote:

Thanks for the quick response! However this method still requires some eyeballing work. Is there a way to directly print out only the lines with error? 

---

I just updated the code to handle this.

[laiguanyu001]

Thank you !!!!