Applying labels to a SAS Visual Analytics LASR table column labels in code

[Filipvdr]

Hello,

I have my labels stored in a macrovariable. I want to apply them to my LASR table but i'm receiving an error.

Do i have to change the assigning of my library? Or are there other possibilties? I prefer not to do a datastep.

proc datasets library=&lasrLibref;
modify &outtable;
label &label_sql_dataset;
run;

ERROR: Update access is not supported for file KS1BU01L.TEST_1510_1149.DATA.

[alexal]

@Filipvdr,

You have to use metadata_setattr function, because you need to update a metadata entry for that table.

data _null_;
rc=metadata_setattr("omsobj:PhysicalTable?@Id='<TABLE_ID>'","Desc","This is a new label");
put rc=;
run;

[Filipvdr]

Is your code for column label? Or for the table label?

[alexal]

That code will update the metadata column "Description".

[Filipvdr]

Hi, 

I've solved it with putting the labels in my datastep statement which will load the data to hadoop from SQL database.

/* upload to hadoop with labels */
data &hdfsLibref..&outtable (/*debug optie: logupdate=yes*/ blocksize=64M label="&tableDescr.");
set &_input;
label &label_sql_dataset;
run;