Checking a value in a column based on a value in another column

Daniel_MM — Tue, 04 Jul 2023 06:27:53 GMT

I have a data set that looks like:

Direction	CUSTOMER_ID	REGION	reg_A	reg_B	NET_SUPPLIED
1	a	A	1	.	2
1	a	B	1	.	3
1	b	A	1	.	4
1	b	B	1	.	5
2	a	A	.	4	6
2	a	B	.	4	7

and I want to delete the rows where the value in "region" coincides with a value of "." in that region, unfortunately I have a large number of regions and not all will show up in every query so I cant just list each region in a bunch of if statements is there any way to do a single if statement that looks like:

if "reg_"+value(region)=. then delete;

if not are there any methods other than just writing a long list of if statements?

Thanks!

Re: Checking a value in a column based on a value in another column

FreelanceReinh — Tue, 04 Jul 2023 08:10:12 GMT

Hello @Daniel_MM,

Use the VVALUEX function:

data have;
input Direction CUSTOMER_ID $ REGION $ reg_A reg_B NET_SUPPLIED;
cards;
1 a A 1 . 2
1 a B 1 . 3
1 b A 1 . 4
1 b B 1 . 5
2 a A . 4 6
2 a B . 4 7
;

data want;
set have;
if left(vvaluex('reg_'||region))='.' then delete;
run;

topic Re: Checking a value in a column based on a value in another column in SAS Programming

Checking a value in a column based on a value in another column

Re: Checking a value in a column based on a value in another column