topic Re: Proc Fedsql Integer Division in Viya gives zero in SAS Procedures

Proc Fedsql Integer Division in Viya gives zero

ARC2 — Tue, 07 Apr 2020 20:49:31 GMT

In the code below, I get 0 for the variable temp. Could you tell me why and ways around it. Thanks.

PROC FEDSQL sessref = sess ;
create table casuser.temp as
select 1/2 as temp;
QUIT;

Re: Proc Fedsql Integer Division in Viya gives zero

Rick_SAS — Wed, 08 Apr 2020 17:42:14 GMT

Just to be clear, did you intentionally leave off the FROM statement? You do not have an input data table?

Re: Proc Fedsql Integer Division in Viya gives zero

ARC2 — Wed, 08 Apr 2020 20:03:38 GMT

Yes, in reality I am multiplying the fraction by some data from an input dataset. I took all that out to focus in on the behavior of the fraction which is zero with or without an input dataset.

Re: Proc Fedsql Integer Division in Viya gives zero

Rick_SAS — Wed, 08 Apr 2020 20:16:40 GMT

To prevent integer division, use

select 1. / 2 as temp;

You can put the decimal point on either the numerator or denominator.

Re: Proc Fedsql Integer Division in Viya gives zero

ARC2 — Wed, 08 Apr 2020 21:58:26 GMT

This is going to trip up SAS 9 programmers.