BookmarkSubscribeRSS Feed
FrankE
Fluorite | Level 6
Hi guys, I wrote a stored process which takes a dynamic paramter, account number. Each night in our batch process I create a SAS dataset which conatins a row for each distinct account and the associated name and I then use this table to build the dynamic prompt values. (there's about 15k rows).

My issue is that when I try to load this stored process in the stored process web app performance is pretty slow when loading this dynamic prompt. Is there anything I can do to speed things up? I saw some mention of a limit I can set on the number of rows loaded in the prompt but I can't seem to find where to set this....

Thanks!
2 REPLIES 2
SAS_Doctor
Calcite | Level 5
Do the users need to see all 15K of data? I would think you need to limit the amount of data that the prompt shows. If it is, it sounds like the same issue I am having. Maybe you could create a view of the table/file and then use the view as the source for the prompt just showing the subset?
FrankE
Fluorite | Level 6
The users need to be able to search through all 15k records but I don't want them loading as part of the page. I assumed that SAS would be smart enough to make these prompts work with AJAX so they dynamically load the records as the user types in the box. (like Google) (see this paper: http://support.sas.com/resources/papers/proceedings10/014-2010.pdf)

I've done everything I can think of to speed performance.. I cut the dataset down to only the fields required by the promt and indexed it.. still not very good performance. I hope SAS has some sort of solution for this as its a real deal breaker for being able to use their products over a home-grown solution.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 794 views
  • 0 likes
  • 2 in conversation