topic Re: PROC IMPORT from Web in SAS Procedures

PROC IMPORT from Web

ets_kps — Mon, 24 Aug 2015 21:29:39 GMT

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

Re: PROC IMPORT from Web

PGStats — Mon, 24 Aug 2015 21:48:00 GMT

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.

Re: PROC IMPORT from Web

FriedEgg — Mon, 24 Aug 2015 22:37:45 GMT

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;

Re: PROC IMPORT from Web

ets_kps — Tue, 25 Aug 2015 19:37:35 GMT

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