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
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.