topic check if for a given value in column a, the value in column b is the same in New SAS User

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

laiguanyu001 — Tue, 02 Jul 2019 14:06:23 GMT

Hi,

I have a dataset that looks like this

A B

fast 1

slow 2

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

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

PaigeMiller — Tue, 02 Jul 2019 14:15:40 GMT

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;

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

laiguanyu001 — Tue, 02 Jul 2019 14:14:21 GMT

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?

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

PaigeMiller — Tue, 02 Jul 2019 14:16:06 GMT

@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.

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

laiguanyu001 — Tue, 02 Jul 2019 14:17:50 GMT

Thank you !!!!