Dynamically generate an excel from a visual analytics report (viya) through a job (stored process)

Joy216 — Tue, 22 Oct 2024 09:10:31 GMT

Hello everyone,

I have been trying to do the following but failed so far if anyone can help out, I would appreciate it:

I have a visual analytics report. Inside the report I added a text content container and added a hyperlink with the following form :

http:// <sas-server>/SASStoredProcess/?_program=/path_to_sas_program&param1={%1}&param2={%2}&_log=path_to_log/file.log

when I launch this URL alone using a value instead of the placeholder {%1} and {%2} it works and generates the excel as long as i have a local path to my server explicitly precides in my ODS EXCEL FILE= /path/ statement.

However this is not what I want in the end. the idea is for any user to be able to download the excel output from my sas program by just clicking on the hyperlink. I used the _webout statement:

ods excel file =_webout options(sheet_interval="none"
                                embedded_titles='yes');

when i run my URL it doesn't work and i just get the content of my first sheet displayed on the webpage.

I must precise that the excel generated is supposed to be dynamically filtered according to param 1 and 2 that take values according to the visual analytics report. although I did put the placeholders I couldn't obtain this.

two questions here:

1- how to make this work so that any user from their computer can click on the hyperlink and download the excel?

2- How to configure my URL and macros in sas to dynamically take on their values from the visual analyrics report?

Thank you in advance fo any help provided.

VERSIONS:

Viya 3.5

Visual Analytics 8.5.2

topic Dynamically generate an excel from a visual analytics report (viya) through a job (stored process) in SAS Viya

Dynamically generate an excel from a visual analytics report (viya) through a job (stored process)