topic import data from url in SAS STUDIO in SAS on demand in SAS Programming

import data from url in SAS STUDIO in SAS on demand

KOUAME — Fri, 23 Apr 2021 21:28:21 GMT

I use SAS studio on SAS on demand and trying to get this data located in https://raw.githubusercontent.com/fivethirtyeight/data/master/nba-elo/nbaallelo.csv but not work, need help, I work in Windows system

/* use proc import  to get data from url*/
filename file url "https://raw.githubusercontent.com/fivethirtyeight/data/master/nba-elo/nbaallelo.csv" termstr=crlf;
proc import datafile= file
out=urldata
replace
dbms=csv;
run;

I got this message in the log:

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
Unable to sample external file, no data in first 5 records.
ERROR: Import unsuccessful. See SAS Log for details.

Re: import data from url in SAS STUDIO in SAS on demand

ballardw — Fri, 23 Apr 2021 21:23:20 GMT

Try TERMSTR=CR

At least that worked for me.

That indicates the likely creator of the file uses a MAC, not Windows (CRLF) or Linux/Unix (LF)

Re: import data from url in SAS STUDIO in SAS on demand

Reeza — Fri, 23 Apr 2021 21:29:22 GMT

Make sure to test your links and such when you post them and to use the code/log block for your log. I'll clean up this post including the extra code box.

FYI - On Demand works in the cloud, which means anything created is on a unix system.

Re: import data from url in SAS STUDIO in SAS on demand

KOUAME — Fri, 23 Apr 2021 21:31:24 GMT

thanks so much , it works!