https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306077#M20748 Chances are that the format on your output column is too small (no of digits).<BR />That fact should however nor impact the possibility to join on it. Thu, 20 Oct 2016 20:24:02 GMT LinusH 2016-10-20T20:24:02Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306066#M20747 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>When using query builder the result is returning some columns in scientific notation. Is there a way to turn this off? I checked the options but can't find anything related to this. The problem is that we are unable to join tables because some of these scientific notation.&nbsp;</P><P>&nbsp;</P><P>Thanks in advance for your help!</P><P>&nbsp;</P> Thu, 20 Oct 2016 19:55:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306066#M20747 barnsmv 2016-10-20T19:55:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306077#M20748 Chances are that the format on your output column is too small (no of digits).<BR />That fact should however nor impact the possibility to join on it. Thu, 20 Oct 2016 20:24:02 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306077#M20748 LinusH 2016-10-20T20:24:02Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306320#M20751 <P>Thanks for your help!</P> Fri, 21 Oct 2016 15:08:35 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-6-1-query-result/m-p/306320#M20751 barnsmv 2016-10-21T15:08:35Z