SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DI 3.4: remove labels during tables importing.

Reply
Occasional Contributor
Posts: 9

DI 3.4: remove labels during tables importing.

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

Respected Advisor
Posts: 3,124

Re: DI 3.4: remove labels during tables importing.

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

Super User
Posts: 5,257

DI 3.4: remove labels during tables importing.

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

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 189 views
  • 0 likes
  • 3 in conversation