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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.