How to execute XCMD using SAS Enterprise Guide?

[Akshay1002]

Hello,

I have a dataset with 100 records which are basically the LAN_IDs of users. I want to know what all AD groups they're in. I basically run, id lan_id from the Linux command line. I hate doing that for all the 100 users.

How do I succeed using XCMD programmatically from Enterprise Guide?

Please suggest!

TIA,
Akshay.

[andreas_lds]

The option xcmd must be enabled on the workspace-server you are using. If is is enabled, you can use filename with pipe to execute a command an process the result using a data-step.

[Akshay1002]

Yes, I've XCMD enabled and able to successfully execute the below followed by a data step.
filename dirlist pipe "id lan_id";

How to do it for 100 users?
Can you please help me with the code?

[Kurt_Bremser]

Do you have a dataset with the usernames?

[Akshay1002]

Yes, Sir.
Basically importing a spreadsheet with the usernames.

[Kurt_Bremser · Accepted solution]

Then you can use the "magic dynamic pipe":

data usernames;
input name $8.;
datalines;
lan_id
;

data userdata;
set usernames;
length pipevar $20;
pipevar = "id " !! name;
infile dummy pipe filevar=pipevar end=done;
do until (done);
  input uidstring :$20. gid_string :$20. group_string :$500.;
  output;
end;
run;

This algorithm is part of a presentation planned for SASGF 2021 in Las Vegas.

[Akshay1002]

You're A W E S O M E!

It worked. Thanks a lot.

[SASKiwi]

The XCMD option can only be set as an option when you start SAS so it can't be done in EG. Your SAS Administrator can set it via SAS Management Console or a SAS config file.