I wnat to create report which will following functionality :-
if user A has logged in the all current filter should show A in value. Currenlt i am taking filter value for one table and it is showing all distance vales along with A.
Is this possible in Stored process? How can i acheive this ??
Look at the reserved macro variables &_metauser, &_rmtuser and &_username to identify the user that requests the stored process.
And please do some proofreading of your posts before hitting the submit button. Your post is very hard to read, especially for people who are not native English speakers themselves.
Step one: verify that _metauser or another of the named macro variables contains the name you want when a STP executes (write a simple STP that just displays the macro variables)
Step two: verify that the username so derived matches the username in the datasets you use for building the filter
Step three: from what I know, one can't define a where condition for dynamic data in prompts. So you might have to do two STPs in succession:
- STP1 generates a HTML form with the subset of values that you want
- the form then calls (on submit) STP2 (which is your current STP) with the values from the HTML form in the URL
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.
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.