Prev: Try Free Project Management Software
Next: Cannot generate macro variables from PROC SQL
From: Tor Kamsvåg on 4 Jun 2010 06:39
Does anyone have experience of using the google spreadsheet API:s from
SAS to dynamically access data stored in a google spreadsheet on the
web? i.e. using google spreadsheets as data source in SAS.

http://code.google.com/intl/sv-SE/apis/spreadsheets/data/3.0/developers_guide.html

It could be quite useful for instance as a ready-to-use data entry
interface targeting distributed users.
From: Phil Rack on 4 Jun 2010 07:36
On Jun 4, 6:39 am, Tor Kamsvåg <tkams...(a)gmail.com> wrote:
> Does anyone have experience of using the google spreadsheet API:s from
> SAS to dynamically access data stored in a google spreadsheet on the
> web? i.e. using google spreadsheets as data source in SAS.
>
> http://code.google.com/intl/sv-SE/apis/spreadsheets/data/3.0/develope...
>
> It could be quite useful for instance as a ready-to-use data entry
> interface targeting distributed users.

Take a look at this blog post by David Smith from Revolution Computing
on how they do it using R. He gives all the background you need to set
this up.
http://blog.revolutionanalytics.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html

I also wrote a blog post about using WPS (a SAS Language alternative)
to do the same thing: http://minequest.com/WordPress/?p=347

Here is the code I use in the example.

filename in url
'http://spreadsheets.google.com/pub?
key=tmo617BhN3qwbGBCXI9yWGQ&single=true&gid=0&output=csv';

proc import datafile=in out=mydata
dbms=csv replace; getnames=yes;
run;

proc print data=mydata ;
var Country Jan_89 - Jan_95;
sum Jan_89 - Jan_95 ;
format Jan_89 - Jan_95 comma11.;
run;
 | 
Pages: 1
Prev: Try Free Project Management Software
Next: Cannot generate macro variables from PROC SQL