How to using macro variable from Program tab into HTML tab in Job Defination ?

[GioiAce]

Hi everyone, could you please help me with this issue? I want to access the TABLE_OPTIONS variable from the Program tab inside the HTML tab.

As you can see, this is the value of the TABLE_OPTIONS variable that was printed after I clicked the Run button:

[Tom]

Is this a Job definition in SAS Viya?

I doubt that HTML itself could ask SAS to provide the current value of a macro variable.  Are you asking how to copy and paste the text you wrote in the log into the HTML tab so you can save that static text as part of the Job definition?

If not I would look at the demo jobs that SAS has provided that show how to drive an HTML selector from the contents of a dataset.

[GioiAce]

Hi Tom,
I want to retrieve the value of the variable TABLE_OPTIONS and pass it to an HTML Tab so that it can be rendered as a drop-down list for the user to select options.

[Tom · Accepted solution]

You have a dataset named TABLE_LIST with a variable named TABLE_NAME that you want to use to control the HTML selector named TABLE.

Here is a SAS help page that shows how to do this for the dataset named SASHELP.CARS and the variable named MAKE.

https://communities.sas.com/t5/SAS-Communities-Library/All-the-Above-Building-a-Multi-Selection-HTML...

[GioiAce]

Thank you so much