I need to use SFTP through a proxy server I have found following example: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000178980.htm   Example 11: Using a Proxy Server This example uses a proxy server with the FTP access method. The user ID and password are sent via the proxy server. filename test ftp ' ' ls    host='proxy.server.xxx.com'    user='userid@ftpservername'    pass='xxxxxx'    cd='pubsdir/';   data _null_;    infile test truncover;    input a $256.;    put a=; run;   I have following scrip, which works fine but does not use a proxy server:   filename TEST SFTP '/MyFolder/' DIR FILEEXT LSA HOST = 'ftpservername' USER = 'Myuser' WAIT_MILLISECONDS = 5000 LRECL = 2000 OPTIONS = '-P 2222 -i \\myserver\PrivateKey.ppk -pw "xxxxx"' DEBUG ; data _null_; infile TEST; input; FILE 'C:\Myfile.txt' ; put _infile_; run; I need to use a PROXY server with port number 8081. I thought that I can change the code as follow but cannot figure out where to put the port number for the proxy server.   filename TEST SFTP '/MyFolder/' DIR FILEEXT LSA HOST = 'proxy.server.xxx.com' USER = 'Myuser@ftpservername' WAIT_MILLISECONDS = 5000 LRECL = 2000 OPTIONS = '-P 2222 -i \\myserver\PrivateKey.ppk -pw "xxxxx"' DEBUG ; data _null_; infile TEST; input; FILE 'C:\Myfile.txt' ; put _infile_; run; Is this possible?   ... View more

Hi, I thought merge of data by a key and with an “if” limiting the data to one of the merge tables was exactly like a left join in proc sql. But when both tables have doublets (or repeats of BY values) MERGE and LEFT JOIN will not give the same result.   How can I change the SQL statement to get the same result as merge (I’m trying to convert SAS code to SQL).   Here is my simplified example: (In this example merge gives 4 observation and left join gives 6 observations - I need the 4 observation but with sql statment - is this possible?)   DATA one; INPUT x y $1.; DATALINES; 1 A 1 B 2 C 3 D ; run; DATA two; INPUT x z $2.; DATALINES; 1 Z1 1 Z2 2 Z 3 Z ; run; proc sort data=one; by x; run; proc sort data=two; by x; run;   data mergedata; merge one(in=i) two; by x; if i; run;   proc sql; create table leftjoindata as select one.*             ,two.z from one left join two on one.x = two.x ; quit;   ... View more