Hello, we have written a transformation which will load data to hadoop from sqlserver library.
The problem is that we are losing the labels of my columns. Any idea?
data &hdfsLibref..&outtable (/*debug optie: logupdate=yes */blocksize=64M label="&tableDescr.");
set &_input;
run;
The concept of label is local to SAS. Some databases have similar concepts, but they are not supported by SAS/ACCESS engines unfortunately.
One way of enforcing labels is to store them in SAS metadata, and use the META libname engine.
"Have to" is a strong statement, but yes (during query time, not necessarily during update).
yes we have different metadataservers
we load from Eguide to hadoop to LASR. Ofcourse, it's not important what's in hadoop but we also have no labels in the LASR tables.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.