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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.