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¶m1={%1}¶m2={%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
... View more