BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
R_Chung
Quartz | Level 8

Hello, everyone. I am connecting to a server and use this unix server to connect to another unix server.

 

code as below:

 

%let sshhost=localhost 7551;
options set=TCPTN3270 0;
filename rlink 'C:\SAS_TUNNEL\tcpunix.scr';
signon sshhost;

libname rwork slibref=work server=sshhost;

/* remote signon SAS DI Studio in a from BASE SAS in b*/

rsubmit sshhost;
  %let dis=(server name of a) (portNo of a);
  options comamid=tcp remote=dis; 
  signon user=_prompt_ password=_prompt_;
endrsubmit;

However, error message is occured.

2017-08-03_122930.jpg

 

Any suggestion?

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

Trusted connections on Unix can be provided by using IWA on Unix which would involve using Kerberos. If you are not an expert in this technology then it would pay to get expert help on this as it is tricky and time consuming to set up. Check this link for more details:

 

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

 

Maybe a more low-tech solution might be possible, perhaps by prompting for the user name and password on your PC via your SIGNON script and then passing these through to your first Unix server as macro variables so they can be added to your second SIGNON.  

View solution in original post

6 REPLIES 6
SASKiwi
PROC Star

Using _prompt_ in an RSUBMIT block isn't going to work as the remote session is trying to pop up a prompt window for you to enter the user name and password but can't because there is no terminal session to display it on.

 

You will need to code the actual user name and password in the remote session SIGNON statement for this to work.

R_Chung
Quartz | Level 8
Is there any other methods to do it without hard code?

Also, how to make it in trusted connection, so that no need enter username or password.
SASKiwi
PROC Star

Trusted connections on Unix can be provided by using IWA on Unix which would involve using Kerberos. If you are not an expert in this technology then it would pay to get expert help on this as it is tricky and time consuming to set up. Check this link for more details:

 

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

 

Maybe a more low-tech solution might be possible, perhaps by prompting for the user name and password on your PC via your SIGNON script and then passing these through to your first Unix server as macro variables so they can be added to your second SIGNON.  

R_Chung
Quartz | Level 8
or how to prompt for user to input
as I have tried in enterprise guide: properties --> prompt
however, when i export to run in unix, nothing prompt
R_Chung
Quartz | Level 8
@SASKiwi I cannot find any sas code related keyword "sas code prompt for user input" in google

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 2885 views
  • 0 likes
  • 2 in conversation