BookmarkSubscribeRSS Feed
Obsidian | Level 7

Hi Team,

Is there a way to display a user selected date (by a prompt which is not in the dataset) from a stored process in Enterprise Guide in the report using a dynamic text or any other way?


The photos are pasted below to help you understand the situation better. Hope it helps. Thanks.


Example: If a user selects "Nov 05" from the list, I want the date to be passed into the report and displayed around the yellow highlighted area.






Quartz | Level 8

I believe, you are working on SAS Stored Process reports not on VA (Visual Analytics).


When we create any dynamic inputs in Stored processes it will be stored first in a temporary variable. Try to look at stored process source code, there you can find the name of variable. You can put data in this variable into your report (SAS %put statement).


Please let me know if I have misunderstood your question or any further queries on this.

Obsidian | Level 7


I had to create a stored process in SAS Enterprise guide but the user selects the prompts in SAS Visual Analytics which then gets executed in the backend in SAS EG and the dataset which is a source for the report gets refreshed and the user can see updated data.


Because in SAS VA 7.4 we can only execute the stored process in an external tab, the dataset refresh is inevitable. The user prompt selection is what that needs to be used in the report as a dynamic text. Hope it cleared the original post.



Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.


Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 


Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2 in conversation