Reading Bit Datatype in MSSQL from SAS Dataflux

Helannivas — Mon, 14 Dec 2015 08:01:17 GMT

Hi,

I have a sql server database that has a table with a column of datatype as 'BIT'. The value are 0 and 1 in the table.When I read the data from the SAS Dataflux, the zeros are treated as False and ones as True. But in the final target database . we have the datatype as "Numeric" for that column.

My SAS Dataflux job throws an error for the above issue. Anyone has a solution for the issue? Pls. help

Re: Reading Bit Datatype in MSSQL from SAS Dataflux

LinusH — Wed, 16 Dec 2015 15:33:59 GMT

I haven't use df in "real life", so this might out of bounds.

But, what stops you for storing the boolean value in the target database?

Otherwise, just to a conditional assignment, if true then 1 else 0 type of thing.

topic Reading Bit Datatype in MSSQL from SAS Dataflux in SAS Data Management

Reading Bit Datatype in MSSQL from SAS Dataflux

Re: Reading Bit Datatype in MSSQL from SAS Dataflux