https://communities.sas.com/t5/SAS-Data-Management/Double-data-in-ODBC-data-source-became-currency-after-reading/m-p/498754#M15526 <P>I have a data source whose driver is MariaDB. And the columns are double. But after connecting using libname odbc, they becomes dollar.2 format.</P><P>Data in data source:</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-09-25_22-26-44.jpg" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23506iEEEE4D18C0751B9F/image-size/large?v=v2&amp;px=999" role="button" title="2018-09-25_22-26-44.jpg" alt="2018-09-25_22-26-44.jpg" /></span></P><P>Compare:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-09-25_22-41-41.jpg" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23508i205110A492C5A412/image-size/large?v=v2&amp;px=999" role="button" title="2018-09-25_22-41-41.jpg" alt="2018-09-25_22-41-41.jpg" /></span></P><P>The problem is that when I tried to append an SAS dataset into the data source. SAS told me that data types are different:</P><P>&nbsp;</P><P><STRONG>WARNING: Variable code has format 'DOLLAR.'n on the BASE data set and format 'BEST12.'n on the DATA data set. 'DOLLAR.'n used.</STRONG></P><P>&nbsp;</P><P>Here base data is the data source. And an error also occurred because one of my column has large values:</P><P>&nbsp;</P><P><STRONG>CLI execute error: [ma-3.0.3][10.3.9-MariaDB]Out of range value for column 'TCAP' at row 1</STRONG></P><P>&nbsp;</P> Tue, 25 Sep 2018 15:03:25 GMT kilasue 2018-09-25T15:03:25Z https://communities.sas.com/t5/SAS-Data-Management/Double-data-in-ODBC-data-source-became-currency-after-reading/m-p/498754#M15526 <P>I have a data source whose driver is MariaDB. And the columns are double. But after connecting using libname odbc, they becomes dollar.2 format.</P><P>Data in data source:</P><P>&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-09-25_22-26-44.jpg" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23506iEEEE4D18C0751B9F/image-size/large?v=v2&amp;px=999" role="button" title="2018-09-25_22-26-44.jpg" alt="2018-09-25_22-26-44.jpg" /></span></P><P>Compare:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2018-09-25_22-41-41.jpg" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/23508i205110A492C5A412/image-size/large?v=v2&amp;px=999" role="button" title="2018-09-25_22-41-41.jpg" alt="2018-09-25_22-41-41.jpg" /></span></P><P>The problem is that when I tried to append an SAS dataset into the data source. SAS told me that data types are different:</P><P>&nbsp;</P><P><STRONG>WARNING: Variable code has format 'DOLLAR.'n on the BASE data set and format 'BEST12.'n on the DATA data set. 'DOLLAR.'n used.</STRONG></P><P>&nbsp;</P><P>Here base data is the data source. And an error also occurred because one of my column has large values:</P><P>&nbsp;</P><P><STRONG>CLI execute error: [ma-3.0.3][10.3.9-MariaDB]Out of range value for column 'TCAP' at row 1</STRONG></P><P>&nbsp;</P> Tue, 25 Sep 2018 15:03:25 GMT https://communities.sas.com/t5/SAS-Data-Management/Double-data-in-ODBC-data-source-became-currency-after-reading/m-p/498754#M15526 kilasue 2018-09-25T15:03:25Z https://communities.sas.com/t5/SAS-Data-Management/Double-data-in-ODBC-data-source-became-currency-after-reading/m-p/506181#M15705 <P>Have you made any progress on this? The DBTYPE option might be worth trying:</P> <P><A href="https://documentation.sas.com/?docsetId=acreldb&amp;docsetTarget=p1dqaq7ub1cm1pn1ow3x9qkmkxe8.htm&amp;docsetVersion=9.4&amp;locale=en" target="_blank">https://documentation.sas.com/?docsetId=acreldb&amp;docsetTarget=p1dqaq7ub1cm1pn1ow3x9qkmkxe8.htm&amp;docsetVersion=9.4&amp;locale=en</A></P> Fri, 19 Oct 2018 22:17:47 GMT https://communities.sas.com/t5/SAS-Data-Management/Double-data-in-ODBC-data-source-became-currency-after-reading/m-p/506181#M15705 SASKiwi 2018-10-19T22:17:47Z