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>
Subject: Re: export to spreasheet format under unix
Content-Type: text/plain; charset=ISO-8859-1
Wow, proc printing under ODS to FILE = 'path/name/xls' worked
Thanks so much.
On Aug 27, 11:04 pm, Arne And <stig.e...@gmail.com> wrote:
> On 27 Aug, 19:39, Emma Gottesman <emma.gottes...@googlemail.com>
> > 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.