SASEFRED Interface Engine with SAS studio

[ahk1225]

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?

[ballardw]

Do you have your own FRED API key? are you sure it was set up correctly?

[ahk1225]

yes, I have my own FRED API key. I just did not put it there.

[SASKiwi]

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.

[ahk1225]

Where do i insert this program? Can you show me here?

[SASKiwi]

At the end is fine.

[_SUPERQ__]

Did you ever get this working?  I'm facing a similar problem with sasefred on SAS Studio.