topic Re: SFTP ERROR: Connection refused, check key authentication and sshd server status. in SAS Data Management

SFTP ERROR: Connection refused, check key authentication and sshd server status.

duanzongran — Tue, 12 Mar 2019 03:46:10 GMT

HI! friends!

now,my sas is installed on a win7 OS PC,and i want to connect to a SFTP(linux) to read a csv_file(import a csv_file to my work library for data analysis);

i can read the csv_file by using putty, comand as follows:
GET /home/mypath/csv_file.csv

in BASE SAS, i tried to import the csv_file to my work library ,the code is just like this :

filename lin sftp '/home/fengxian/gpa.csv' host="10.50.100.34" user="fengxian" ;

data ll;

infile lin delimiter=',',firstobs=2 ;

input nobs gpa hsm hss hse satm satv gender;

run;

but,the log is

ERROR: Connection refused, check key authentication and sshd server status.

any suggestion is welcom!

thanks in advance!

Re: SFTP ERROR: Connection refused, check key authentication and sshd server status.

Kurt_Bremser — Tue, 12 Mar 2019 05:46:35 GMT

You need to set up public/private key authentication for that connection in putty. putty must not ask for a password when you test it from the commandline.

Re: SFTP ERROR: Connection refused, check key authentication and sshd server status.

duanzongran — Tue, 20 Aug 2019 08:27:57 GMT

Thank you so much Mr.Kurt Bremser !