Date:         Fri, 28 Aug 2009 05:50:42 -0700
Reply-To:     Emma Gottesman <emma.gottesman@GOOGLEMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Emma Gottesman <emma.gottesman@GOOGLEMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: export to spreasheet format under unix
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Wow, proc printing under ODS to FILE = 'path/name/xls'  worked
beautifully.
Thanks so much.

--Emma

On Aug 27, 11:04 pm, Arne And <stig.e...@gmail.com> wrote:
> On 27 Aug, 19:39, Emma Gottesman <emma.gottes...@googlemail.com>
> wrote:
>
>
>
> > I'm running SAS 9.1 under Solaris I have a table I need to output such
> > that a client can download it and open it in a spreadsheet.  As far as
> > I know proc export won't produce .xls format under solaris.
>
> > Up til now I've been using proc export to output to csv format.
> > However, my data needs to include a link and when the csv is opened
> > with a spreadsheet I just see the raw HTML in the relevant column and
> > so it doesn't function as a link.
>
> > Previously in similar situations I've used Proc Print to show the
> > whole table in a web report and the client has then selected the data
> > and copied and pasted it into a spreadsheet. This preserves the link
> > but the amount of data in this case makes this an extremely cumbersome
> > method.
>
> > Any suggestions on a way around this?
>
> > --Emma
>
> I have used ODS chtml file="/path/file.xls";
> It will produce HTML, but Excel will open it up fine. The links will
> probably work as well.
> Stig