12-14-2015 03:01 AM
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
12-16-2015 10:33 AM
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.