if/and/or Statements

finans_sas — Sat, 22 Mar 2014 00:11:37 GMT

Hi Everybody,

I have a quick question on SAS if and or statements. How do I write a statement that will do the following:

obsid code1 ind_code sic reg

1 1 AG 63 1

2 1 AG 63 1

3 1 FOOD 44 1

4 1 OIL 78 1*

5 1 FOOD 44 1

6 0 MIN 55 0

7 0 MIN 55 0

8 0 DRUGS 47 0

I want to impose the following conditions:

if code1=1 then

I want either ind_code in ("AG", "FOOD") or sic_code in (78, 98, 47) to be true. If these conditions are met, I want to create a dummy variable (reg) that equals to 1 (0 otherwise).

I know how to create this dummy for each "or" part, but I am wondering how you can combine and/or statements in one single line.

Thanks!

Re: if/and/or Statements

Murray_Court — Sat, 22 Mar 2014 01:09:14 GMT

The syntax is exactly as you described.

data want;

set have;

if code1=1 AND (ind_code in ("AG","FOOD") OR sic_code in (78,98,47) ) then reg = 1;

else reg=0;

run;

-Murray.

topic if/and/or Statements in SAS Procedures

if/and/or Statements

Re: if/and/or Statements