topic Re: Applying labels to a SAS Visual Analytics LASR table in code in SAS Visual Analytics

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

Filipvdr — Mon, 15 Oct 2018 11:10:53 GMT

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.

Re: Applying labels to a SAS Visual Analytics LASR table in code

alexal — Mon, 15 Oct 2018 10:54:19 GMT

@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;

Re: Applying labels to a SAS Visual Analytics LASR table in code

Filipvdr — Mon, 15 Oct 2018 11:02:07 GMT

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

Re: Applying labels to a SAS Visual Analytics LASR table in code

alexal — Mon, 15 Oct 2018 11:23:16 GMT

That code will update the metadata column "Description".

Re: Applying labels to a SAS Visual Analytics LASR table in code

Filipvdr — Mon, 15 Oct 2018 11:28:22 GMT

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;