topic Creating new variable in SAS Programming

Creating new variable

aowais — Mon, 25 Feb 2019 19:13:21 GMT

Hello,

I need to create a variable based on responses from another variable as follows:

if KN2 = 1 and 2, or 3, or 8, AND KN3 = 1, 2, or 3 then I2 = 1; esle I2 = 0.

Right now I'm using the following code:

if ((kn2 = 1 and kn2 = 2) or kn2 in (3,8)) and kn3 in (1:3) then i2 = 1;
else i2 = 0;

Is there a better way to write this code? Thanks!

Astounding — Mon, 25 Feb 2019 19:17:04 GMT

How is it possible for kn2 to be both 1 and 2 at the same time?

You may need to understand the requirements better.

aowais — Mon, 25 Feb 2019 19:20:40 GMT

Thanks, yes I misread the requirement.

SASKiwi — Mon, 25 Feb 2019 19:33:16 GMT

What is the correct requirement then?

aowais — Mon, 25 Feb 2019 19:54:26 GMT

The question was multiple response, and data were entered as needed; i.e. KN2 = 1 if respondant answered with 1 AND 2, or 3 or 8; 0 otherwise.