Sas viya 4 default snippet DQLOAD macro error

devi001 — Wed, 28 Aug 2024 12:27:30 GMT

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!

Re: Sas viya 4 default snippet DQLOAD macro error

SASKiwi — Thu, 29 Aug 2024 01:16:57 GMT

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.

topic Sas viya 4 default snippet DQLOAD macro error in SAS Viya

Sas viya 4 default snippet DQLOAD macro error

Re: Sas viya 4 default snippet DQLOAD macro error