Date:         Mon, 21 Jul 2008 16:40:10 -0400
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     RFC822 error: <W> MESSAGE-ID field duplicated. Last occurrence
              was retained.
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: Google Aps/Spreadsheet and SAS
In-Reply-To:  <884F070B5CB05742ACAE51AC80574CE20210098E@claexch01.licence.cla.co.uk>
Content-Type: text/plain; charset="us-ascii"

A Google spreadsheet can be saved as an XLS file (File button => Export =>
xls). And you might even be able to automate this.

Perhaps you could save to an xls file and then use PROC IMPORT on it. Note
that you can also export to txt, csv, etc.

HTH,
donh

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Ben Powell
> Sent: Monday, July 21, 2008 12:01 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Google Aps/Spreadsheet and SAS
>
> SAS should be able to download the html source and process
> that although having had a look at the html I think it will
> take some time for you to parse the important part,
> discarding the rest. I've done this with basic html tables
> but a google spreadsheet is more complicated than that.
>
> Rgds
>
> ________________________________
>
> From: ajay ohri [mailto:ohri2007@gmail.com]
> Sent: 21 July 2008 12:37
> To: Ben Powell
> Cc: SAS-L@listserv.uga.edu
> Subject: Re: Google Aps/Spreadsheet and SAS
>
>
> the google spreadsheet is the source of the data as a fixed html page
> /location . can this be done ?
>
>
> On Mon, Jul 21, 2008 at 2:29 PM, <ben.powell@cla.co.uk> wrote:
>
>
>  As opposed to uploading an updated xls that sas has produced?
>
>   What sort of thing do you need to do?
>
>   Rgds
>
>
>     On Fri, 18 Jul 2008 21:39:04 +0530, ajay ohri
> <ohri2007@GMAIL.COM> wrote:
>
>   >Hi List,
>  >
>  >Has anyone worked with outputting /inputting data to Google
> spreadsheet
>    >directly from SAS.
>      >
>  >Regards,
>  >
>  >Ajay
>      >www.decisionstats.com
>
>
>
>
> **********************************************************************
> THE COPYRIGHT LICENSING AGENCY LIMITED
> Registered Office:
> SAFFRON HOUSE
> 6-10 KIRBY STREET
> LONDON
> EC1N 8TS
> Company No. 1690026 (registered in England)
>
> The contents of this email and any attachments are
> confidential to the intended recipient.
> They may not be disclosed to, used by or copied in any way by
> anyone other than the intended recipient.
>
> Whilst any information and/or any opinion given is believed
> to be correct, it is not intended
> to constitute legal advice; you shold seek specific legal
> advice as appropriate.
>
> Please note that the CLA does not accept any responsibility
> for viruses and it is your
> responsibility to scan or otherwise check this email and any
> attachments.
> **********************************************************************
>
>