topic Re: variable in data with an if-condition in New SAS User

variable in data with an if-condition

Hansi_12345 — Wed, 21 Jul 2021 09:25:38 GMT

Hi guys, it's me again.

You helped me a lot but i have one more question 😄

I have the following code:

data Work.test;
      set input;
      value = 0.4* value_input;
      reference_number = if value > 0 then reference_number = 123 else 345;
run;

My data has different positive and negative values in the variable value_input.

The aim should be, that positive values get the reference_number 345 and all other values get the reference_number 123.

I get three syntax errors:

1. Missing !,!!, & ...

2. Expecting an arithmetic operator

3. The option or parameter is not recognized and will be ignored

Would be great if you could help me

Thanks in advance.

Hansi_12345 — Wed, 21 Jul 2021 10:22:23 GMT

I found the solution. 😄

data Work.test;
      set input;
      value = 0.4* value_input;
      if value > 0 then reference_number = 123; else reference_number = 345;
run;

Sorry for disturbing you.

Have a nice day 😄

ballardw — Wed, 21 Jul 2021 16:46:47 GMT

Good for you!