Indicator that Satisfies two Conditions

[trevand]

I have 20 variables and need to create an indicator that equals to 1 if one of the variables equals to A10 and the other 19 are empty. I have no idea how I would do it. Here is a data example with 5 variables:

VAR_1	VAR_2	VAR_3	VAR_4	VAR_5	DUMMY
A10	B10				0
A10					1
	B10	C10			0
A10	B10	C10			0
A10				D10	0

[PaigeMiller · Accepted solution]

data want;
    set have;
    if cmiss(of var_1-var_20)=19 and whichc('A10',of var_1-var_20)>0 then dummy=1;
    else dummy=0;
run;

It may be that you are making your programming work difficult by creating a wide data set; in many cases creating a long data set with the same data is a lot easier to handle and program. Why? Because most SAS Procs are designed to work with long data sets. I urge you to explain the background of this problem, and what you are planning to do next once you have this dummy variable, so that we can advise further. We need to understand the big picture, not the tiny details of how to create the dummy variable.

[quickbluefish]

Alternatively:

dummy=(catx(',',of var:)='A10');