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
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
Thanks!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.