topic Re: Credentials for infile in sas 7.1 in SAS Enterprise Guide

Credentials for infile in sas 7.1

Twinklex — Thu, 24 Jun 2021 02:47:40 GMT

Hello,
I am using infile statement to trigger a script in Unix environment. Below is the code that I am using

data _null_;
infile "/unixlocation/filename.ksh" pipe;
input;
put _infile_;
run;

But to trigger the script (.ksh) file I need to use different credentials other than the ones used by my sas profile.
Can someone suggest me how to pass credentials to execute/run the script from Sas.
Any help would be appreciated. Thanks in advance.

I have already given a try using filename
But did not work.

Re: Credentials for infile in sas 7.1

Kurt_Bremser — Thu, 24 Jun 2021 04:46:27 GMT

If you need to run a command from another user-id, have your UNIX admin enable this in sudo.

sudo can be set to allow you to run a certain command with a certain user without supplying credentials.

Re: Credentials for infile in sas 7.1

Twinklex — Thu, 24 Jun 2021 07:02:54 GMT

Hello @Kurt_Bremser

That would be fine, but is there any possibility that I could assign the credentials from sas code. That helps very much.

Re: Credentials for infile in sas 7.1

Kurt_Bremser — Thu, 24 Jun 2021 07:34:07 GMT

No. Even if you could manage to do it (and there are ways to do that), any competent system administrator will object to it, for good reasons. One simply does not put passwords on commandlines, as these are open to all users on the same system.

Maxim 14: Use the Right Tool. The proper tool for what you want to do is sudo, so use it.

Re: Credentials for infile in sas 7.1

Twinklex — Thu, 24 Jun 2021 08:41:52 GMT

Thanks

Re: Credentials for infile in sas 7.1

jimbarbour — Thu, 24 Jun 2021 15:01:09 GMT

How would it be done from the command line if you needed different credentials? However it is done from the command line is generally how it should be done in a FILENAME PIPE construct.

Jim