cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
blaubner
‎06-17-2022
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Connect to private Google Drive Sheet

by Calcite | Level 5 in SAS Programming
‎06-09-2022 09:02 PM
‎06-09-2022 09:02 PM
Evening,   Is it possible to retrieve a google sheet from a private Google Drive using SAS? I found this discussion from a long time ago, but this example is using a google document URL that is public.   https://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/   The data that I would like to retrieve is private and requires a username.    I was just introduced to a solution for R, so I'm wondering if SAS has a solution. The goal is to directly connect to the private Google Drive Sheet and bring the data into the SAS work folder.    Is this possible? ... View more

Re: How To: Import Using Files Names In Working Folder

by Calcite | Level 5 in SAS Programming
‎05-07-2022 12:48 PM
‎05-07-2022 12:48 PM
Sorry I'm not following. If I add a libname to my path, what is the next procedure to read in only the files with a filename from work.fakeset? I don't want to hard code the names myself. I want SAS to do this procedure automatically. I'm assuming a macro needs to be established? I'm not familiar with macros yet.   I don't want to do this...   data fakeset; length fref $8 fname $200; did = filename(fref,'Fake\Path'); did = dopen(fref); do i = 1 to dnum(did); fname = dread(did,i); output; end; did = dclose(did); did = filename(fref); keep fname; run; libname want 'Fake\Path'; data notwhatiwant; set want.fake1 want.fake2 want.fake3; run;    ... View more

Re: How To: Import Using Files Names In Working Folder

by Calcite | Level 5 in SAS Programming
‎05-07-2022 12:20 PM
‎05-07-2022 12:20 PM
Sorry, I wasn't specific enough. I don't want to designate a library and hard code the actual file names. I want a procedure to be automated. When the program is executed, it would...   1. collect the filenames from a directory and put them into work.fakeset under the variable 'fname' (I've achieved this) 2. The program then brings in all the files from the directory using each 'fname' into one new data set called work.alldata   Does that make sense? ... View more

How To: Import Using Files Names In Working Folder

by Calcite | Level 5 in SAS Programming
‎05-07-2022 11:38 AM
‎05-07-2022 11:38 AM
Be kind. First time posting...   I used...   data fakeset; length fref $8 fname $200; did = filename(fref,'Fake\Path'); did = dopen(fref); do i = 1 to dnum(did); fname = dread(did,i); output; end; did = dclose(did); did = filename(fref); keep fname; run;   ...to generate 'fakeset' in my work folder with files from the Fake\Path directory.    All of the files in Fake\Path are in .sas7bdat format. 'fakeset' looks like this...   fname fake1.sas7bdat fake2.sas7bdat fake3.sas7bdat   How do I import each file in Fake\Path using the fname I generated in 'fakeset'? I'd like all of the files imported, then set into one new data set in my work folder.  I'm going to continue searching for a soltution as I know this has been done before (I'm sure). Thanks for the help   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-17-2022 01:48 AM
Quick links