Reading Bit Datatype in MSSQL from SAS Dataflux

[Helannivas]

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

[LinusH]

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.