PROC IMPORT from Web

[ets_kps]

Ok,

I need some help.  I need to import this dataset to a SAS dataset and I want to use as few a lines of code as possible. I would rather not write a data step to read it it.  Can i use PROC IMPORT?

"https://research.stlouisfed.org/econ/mccracken/fred-databases/monthly/current.csv"

Who can do it?

Thanks-Ken

[PGStats]

Use PROC HTTP:

/* Set destination fileref */

filename csvFile "&sasforum.\datasets\current.csv";

/* Get file */

proc http method="get" out=csvFile url="https://research.stlouisfed.org/econ/mccracken/fred-databases/monthly/current.csv";

run;

filename csvFile;

Works for me.

PG

[FriedEgg · Accepted solution]

filename csvFile url "https://research.stlouisfed.org/econ/mccracken/fred-databases/monthly/current.csv" termstr=crlf;

proc import datafile=csvFile out=foo replace dbms=csv; run;

[ets_kps]

thanks to both of you.  they both work great.  -Ken