topic If condition error in New SAS User

If condition error

suresh123 — Tue, 21 Jul 2020 14:38:15 GMT

I have two numeric variables with 1 and 0 as data points.

data new;

set new1;

if a=1 and b=0 then out="bad" else bad="good";

run;

I am getting below error:

Note: Invalid Numeric data.

I cant change the dataset but how to change the code to handle this error

Re: If condition error

PaigeMiller — Tue, 21 Jul 2020 14:47:37 GMT

Show us the log, including the entire DATA step code and all NOTES, WARNINGS and ERRORs for this DATA step. Do not chop anything out of the log.

When providing the log, it is critical that you maintain the formatting of the log so we can see it exactly as SAS showed it to you, making it easier for us to use. To maintain the formatting of the log, click on the </> icon and paste the log as text into the window that appears. DO NOT SKIP THIS STEP.

Re: If condition error

Tom — Tue, 21 Jul 2020 15:00:24 GMT

Paste the lines from the log for the data step and the notes/errors. Make sure to use the Insert Code button (looks like < / > ) to get a pop-up window to paste the lines so they are not re-flowed.

Your code at posted is missing a semi-colon. It also looks strange as you are updating different variables in the THEN and ELSE clauses. If the variable OUT is not already on the input dataset NEW1 then make sure to define it long enough to hold both values. For example you could just add an extra space at the end of "bad " so that SAS sees you want room for 4 characters.

data new;
  set new1;
  if a=1 and b=0 then out="bad ";
  else out="good";
run;