topic Re: SAS VA Stored Process in SAS Visual Analytics

SAS VA Stored Process

Ramakanthkrovi — Mon, 05 Nov 2018 04:31:25 GMT

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.

Re: SAS VA Stored Process

manishiiita — Mon, 05 Nov 2018 20:00:29 GMT

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.

Re: SAS VA Stored Process

Ramakanthkrovi — Tue, 06 Nov 2018 23:18:32 GMT

@manishiiita

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.