Date:         Sun, 28 May 2006 22:03:46 -0700
Reply-To:     joshn <joshis@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         joshn <joshis@GMAIL.COM>
Organization: http://groups.google.com
Subject:      SAS/intrnet sending output to excel
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi All,

I am trying to get the output from a sas prog to open in excel, but
can't seem to change the http header content-type with:

%let rc=%sysfunc(appsrv_header(content-type,application/vnd.ms-excel));
%let
rc=%sysfunc(appsrv_header(content-disposition,%str(attachment;filename=myfile.xls)));


I have tried with proc template, but it still appears in IE.

      proc template;
      define style outstyle;
        parent=styles.minimal;
        HTMLCONTENTTYPE= "application/vnd.ms-excel";
      end;
      run;

Here is my ODS statement:

ods markup body=_webout(Dynamic) tagset=sas_web style=outstyle ;
(sas_web has custom excel xml tags.)

/*output*/

ods markup close;


Should this be working?

Thanks,

Joshn