topic Re: WHERE clause INCOME < 0 does not show rows where income is in minus in SAS Programming

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

Akhila1 — Wed, 30 Nov 2022 19:25:57 GMT

Proc sql;

select * from mytable

where income < 0;

run;

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

Quentin — Wed, 30 Nov 2022 19:31:56 GMT

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;

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

Kurt_Bremser — Wed, 30 Nov 2022 19:47:21 GMT

Maxim 3: Know Your Data.

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

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

PaigeMiller — Wed, 30 Nov 2022 20:43:57 GMT

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.

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

ballardw — Wed, 30 Nov 2022 21:24:26 GMT

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.

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

gema — Wed, 18 Jan 2023 16:30:58 GMT

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