topic Re: File was not found or could not be opened: enusa.loc.bfd in SAS Data Management

File was not found or could not be opened: enusa.loc.bfd

mprathap — Sat, 16 Feb 2019 02:09:30 GMT

I am trying to run the example given in the PROC DQMATCH documentation: https://go.documentation.sas.com/?docsetId=dqclref&docsetVersion=9.4&docsetTarget=n1wf1yuqd22slcn1lp4kbgem532z.htm&locale=en

But running into the following error:

1 %DQLOAD(DQLOCALE=(ENUSA DEDEU), DQSETUPLOC='/usr/local/SAS/qkb');
NOTE: DQLOAD macro beginning.
ERROR: [DQ Engine] File read error. File was not found or could not be opened: enusa.loc.bfd (status: 90BFF82A, rc: -404)
ERROR: [DQ Engine] File or directory not found: enusa.loc (status: 90BFF82A, rc: -404)
ERROR: DF_ERROR_FILE_NOT_FOUND
ERROR: Unable to load the ENUSA locale.
ERROR: Error in the FILENAME statement.
NOTE: DQLOAD macro ending.

I downloaded KQB 30 and installed it under /usr/local/SAS/qkb.

I cannot the files ensua.loc nor enusa.loc.bfd under the locations either.

Any help solving this problem?

Thanks!!

Re: File was not found or could not be opened: enusa.loc.bfd

Patrick — Sat, 16 Feb 2019 12:01:45 GMT

Is system option DQSETUPLOC pointing to the QKB root directory?

http://support.sas.com/documentation/cdl/en/dqclref/70016/HTML/default/viewer.htm#p05cvyz39h18njn1hmmklso5uv53.htm

Re: File was not found or could not be opened: enusa.loc.bfd

mprathap — Sun, 17 Feb 2019 19:06:58 GMT

Thanks Patrick.

I tried the following also.

options DQSETUPLOC = '/usr/local/SAS/qkb' DQLOCALE = (ENUSA);
**%DQLOAD(DQLOCALE=(ENUSA DEDEU), DQSETUPLOC='/usr/local/SAS');

And get the following message:

NOTE: Since no SAS Data Quality locales have been loaded, the locale(s) specified in the SAS option DQLOCALE will be loaded.
ERROR: [DQ Engine] File read error. File was not found or could not be opened: enusa.loc.bfd (status: 90BFF82A, rc: -404)
ERROR: [DQ Engine] File or directory not found: enusa.loc (status: 90BFF82A, rc: -404)
ERROR: Failed to generate matchcode.
ERROR: DF_ERROR_FILE_NOT_FOUND

Appears that the file ensue.loc.bfd needs to be there. I installed KQB 30, but this filed does not seem to be copied.

Re: File was not found or could not be opened: enusa.loc.bfd

mprathap — Sun, 17 Feb 2019 19:08:17 GMT

BTW I also tried options DQSETUPLOC = '/usr/local/SAS' (without the qkb directory) and the see same outcome.

Re: File was not found or could not be opened: enusa.loc.bfd

ShayneGrant — Mon, 18 Feb 2019 14:24:43 GMT

DQSETUPLOC needs to point the directory which contains the QKB contents, sometimes this is referred to at the QKB data directory. The directory that contains the QKB contents is the one that contains the following:

drwxr-xr-x. 2 sas sas 20480 Feb 12 13:19 chopinfo
-rw-r--r--. 1 sas sas 139 Feb 12 06:30 dfx.meta
drwxr-xr-x. 2 sas sas 20480 Feb 12 13:19 grammar
drwxr-xr-x. 2 sas sas 8192 Feb 12 13:20 locale
drwxr-xr-x. 2 sas sas 16384 Feb 12 13:20 phonetx
drwxr-xr-x. 2 sas sas 114688 Feb 12 13:20 regexlib
drwxr-xr-x. 2 sas sas 86016 Feb 12 13:22 scheme
drwxr-xr-x. 2 sas sas 32768 Feb 12 13:23 vocab

If you downloaded and installed the QKB on Unix/Linux into '/usr/local/SAS/qkb', it is likely that the QKB contents are in the subdirectory 'data/ci/30'. So you need to point DQSETUPLOC to '/usr/local/SAS/qkb/data/ci/30'. If this is not the location that contains the files/directories listed above, find the files/directories listed above and set DQSETUPLOC to that location.

Re: File was not found or could not be opened: enusa.loc.bfd

mprathap — Mon, 18 Feb 2019 18:28:11 GMT

That did the trick Shayne. Much appreciated.