I'm using SAS EG, 7.15 HF9 (7.100.5.6226) (64-bit) powered by SAS 9.4. If I paste this link into my browser, a .csv file is automatically downloaded to my PC: https://docs.google.com/spreadsheets/d/1xFgCLi7cr-_Z_hbhksYIv5jABk6EaBcPNWRlVzH5kxY/export?format=cs.... This is a test document but the real data I need to download through SAS has sensitive data so I can't share that here.
The code below works with the test document because there are no restrictions, but when I run the same code with the document that requires me to be signed in, I get HTML output instead of the csv data (copied below).
Is there a way I can authenticate my Google credentials through SAS?
filename in url "https://docs.google.com/spreadsheets/d/1xFgCLi7cr-_Z_hbhksYIv5jABk6EaBcPNWRlVzH5kxY/export?format=csv";
filename out "%sysfunc(pathname(work))\data.csv";
data _null_;
infile in;
input;
if _n_> 1;
file out;
put _infile_;
run;
PROC IMPORT OUT= WORK.data
DATAFILE= "%sysfunc(pathname(work))\data.csv"
DBMS=CSV REPLACE;
RUN;
.csv snippet from SAS in HTML
| <!DOCTYPE html> |
| <html lang="en"> |
| <head> |
| <meta charset="utf-8"> |
| <meta content="width=300 |
| <meta name="description" content="Create a new spreadsheet and edit with others at the same time -- from your computer |
| <meta name="google-site-verification" content="LrdTUW9psUAMbh4Ia074-BPEVmcpBxF6Gwf0MSgQXZs"> |
| <title>Google Sheets - create and edit spreadsheets online |
| <style> |
| @font-face { |
| font-family: 'Open Sans'; |
| font-style: normal; |
| font-weight: 300; |
| src: url(//fonts.gstatic.com/s/opensans/v15/mem5YaGs126MiZpBA-UN_r8OUuhs.ttf) format('truetype'); |
| } |
