BookmarkSubscribeRSS Feed
Rohan
Calcite | Level 5

Hello Friends,

I have a issue. I want to print the userid while I'm updating a dataset in column "updated_by". I'm not getting the function to get it.

Could you please help me out?

Thanks !

Rohan.

4 REPLIES 4
Ksharp
Super User

I do not know the following is whether you want,

These information has been stored in system automatic macro variable.

%put &sysuserid &sysjobid;

Ksharp

Rohan
Calcite | Level 5

Hello Ksharp,

Thanks for the reply.

if I use "&sysuserid" , it would create a column in dataset.

but I want to pass the value of it to another variable.

data ABC;

id = &sysuserid;

run;

I want that dataset ABC only has one column named ID and it contains the value of sysuerid. Could u please help me out ?

Thanks,

Ksharp
Super User

I don't understand what you mean exactly.

You can store its value in a dataset .Like:

data ABC;

id = "&sysuserid";

run;

Ksharp

Haikuo_old
Fluorite | Level 6

Or:

data ABC;

id=symget('sysuserid');

run;

Haikuo

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 4 replies
  • 2567 views
  • 0 likes
  • 3 in conversation