topic Re: Import data Google SpreadSheet in SAS Studio

Import data Google SpreadSheet

valdesr15 — Sat, 15 Apr 2017 01:13:04 GMT

How can I import data from a Google Spreadsheet to Sas Studio?
Please help me, I have tried with this code, but it does not work

FILENAME running url
'https://docs.google.com/spreadsheets/d/1imuF6wDrCcAlLSY4Q4LYhCOpnEyWssnxgLY7qVCWpng/pub?output=csv' debug;
proc import datafile=running out=running
DBMS=CSV REPLACE;
GETNAMES=Yes;
DATAROW=2;
run;

I appreciate your help

Re: Import data Google SpreadSheet

art297 — Sat, 15 Apr 2017 03:33:35 GMT

This might be what you're looking for: http://support.sas.com/resources/papers/proceedings12/240-2012.pdf

Art, CEO, AnalystFinder.com

Re: Import data Google SpreadSheet

valdesr15 — Sat, 15 Apr 2017 18:54:11 GMT

I already tried it and it does not work

Re: Import data Google SpreadSheet

art297 — Sat, 15 Apr 2017 19:04:33 GMT

Your code worked for me and created the 'running' sas dataset. What kind of error are you getting?

Art, CEO, AnalystFinder.com

Re: Import data Google SpreadSheet

valdesr15 — Sat, 15 Apr 2017 22:46:49 GMT

what's going on? any ideas

Re: Import data Google SpreadSheet

art297 — Sun, 16 Apr 2017 00:18:42 GMT

Post your actual log. The part you captured only said the file doesn't exist, which we know isn't true!

Do you have web access permission when you're running SAS Studio. If you're on UE, you don't!

Art, CEO, AnalystFinder.com

Re: Import data Google SpreadSheet

ChrisHemedinger — Sun, 16 Apr 2017 00:26:01 GMT

SAS University Edition can access the web, but cannot access HTTPS (SSL) because it doesn't include the encrypt/decrypt components that are needed.

If using SAS Studio outside of SAS University Edition, try this method:

http://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/

It includes a Google Doc example.

Re: Import data Google SpreadSheet

valdesr15 — Sun, 16 Apr 2017 02:30:31 GMT

What is my error?

https://www.youtube.com/watch?v=t2n4EDXDv8M

Re: Import data Google SpreadSheet

ChrisHemedinger — Sun, 16 Apr 2017 02:46:56 GMT

I think it's because you are using SAS University Edition, and so you cannot access the https Google docs site. SAS University Edition does not include the SSL support needed to access secure web sites.

Re: Import data Google SpreadSheet

valdesr15 — Sun, 16 Apr 2017 03:06:12 GMT

Thanks, in this video show that are saved in "file shortcuts" will open way to call them from there?

https://www.youtube.com/watch?v=Ex3x9YPMEFA

Re: Import data Google SpreadSheet

ChrisHemedinger — Sun, 16 Apr 2017 03:27:15 GMT

Use your browser to save the Google Doc download in your shared folder (for SAS University Edition). Then you can use something like:

filename myfile '/folders/myfolders/savedfile.csv';

To reference it, and PROC IMPORT from there.

See:

https://support.sas.com/software/products/university-edition/faq/shared_folder_whatis.htm

And:

https://support.sas.com/software/products/university-edition/faq/shared_folder_access.htm