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

symfony - InvalidConfigurationException in SecurityExtension.php line 429: No authentication listener registered for firewall "secured_area" -

angular ui router - 10 digest iterations reached in angularjs when using $state.go -

javascript - Handling constructor related functions while testing with mocha and sinon -