topic Re: How to execute XCMD using SAS Enterprise Guide? in SAS Programming

How to execute XCMD using SAS Enterprise Guide?

Akshay1002 — Thu, 23 Jul 2020 06:17:18 GMT

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.

Re: How to execute XCMD using SAS Enterprise Guide?

andreas_lds — Thu, 23 Jul 2020 07:42:49 GMT

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.

Re: How to execute XCMD using SAS Enterprise Guide?

SASKiwi — Thu, 23 Jul 2020 08:22:30 GMT

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.

Re: How to execute XCMD using SAS Enterprise Guide?

Akshay1002 — Thu, 23 Jul 2020 08:31:01 GMT

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?

Re: How to execute XCMD using SAS Enterprise Guide?

Kurt_Bremser — Thu, 23 Jul 2020 08:36:03 GMT

Do you have a dataset with the usernames?

Re: How to execute XCMD using SAS Enterprise Guide?

Akshay1002 — Thu, 23 Jul 2020 08:57:10 GMT

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

Re: How to execute XCMD using SAS Enterprise Guide?

Kurt_Bremser — Thu, 23 Jul 2020 09:22:54 GMT

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.

Re: How to execute XCMD using SAS Enterprise Guide?

Akshay1002 — Fri, 24 Jul 2020 04:32:09 GMT

You're A W E S O M E!

It worked. Thanks a lot.