Can someone please explain me the following code,   filename excelout filesrvc parenturi="&SYS_JES_JOB_URI"  name='_webout.xlsx'  contenttype='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'  contentdisp='attachment; filename="my_excel_file.xlsx"';  ; ods excel file=excelout style=htmlblue options(sheet_name="Receipt Data" embedded_titles='yes'); ... View more

Hello Guys,   I Created a SAS Viya Job definition for download excel files of reports, Now I getting he excel file but I also want to show the user what are they downloading. I attached the SAS code which I used in this job also the html Form to understanding. Also attached the snapshot of Preview of HTML Form.   ... View more

Created a viya job with help of existing stored process but after using URL of that job in SAS visual analytics it's getting error that access denied which I don't understand. ... View more

Hello Everyone,         In SAS Enterprise Guide, I constructed a stored process that I then imported into SAS VIYA and turned into a viya job. I make that job able to download the excel file after doing some code changes. In order to allow other users to download the report to their devices, I now want to use this job in my sas visual analytics dashboards. To do that I'm using URL of this job in web content object of sas va. Now my concern is the title of this report showing the path of stored process where I saved it(Snapshot Attached). Can we edit that For user understanding? Also the content shown in image of prompts, Can we put that in the centre of the report?  Additionally, the report I getting of it is in another tab called 'Results'. Can we do anything to open in the same report?  Furthermore, I have to right-click the _webout.xlsx file in order to get the spreadsheet file. Why isn't it downloading instantly when I click on it?(Snapshot Attached)  @Stu_SAS Thanks for helping. ... View more