Help using Base SAS procedures

if/and/or Statements

Reply
Contributor
Posts: 55

if/and/or Statements

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!

Contributor
Posts: 45

Re: if/and/or Statements

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.

Ask a Question
Discussion stats
  • 1 reply
  • 186 views
  • 1 like
  • 2 in conversation