topic Re: SASEFRED Interface Engine with SAS studio in SAS Studio

SASEFRED Interface Engine with SAS studio

ahk1225 — Fri, 05 Aug 2016 01:57:24 GMT

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 — Thu, 04 Aug 2016 21:31:56 GMT

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

SASKiwi — Fri, 05 Aug 2016 00:15:17 GMT

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 — Fri, 05 Aug 2016 01:45:57 GMT

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

ahk1225 — Fri, 05 Aug 2016 01:55:20 GMT

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

SASKiwi — Fri, 05 Aug 2016 04:11:56 GMT

At the end is fine.

_SUPERQ__ — Wed, 21 Feb 2018 16:44:19 GMT

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