BookmarkSubscribeRSS Feed
valdesr15
Fluorite | Level 6

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

10 REPLIES 10
art297
Opal | Level 21

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

 

Art, CEO, AnalystFinder.com

 

valdesr15
Fluorite | Level 6

I already tried it and it does not work Smiley Sad

 

 

art297
Opal | Level 21

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

 

Art, CEO, AnalystFinder.com

 

 

 

valdesr15
Fluorite | Level 6

what's going on? any ideas


2017-04-15.png
art297
Opal | Level 21

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

 

ChrisHemedinger
Community Manager

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.

 

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
ChrisHemedinger
Community Manager

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.

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
valdesr15
Fluorite | Level 6

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

ChrisHemedinger
Community Manager

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

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 10 replies
  • 9285 views
  • 8 likes
  • 3 in conversation