topic Re: DI 3.4: remove labels during tables importing. in SAS Data Management

DI 3.4: remove labels during tables importing.

Costas — Thu, 02 Feb 2012 19:01:05 GMT

I use Data Integration 3.4 and usualy need import tables from oracle by a specific libname. Sometime DI is not able to correctly import labels that contain strange caracters ('), the job produces strange error without to create the log, so I wish to elimitate that.

Is there a mode to resolve it?

I tried with options "nolabel" in the tool for SQL Join but without results.

Thanks

Costantino

Re: DI 3.4: remove labels during tables importing.

Haikuo — Thu, 02 Feb 2012 19:07:49 GMT

Not sure if this is relevent, in SAS Base, one can use proc datasets to remove labels and formats, the following code came from SAS help:

proc datasets lib=work memtype=data;

modify class;

attrib _all_ label=' ';

attrib _all_ format=;

run;

Regards,

Haikuo

DI 3.4: remove labels during tables importing.

LinusH — Mon, 06 Feb 2012 14:16:07 GMT

Maybe you could try the DBSASLABEL=NONE libname option.

This will blank out any RDBMS labels, and let SAS use the column names instead.

/Linus