Proc Fedsql Integer Division in Viya gives zero

[ARC2]

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;

[Rick_SAS]

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

[ARC2]

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. 

[Rick_SAS · Accepted solution]

To prevent integer division, use

select 1. / 2 as temp;

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

[ARC2]

This is going to trip up SAS 9 programmers.