Sas viya 4 default snippet DQLOAD macro error

[devi001]

Hello,

We are trying to use the DQLOAD macro in the default 'Identify Gender' snippet within SAS Viya. However we get the below error. Is this because DQLOAD requires additional parameters as input such as the QKB location? In this case how do we identify the QKB location in our SAS Viya Environment?

Code:

%dqload(dqlocale=(ENUSA));

Data _null_;

Length name$100;

Length gender $20;

Name='Mrs. Sallie Mae Pavlik'

Gender=dqgender(name,'Name','ENUSA');

PUT GENDER;

run;

Log:

NOTE: DQLOAD macro beginning

WORK    "SASGOPT

ERROR: ERROR in the FILENAME statement

NOTE: DQLOAD macro ending

Thanks in advance!

[SASKiwi]

Typically you use the DQSETUPLOC parameter to specify the file location in the call to DQLOAD like so:

%DQLOAD(DQLOCALE=(ENUSA), DQSETUPLOC='/MyFolder/SASQualityKnowledgeBase/CI/CI30_qkb1');

Talk to your SAS administrator if you don't know the QKB location.