I am trying to import a hive data into SAS using ODBC connection to HIVE server. In one of the columns of HIVE table there are carriage return characters.
When I import the data into SAS from HIVE table, the values of the column containing carriage return are moved to next column/row.
Please post your import code. Normally, I would expect the ODBC to handle this correctly. I suspect that somewhere in between there's a conversion to a text file/stream where the CR's have their unpleasant effect.
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.