topic Re: Is there any option which can be used with Bulk load in Proc append in SAS Programming

Is there any option which can be used with Bulk load in Proc append

sk2ks — Fri, 13 Dec 2024 08:41:51 GMT

Hi,

I had an issue when we append SAS dataset-UTF8 ( which has accented letters Ex: "Jôhn Sørina Jokūbas Binï Noël" ) to an existing Oracle base table using proc append with bulk load option yes, these accented letters are stored in oracle table as double question marks (??).
But when I use proc append without bulk load option everything works fine as expected ( all accented letters are appended to the base table)

Reaching out to you to check if we can use any SAS option with bulk load to deal this issue.

Found this on web for Greenplum- 40346 - Using the BL_ENCODING option with SAS/ACCESS® Interface to Greenplum to bulk load data results in 'Invalid option name "BL_ENCODING"' error

I get an error - invalid SAS option when I tried using BL_ENCODING

Is BL_ENCODING a valid SAS option with Oracle? Lookig for an option which can be used with proc append with bulk load.

Any suggestion would be much appreciated!

Thanks,

Sri

Re: Is there any option which can be used with Bulk load in Proc append

Patrick — Fri, 13 Dec 2024 11:00:26 GMT

The available Data Set Options for Oracle are fully documented. BL_ENCODING is not in the list.

Shouldn't you find a solution then best contact SAS Tech Support. ...and update here if and what the solution is.

Have you already seen this discussion? Sadly the OP never updated it with what worked in the end.

Re: Is there any option which can be used with Bulk load in Proc append

LinusH — Mon, 16 Dec 2024 09:31:09 GMT

I'm threading on thin ice here, but could you modify/create you own SQL*Loader control file?

It seems that you can configure the loading with aspect to encoding and separators.

And then use BL_CONTROL ds option to call it.