02-02-2012 02:01 PM
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.
02-02-2012 02:07 PM
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;
attrib _all_ label=' ';
attrib _all_ format=;
02-06-2012 09:16 AM
Maybe you could try the DBSASLABEL=NONE libname option.
This will blank out any RDBMS labels, and let SAS use the column names instead.