Hi:
Since this is mixed content (Proc REPORT output, CSV file, TXT file), I'd recommend using TRANSIENT output type -- either the Stored Process Server or Workspace Server will create transient output.
When you submit a Stored Process that returns transient results -- and has multiple output files in the transient package -- when the SP executes using the Stored Process Web Application, the transient package comes back to a temporary internet cache file and what displays on the browser screen is an HTML frame with the different outputs in a navigation area on the left.
When you click on the HTML output, the HTML file shows in the browser. When you click on the CSV output, if the CSV filetype is registered to Excel on your system, then the browser would launch Excel to open the CSV file. If the CSV filetype is NOT registered to Excel, then I think the file will open in the browser, as text. When you click on the TXT file, the file shows in a notepad-ish viewer inside the browser.
(Of course, if your transient package just has one result -- like 1 proc report output -- then you would not see the frame.)
This Tech Support note shows how to insert multiple outputs into one "package" file:
http://support.sas.com/kb/19/824.html
The code below modifies the example code to use PROC REPORT, CSV and DATA _NULL_ only. There is another syntax for sending output to packages using DATA step CALLS. For more information on that method, you would have to read the documentation or consult with Tech Support.
cynthia
*************************** code **********************************
[pre]
/* This stored process creates multiple files and inserts */
/* them in the result package */
/* ** based on this Tech Support note:
http://support.sas.com/kb/19/824.html ** */
*ProcessBody;
%let _odsdest = HTML;
%let _odsoptions=file="procreport.html";
%let _odsstyle=egdefault;
%let _odsstylesheet=;
%STPBEGIN;
/* Files in the "&_STPWORK" directory will be copied to the result */
/* package. The &_STPWORK directory is "allocated" when the stored process starts */
/* Insert the first "procreport.html" file using "HTML destination" turned on above */
proc report data=sashelp.class nowd;
title 'Proc Report';
run;
/* Insert "file1_ASCII.txt" file */
filename stpout "&_STPWORK\file1_ASCII.txt";
data _null_;
file stpout;
put "Twas brillig and the slithy toves";
put "Did gyre and gimble in the wabe";
put "All mimsy were the borogroves";
put "And the momeraths outgrabe";
run;
/* Insert the "file2_CSV.csv" file */
ods csv file='file2_CSV.csv' path="&_STPWORK";
proc print data=sashelp.class;
run;
ods csv close;
/* Insert second Proc report "file4_rep.htm" file */
ods msoffice2k file='file4_rep.htm' path="&_STPWORK" style=analysis;
proc report data=sashelp.shoes nowd;
title 'Region Report from Proc Report';
column region sales;
define region /group;
define sales/ sum;
rbreak after / summarize;
run;
ods msoffice2k close;
%STPEND;
[/pre]