DQ functions inside PROC DS2

[TzufRaifMia]

Hey all!

I'm interesting in using DQ Functions Within DS2 block (It is meant to be as part of CID process).

It seems that it is indeed possible to use these functions in DS2 block (directly or via FedSQL&QKB) but I am failed to succeed.

Is one of you have already done it? I'd love to see a little example!

Thanks in Advanced,

Tzuf

[JosvanderVelden]

Example:

%DQLOAD(DQLOCALE=(ENUSA), DQSETUPLOC='/opt/sas/spre/home/share/refdata/qkb/ci/31
');

proc ds2 libs=work;
  data _null_;
    /* init() - system method */
    method init();
      declare varchar(255) name; /* method (local) scope */
      name = 'Doctor Sam Spade’;
      stdName=dqStandardize(name, 'Name');
      put stdName;
    end;
  enddata;
  run;
quit;

Source: Paper SAS4079-2020 - What's New in SAS Data Management link

[TzufRaifMia]

Thanks!