SAS Streaming output to Excel -


i'm running sas stored process create reports , output in excel, website returns html output instead of excel output.

%let rc = %sysfunc(appsrv_header(content-type, application/vnd.ms-excel)); %let _odsdest=tagsets.excelxp;  %stpbegin;    ods tagsets.excelxp    style=printer    options(sheet_name='xxxxxxxxxx' );   ods proclabel='xxxxxxxxxxx';    proc report data= xxx    ---   ---   ---    run;   ods tagsets.excelxp close;  %stpend; 

i tried code sas support, still returns html output. what's wrong code, or sth not work in systems? thanks

the function stpsrv_header not appsrv_header


Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -

java - How can I send the data from a imput type="file" to the controller? -