SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Reading Bit Datatype in MSSQL from SAS Dataflux

Reply
Frequent Contributor
Posts: 101

Reading Bit Datatype in MSSQL from SAS Dataflux

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

Super User
Posts: 5,427

Re: Reading Bit Datatype in MSSQL from SAS Dataflux

Posted in reply to Helannivas

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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 278 views
  • 0 likes
  • 2 in conversation