How to download a CSV file without including HTML code in the body, only the output table.

[cvelazquez]

I have a stored process that produces a table report. When the report is run by the user, I want it to prompt the user to download a csv file. I'm able to get that far with the following code: 

data _null_;
if upcase("&outtype") = "CSV" then do;
rc = stpsrv_header('Content-type','application/vnd.ms-excel;');
rc = stpsrv_header('Content-disposition','attachment; filename=temp.csv');
end;
run;

But the csv file contains all the HTML code (see picture). I need the code to download the file with only the output table and not the HTML code.

 

[ChrisHemedinger]

I assume you have ODS HTML in the code somewhere. If you want the output to be CSV instead, try the CSV destination instead of the HTML destination:

ods csv (id=file) file=_webout;
/* report code */
ods csv (id=file) close;