file not found when called from _webout macro, but works in browser

cuevasj — Thu, 06 Jun 2019 13:57:34 GMT

I have a stored process that is called from a VA stored process container. I have several radio buttons and dropdowns all working fine, but when I try to call a file, it will not render. I tried calling a second stored process that only contains the link to the file, but that did not work either. The message I keep getting is that the file does not exist. However when I cut and paste that file in the web browser, it will render.

I have tried using, what I thought would be the obvious answer:

%let stpname=/DCPS Departments/Quick Reports/Stored Processes/QR MS Scorecard sp;

%macro display_form;
data _NULL_;
file _webout;

put "<html>";
put " <head>";
put " <style media='screen' type='text/css'>";
put " .border {border-width: 1px; border-style: solid;}";

put "<INPUT TYPE='HIDDEN' NAME='_program' VALUE='&stpname'>";

---bunch of code here---

put " <input type='submit' value='Generate Excel File' class='generate_report' style='font-weight: bold; font-size: 20px'>";

stop;

run;

%mend;

%macro main;

---buch of code here---

%mend;

%main;

Re: file not found when called from _webout macro, but works in browser

AllanBowe — Mon, 01 Jul 2019 11:22:00 GMT

if you are returning a file from a stored process, you need to set the MIME type, eg as follows:

  /* now serve zip file to client */
  data _null_;
    rc = stpsrv_header('Content-type','application/zip');
    rc = stpsrv_header('Content-disposition',"attachment; filename=&table..zip");
  run;

topic file not found when called from _webout macro, but works in browser in Developers

file not found when called from _webout macro, but works in browser

Re: file not found when called from _webout macro, but works in browser