Accessing Excel file from server and generate the same as an output to the stored process.

[Micheal_S]

Hello..

I am trying to create a stored process, in which i have to just grab already created excel report from the server and produce the same (without any changes) as an output of the stored process execution. i am trying to do this using stpsrv_header but its not working.

data _null_;
rc= stpsrv_header('Content-type', 'application/vnd.ms-excel');
rc= stpsrv_header('Content-disposition', 'attachment;
filename=outtest.xls');
run;

Did anyone tried this before? Please let me know.

Thanks,

Mike

[Kurt_Bremser]

Have you tried my suggestion I gave you in the other thread about the same issue?

[Micheal_S]

Yes Kurt, I tried it. 

rc = stpsrv_header('Content-disposition','attachment; filename="test.xls"');

Its not giving me any error message but not doing what i intended for. Its just getting executed successfully and no result is coming out. 

[LinusH]

Since this doesn't involve any SAS processing the feels a bit unnecessary to use a Stored Process. Consider using other Web aplication server functionality for this.

[boemskats · Accepted solution]

Michael,

This should work. Have a look at the second half of this post that I wrote ages ago.

You need to use the STP webapp, you need to have Streaming output enabled. Here's the code from the other post.

  filename myFileInput="/myTempFileLocation/&filenameParameter..xml";
  %let RV=%sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel));
  %let RV=%sysfunc(stpsrv_header(Content-disposition,attachment; filename= Histostaffperformance.xml));
  data outmenow;
    length data $1;
    infile myFileInput recfm=n;
    file _webout recfm=n mod;
    input data $char1. @@;
    put data $char1. @@;
  run;

Good luck.

Nik

[Micheal_S]

Hi Boemskats,

Thank you, 

Greatly appreciate it.