BookmarkSubscribeRSS Feed
deleted_user
Not applicable
While creating a stored process in my dashboard I came across a requirement of storing the BI portal logon, which is actually used as the physical folder name where the report has to be stored.

Is there any function or automatic macro that could help me to get the user id who is currently running the process?

When I tried to use %sysuserid I got "sassrv" in the report, even when I logged into portlet with my windows authenticated user ID

Then I found that "sassrv" is the user id that is used by stored process server.

Can anyone suggest me how to get the user id who logged into BI portlet and use it in stored process?
2 REPLIES 2

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
  • 542 views
  • 0 likes
  • 2 in conversation