Date:         Tue, 30 May 2006 11:51:32 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: SAS/intrnet sending output to excel

you should name the output dataset with something with .XLS at the end, no
matter what the content is. That will open excel if you have .XLS associated
with EXCEL.



On Sun, 28 May 2006 22:03:46 -0700, joshn <joshis@GMAIL.COM> wrote:

>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