SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Security Concern - Publishing Google Sheet for SAS access using FILENAME

Accepted Solution Solved
Reply
Highlighted
New Contributor
Posts: 4
Accepted Solution

Security Concern - Publishing Google Sheet for SAS access using FILENAME

Hello,

 

I've done some searching and found this link re: importing data from google sheets. 

 

“There’s an App for That”: It’s Called SAS® ODS! Mobile Data Entry and Reporting via SAS ODS

 

I have some concerns regarding the steps taken on the google side of things with regards to "publish to the web". I cannot find much information with what exactly this means. Some posts say that this will not make the page crawlable but others do.

 

 Can anyone confirm that "publishing" will not make a sheet crawlable/indexable?

Is there another way to approach this?

 

Thank you!


Accepted Solutions
Solution
‎12-19-2017 01:20 PM
Super User
Posts: 22,844

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

 

 

If Google Drive is set up on your computer and you're not running SAS on a server, it looks like just a drive to your computer and you can work with it as a network drive including accessing Excel files. If you are running SAS on a server, it needs a connection to the Drive as well, but once that's set up it's the same as working locally. I do this via Box to keep all my files synced across my multiple machines.

 

However, it does have some annoying features and one I've seen and run into is the syncing. If the files don't sync correctly sometimes it ends up duplicating files and to be helpful it renames them with a number at the end...and then your file isn't named the way you thought and your programs don't work.  I've seen this both on One Drive and Box. 

 

Another option, with the github link to code at the end:

http://support.sas.com/resources/papers/proceedings13/001-2013.pdf

 

 

View solution in original post


All Replies
Super User
Posts: 22,844

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

Not sure I'm interpreting your question correctly, but I think you're asking if you set a sheet to public/anyone with a link, will that spreadsheet now show up in search results?

 

Google scans and indexes everything on their side. They pull down articles in peoples private Google Docs storage. So, yes it's scanned and indexed.

 

Will the results be included in Google Search results publicly? Not if its not a public document. If it's a public document then it may be, but that's a question better asked in a Google Forum, not SAS forum. 

 

From what I can see, the publish to the web, share link option, does not make it return in a Google Search. If you do a full public publish it will return in a search result. 

 

Here's the link to the Google Forum if you'd like to post your question there:

https://productforums.google.com/forum/#!forum/docs

 


dashj wrote:

Hello,

 

I've done some searching and found this link re: importing data from google sheets. 

 

“There’s an App for That”: It’s Called SAS® ODS! Mobile Data Entry and Reporting via SAS ODS

 

I have some concerns regarding the steps taken on the google side of things with regards to "publish to the web". I cannot find much information with what exactly this means. Some posts say that this will not make the page crawlable but others do.

 

 Can anyone confirm that "publishing" will not make a sheet crawlable/indexable?

Is there another way to approach this?

 

Thank you!


 

New Contributor
Posts: 4

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

I assumed I'd get this type of answer regarding the google side. Too bad there is not a "better" way.
Super User
Posts: 22,844

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME


dashj wrote:
I assumed I'd get this type of answer regarding the google side. Too bad there is not a "better" way.

That wasn't the question you asked....

 

That paper you're referencing is also from 2012. What are you actually trying to achieve here?

New Contributor
Posts: 4

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

 


Reeza wrote:

dashj wrote:
I assumed I'd get this type of answer regarding the google side. Too bad there is not a "better" way.

That wasn't the question you asked....

 

That paper you're referencing is also from 2012. What are you actually trying to achieve here?


 

I'm looking for a way to import/export excel data from google sheets.

Super User
Posts: 22,844

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME


dashj wrote:

 

I'm looking for a way to import/export excel data from google sheets.


Do you have Excel files in Google Drive or do you have Google Sheet files? 

Or is there some feature I'm not aware of that allows Excel files within Google Sheets?

New Contributor
Posts: 4

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

Google sheets would be ideal but if necessary, I could do excel files stored in google drive.

 

We are migrating to Google suite and losing our network drives so I'm looking to find a solution so that I don't lose the programs I've automated.

Solution
‎12-19-2017 01:20 PM
Super User
Posts: 22,844

Re: Security Concern - Publishing Google Sheet for SAS access using FILENAME

 

 

If Google Drive is set up on your computer and you're not running SAS on a server, it looks like just a drive to your computer and you can work with it as a network drive including accessing Excel files. If you are running SAS on a server, it needs a connection to the Drive as well, but once that's set up it's the same as working locally. I do this via Box to keep all my files synced across my multiple machines.

 

However, it does have some annoying features and one I've seen and run into is the syncing. If the files don't sync correctly sometimes it ends up duplicating files and to be helpful it renames them with a number at the end...and then your file isn't named the way you thought and your programs don't work.  I've seen this both on One Drive and Box. 

 

Another option, with the github link to code at the end:

http://support.sas.com/resources/papers/proceedings13/001-2013.pdf

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 280 views
  • 1 like
  • 2 in conversation