I am trying to run the function dqpattern in SAS EG and I need to load the QKB using %dqload. The problem I am having is that I am running my SAS program on an appgrid server and my QKB is local in the windows "C:" drive. It doesn't seem to be able to find it and I have double and triple checked my file path to the root of the QKB. Is this because I am running on the APPGRID? I am running SAS 9.4 and here is my code:
%dqload(dqlocale=(enusa),dqsetuploc='C:\programdata\sas\sasqualityknowledgebase\ci\25',dqinfo=1);
data test;
set sashelp.cars;
testvar=dqpattern(make,'Character',ENUSA);
run;
What are my options to be able to utilize the grid server processing power and the dq functions that DMS provides?
The server can't see your local C: drive. Move the files to a location where the server has access to, and then use the pathname that the server has to that location.
The server can't see your local C: drive. Move the files to a location where the server has access to, and then use the pathname that the server has to that location.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.