Please help me to retrieve password from unix command line using SAS

Teju2 — Wed, 21 Jun 2023 10:18:51 GMT

I can able to retrieve password from using below command from unix . I am trying to achieve the same using SAS
/* Try 1*/
systask command '/opt/software/dbclients/CyberArk/cark_getpwd.ksh -a XXX -s XXX -o XXX'
status=passwd;
%put &passwd. &sysrc.;
result :
&passwd. blank &sysrc. is 0
/* Try 2 */

filename tmp pipe '/opt/software/dbclients/CyberArk/cark_getpwd.ksh -a XXX -s XXX -o XXX';
data want;
length return_string $2000;
infile tmp;
input return_string $;
put return_string=;
run;

result : return_string=/opt/software/dbclients/CyberArk/cark_getpwd.ksh[23]: /opt/CARKaim/sdk/clipasswordsdk not found

/* try 3*/

%macro pwdls;

%sysexec %str(/opt/software/dbclients/CyberArk/cark_getpwd.ksh -a XXX -s XXX -o XXX);

%mend pwdls;
%pwdls;
/* try 4*/
%let a=%sysexec %str(/opt/software/dbclients/CyberArk/cark_getpwd.ksh -a XXX -s XXX -o XXX);
%put &a.;

result: ERROR: Macro keyword SYSEXEC appears as text.

Re: Please help me to retrieve password from unix command line using SAS

Kurt_Bremser — Wed, 21 Jun 2023 11:39:24 GMT

Try 2 is the best method. Expand it like this:

filename tmp pipe '/opt/software/dbclients/CyberArk/cark_getpwd.ksh -a XXX -s XXX -o XXX 2>&1';

data want;
length return_string $2000;
infile tmp;
input return_string $;
put return_string=;
run;

The 2>&1 redirects stderr to stdout, so that all messages will appear in the SAS log.

But this:

/opt/software/dbclients/CyberArk/cark_getpwd.ksh[23]: /opt/CARKaim/sdk/clipasswordsdk not found

indicates that there is a problem locating a library or module needed for the command to work. Look at line 23 of the shell script.

Make sure that your direct and SAS attempt to run the command are executed in the same environment:

same server
same user
same settings in environment variables (e.g. PATH, LIBPATH)

topic Re: Please help me to retrieve password from unix command line using SAS in New SAS User

Please help me to retrieve password from unix command line using SAS

Re: Please help me to retrieve password from unix command line using SAS