Remove Carriage Return in SAS dataset imported from Hive

deepika2 — Wed, 22 Nov 2017 06:15:34 GMT

Hi ,

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.

Can anyone please help me solve this.

Thanks

Re: Remove Carriage Return in SAS dataset imported from Hive

Kurt_Bremser — Wed, 22 Nov 2017 09:24:38 GMT

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.

topic Remove Carriage Return in SAS dataset imported from Hive in SAS Data Management

Remove Carriage Return in SAS dataset imported from Hive

Re: Remove Carriage Return in SAS dataset imported from Hive