topic Re: Inequality signs issue in SAS Programming

Inequality signs issue

pmpradhan — Sun, 20 May 2018 20:56:38 GMT

My data is as follows:

ID [num var] Percent [Character var]
1452 10
1254 20.00
4852 30
7526 40
7542 0
7530 50.00
9856 50
3256 51
7854 100
7128 500
1287 80
4568 5.00
7540 8.00
9530 9
9920 25

I'm trying to create another dataset from the above data where the percent is larger than 0 and less than or equal to 50.

I used

proc sql;
create table x as
select id, percent from test where "0"<percent<="50";
quit;

but it gives me the observation that has 100 percent.

Please help!

Re: Inequality signs issue

Astounding — Sun, 20 May 2018 21:08:38 GMT

As you have seen, SAS compares character strings differently. Try it this way:

where 0 < input(percent, 8.) <= 50

Re: Inequality signs issue

novinosrin — Sun, 20 May 2018 21:09:51 GMT

remove the quotes in "0"<percent<="50"; and try again. I believe the auto conversion should take effect

Re: Inequality signs issue

TomKari — Sun, 20 May 2018 21:10:15 GMT

Not tested, but I don't believe that comparison format works in a SQL query. Try

"0" < percent and percent <="50"

Also, if your "percent" variable is character, it is VERY likely you'll get unexpected results from a character comparison. Test carefully! If "percent" is numeric, remove the double quotes from 0 and 50.

Tom

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:13:29 GMT

Thank you but I got this error when implementing "where 0 < input(percent, 8.) <= 50 " ERROR: Syntax error while parsing WHERE clause.

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:13:56 GMT

Tried it didn't work. 😞

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:15:48 GMT

Tried but this also gives me the observation that has percent =100.

Re: Inequality signs issue

novinosrin — Sun, 20 May 2018 21:16:46 GMT

ok sorry,no worries as you have @Astounding converted solution.

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:17:55 GMT

Well that didn't work as well.

Re: Inequality signs issue

novinosrin — Sun, 20 May 2018 21:26:55 GMT

please post your log

data have;
do var='1','2','3','4','5';
output;
end;
run;
proc sql;
create table want as
select *
from have
where 2<input(var,8.)<=4;
quit;

Re: Inequality signs issue

Astounding — Sun, 20 May 2018 21:35:49 GMT

If you really want help with this, post the log. It should be relatively tiny, and the solution should be relatively simple. "Syntax error" doesn't say enough.

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:39:54 GMT

Yes, this worked! Thank you! 🙂

Re: Inequality signs issue

pmpradhan — Sun, 20 May 2018 21:40:50 GMT

Thank you so much! this worked!