WHERE clause INCOME < 0 does not show rows where income is in minus

[Akhila1]

Proc sql;

select * from mytable

where income < 0;

run;

[Quentin]

The code looks fine.  Please add some sample data to your question which shows this behavior, e.g.:

data mytable ;
  income = -1 ;
run ;

proc sql;
  select * from mytable
  where income < 0;
quit;

[Kurt_Bremser]

Maxim 3: Know Your Data.

This includes knowing all types, formats and other attributes of your variables.

[PaigeMiller]

Income < 0, what does that even mean? Somebody who goes to work, the company doesn't pay the worker and the worker has to pay the company money, so his income is negative? Maybe your data set doesn't have any records where Income < 0 because that never happens.

If the code you show finds zero records, then there are no incomes less than zero in your data set.

[ballardw · Accepted solution]

Show the results of Proc Contents on your data set Mytable. If you think you have negative values and none appear than one likely cause is that the variable Income is character and not numeric, second could be a custom format that displays something you think is negative but actually holds a different value.

BTW, Proc SQL ends with a Quit statement not Run. Should create output but you may still have proc sql running.

[gema]

do a proc univariate to look at your data. univariate gives you the 5 lower and upper extreme values of the variable income. if there are any negative values, they will show up. this is a good way to look at abnormalities for continuous variables