topic LIBNAME error trapping? in SAS Procedures

LIBNAME error trapping?

kjohnsonm — Mon, 07 Dec 2015 18:51:49 GMT

Hello all,

I am working with a lot of metadata, opening thousands of different db files: access, sas, dbf, and more. I wanted to add a feature that traps my errors not in the log file but in a new data set or on the master list of my list of files indicateing I had an error opening/connecting the LIBNAME. Does anyone have any starter code on this? Any help would be greatly apresheated for a new SAS guy (April/May2015). TIA. -KJ

ERROR: Connect: Could not find file 'D:\MyPath\MyMdb.MDB'.
ERROR: Error in the LIBNAME statement.

Re: LIBNAME error trapping?

SASKiwi — Mon, 07 Dec 2015 19:20:47 GMT

I suggest you check out the LIBNAME function which will allow you to trap return codes and error messages:

http://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#p1bq8nyxm7y1ygn1i4vyf82z68ls.htm

Re: LIBNAME error trapping?

kjohnsonm — Mon, 07 Dec 2015 21:01:27 GMT

Is this remotly close?

for my program:

LIBNAME MYMDB ACCESS PATH="D:\MyDir\MyFile.MDB" access=readonly;

works and I can get my metadata.

when I try to addapt it to this web page sample:

%let mylib=c:\projects\May2015;
%if %sysfunc(libname(new,&mylib)) %then
%put %sysfunc(sysmsg());

I come up with this:

%let myfile='D:\MyDir\MyFile.MDB';
%if %sysfunc(libname('MYMDB', 'ACCESS', &myfile, 'readonly')) %then
%put %sysfunc(sysmsg());

and get this error:

ERROR: The %IF statement is not valid in open code.

I am not sure what to try, I have tryied adding and removing quotes on the arguments.

Re: LIBNAME error trapping?

SASKiwi — Mon, 07 Dec 2015 22:25:31 GMT

To use a %IF statement it must be inside a macro. Try this:

%macro Assign_Libname (MyFile = );

%if %sysfunc(libname('MYMDB', 'ACCESS', "&myfile", 'readonly')) %then
%put %sysfunc(sysmsg());

%mend Assign_Libname;

%Assign_Libname (MyFile = %str(D:\MyDir\MyFile.MDB));

Re: LIBNAME error trapping?

Tom — Mon, 07 Dec 2015 22:44:53 GMT

Do it in a data step instead of using macro code. Especially if you want to create metadata.

data data_sources;
  infile cards truncover;
  length engine libref $8 rc 8 path msg $200 ;
  input engine $ path $200. ;
  libref='L'||put(_n_,Z7.);
  rc=libname(libref,path,engine,'access=readonly');
  if rc then msg=sysmsg();
  else msg='SUCCESS';
  output;
  rc=libname(libref,' ');
cards;
base c:\downloads
base c:\notfound
xlsx c:\downloads\DSPI.xlsx
;;;;

results:

287   data _null_; set ; put (_all_) (=/); run;

engine=base
libref=L0000001
rc=0
path=c:\downloads
msg=SUCCESS

engine=base
libref=L0000002
rc=-70008
path=c:\notfound
msg=NOTE: Library L0000002 does not exist.

engine=xlsx
libref=L0000003
rc=0
path=c:\downloads\DSPI.xlsx
msg=SUCCESS

NOTE: There were 3 observations read from the data set WORK.DATA_SOURCES.