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
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;
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
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;
thanks to both of you. they both work great. -Ken
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.