topic Re: How to using macro variable from Program tab into HTML tab in Job Defination ? in SAS Programming

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

GioiAce — Fri, 27 Feb 2026 09:30:26 GMT

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:

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

Tom — Fri, 27 Feb 2026 16:05:48 GMT

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.

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

GioiAce — Mon, 02 Mar 2026 02:30:11 GMT

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.

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

Tom — Mon, 02 Mar 2026 14:35:11 GMT

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-Form-in-a-SAS-Viya/ta-p/967609

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

GioiAce — Tue, 03 Mar 2026 09:01:55 GMT

Thank you so much