topic ODS Excel file webout in SAS Viya in SAS Studio

ODS Excel file webout in SAS Viya

harshpatel — Wed, 06 May 2020 06:32:22 GMT

Hello Folks,

I am trying to run the below code in SAS Studio in SAS Viya

data _null_;
rc = appsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
rc = appsrv_header('Content-disposition','attachment; filename=test.xlsx');
run;

ods excel file = _webout ;

title "&title";
proc print data=sashelp.class;
run;
ods excel close;

But it is showing error that

Program error.
68-185: The function APPSRV_HEADER is unknown, or cannot be accessed.

Actually i want to link this code with my graphs to download the excel file.

Please help

Regards,

Harsh Patel

Re: ODS Excel file webout in SAS Viya

Kurt_Bremser — Wed, 06 May 2020 07:02:29 GMT

The APPSRV_ functions are part of the Application Dispatcher, which is a SAS/IntrNet 9.4 component, and not available in Viya.

See https://documentation.sas.com/?docsetId=dispatch&docsetTarget=require.htm&docsetVersion=9.4&locale=en

Re: ODS Excel file webout in SAS Viya

harshpatel — Wed, 06 May 2020 07:06:18 GMT

Thank You for your answer.

But what is the solution of my question whether i could download the excel file with this code or any alternate code?