I have following code:
data _null_;
x = dqmatch('Indrajeet Patil','Name',80,'ENUSA');
put x=;
run;
This is used to generate match code, executing stored process each time there is a call from source system.
This code takes 2-3 seconds to complete first time you execute it in a session.
Later executions on the same sessions take milliseconds.
Response should be much faster as this is used in real-time screening.
How to improve this code for first time execution also the later executions?
in the Business Intelligence group of communities, there is a SAS Stored Processes forum. Perhaps you can get a more appropriate readership there.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.