import data from url in SAS STUDIO in SAS on demand

[KOUAME]

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.

[ballardw · Accepted solution]

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)

[KOUAME]

thanks so much , it works!

[Reeza]

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.