topic DQ functions inside PROC DS2 in SAS Procedures

DQ functions inside PROC DS2

TzufRaifMia — Sun, 05 Nov 2023 14:53:05 GMT

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

Re: DQ functions inside PROC DS2

JosvanderVelden — Mon, 06 Nov 2023 14:50:41 GMT

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

Re: DQ functions inside PROC DS2

TzufRaifMia — Sun, 12 Nov 2023 09:31:22 GMT

Thanks!