topic Re: Why where condition with negative number does not work? in SAS Programming

Why where condition with negative number does not work?

Sk1_SAS — Sat, 31 Jul 2021 21:16:25 GMT

i have a table with negative percent

format of the variable: percentn10.2

i have tried: where variable < 0, but does not work, do you know why?

Re: Why where condition with negative number does not work?

PaigeMiller — Sat, 31 Jul 2021 21:46:56 GMT

What do you mean by "does not work"? Please state what happens, in enough details so I can understand what you are seeing, or show us the incorrect results.

Please show us the full LOG of the code you are running, so we can see the code as it is displayed in the log, plus any ERRORs, WARNINGs and NOTEs. Do not chop out parts of the log. Do not pick and choose parts of the log to show us, and then not show us other parts.

Re: Why where condition with negative number does not work?

Patrick — Sun, 01 Aug 2021 00:29:13 GMT

@Sk1_SAS WHAT is not working. Please also provide sample data in the form of a data step as done below and not as a screenshot.

Just wildly guessing: I could imagine that you could get an unexpected result if you condition was variable <= 0 Not sure about variable <0

Best provide sample data and your selection and tell us where your condition doesn't work as you'd expect.

data have;
  input variable;
  format variable percentn10.2;
  datalines;
-0.0016
-0.0166
0
0.000001
-0.000001
;

proc print data=have;
  where variable<0;
run;

Re: Why where condition with negative number does not work?

Kurt_Bremser — Sun, 01 Aug 2021 06:20:43 GMT

Always (as in

ALWAYS

) show us the code you used, and the complete log from it, when it "does not work".