I have a SAS VIYA report with a JOB that needs to export an excel file

[cuevasj]

Product Name: SAS Job Execution

Release: 2.1

SAS Viya release: V.03.04

Build Date: June 12,2018

Product Name: SAS Report Viewer

Release: 8.3.1

SAS Viya release: V.03.04

I have a report with a dial. On the dial I have a tool tip, "School_PK". It is numeric value that is passed to a JOB that is connected to this report. When I double-click on the dial, the JOB is executed, passed the current school_pk value to the JOB, and everything works great, with one exception. The JOB appears on a second tab rather than open in as a downloaded excel document that the end user can open and manipulate as needed.

What do I need to add to my JOB code to make it a downloaded excel file on the users computer?

I have added "_output_type" as a parameter under the JOB properties and then added "ods_excel" as the Default value, but this does not work. It produces and excel file :  'SASResults.xlsx'   . When I remove the quotes, the file says it is corrupted and cannot be opened.

If I convert my JOB to "ods tagsets.excelxp ..." in lieu of "ods excel ..." , then I can get a download, but the downloaded file exports into the download folder with single quotes around it, so I have to open the download file, delete the first and last quote and then okay the conversion to excel. There is no way I can deploy this project like that. End users will not want to, nor understand why, it is necessary to remove those quotes.

Any suggestions? Am I using the wrong output type for a JOB? 

[Vince_SAS]

Can you post the Job code that creates the Excel file?

Vince DelGobbo

SAS R&D

[cuevasj · Accepted solution]

* Create the Excel XML output and associate with the job;
filename xmlfile filesrvc parenturi="&SYS_JES_JOB_URI"
name='_webout.xml'
contenttype='application/vnd.ms-excel'
contentdisp='attachment; filename="&VA_school_year." MS Promo &today..xml';

ods tagsets.excelXP file=xmlfile options(sheet_name="Overall Schoolwide Progress" frozen_headers='1');

...then proc report or whatever you would like to have in you excel file here ...