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-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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