I executed the following SAS program (using The SASEFRED Interface Engine) to extract the data from FRED (St Louis Fed website)
options validvarname=any;
title 'Retrieve Data for the Exports of Goods and Services';
libname _all_ clear; libname fred sasefred "%sysget(FRED)"
OUTXML=exportgs
XMLMAP="%sysget(FRED)exportgs.map"
APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
IDLIST='bopxgsa';
data export_gsa;
set fred.exportgs ;
run;
proc contents data=export_gsa;
run; proc print data=export_gsa(obs=15); run
then I have the following error messages:
Error: Invalid physical name library name FRED
Error: Error in the LIBNAME statement.
Error: Libref FRED is not assigned.
How can I fix these problems?
Do you have your own FRED API key? are you sure it was set up correctly?
yes, I have my own FRED API key. I just did not put it there.
In addition to @ballardw'd comment, check that the environment variable FRED is defined by adding:
%put FRED = &FRED;
to your program. By the look of it FRED is a directory where your XML mapping file is stored.
Where do i insert this program? Can you show me here?
At the end is fine.
Did you ever get this working? I'm facing a similar problem with sasefred on SAS Studio.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.