07-21-2023
Mada1
Fluorite | Level 6
Member since
06-03-2021
- 4 Posts
- 0 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by Mada1
Subject Views Posted 1642 06-16-2021 11:48 AM 1654 06-16-2021 11:13 AM 1700 06-16-2021 06:30 AM 1027 06-03-2021 11:58 AM -
Activity Feed for Mada1
- Posted Re: SAS 9.4 and Stunnel on Developers. 06-16-2021 11:48 AM
- Posted Re: SAS 9.4 and Stunnel on Developers. 06-16-2021 11:13 AM
- Posted SAS 9.4 and Stunnel on Developers. 06-16-2021 06:30 AM
- Got a Like for Load SAS data set from a Base engine library (library.tableName) into a caslib using Python SWAT. 06-03-2021 11:59 AM
- Posted Load SAS data set from a Base engine library (library.tableName) into a caslib using Python SWAT on Developers. 06-03-2021 11:58 AM
-
My Liked Posts
Subject Likes Posted 1 06-03-2021 11:58 AM
06-16-2021
11:48 AM
Hi, Using filename ftp I have tried the following. The intention was to copy the dataset stpsale between the two servers. filename indir ftp '/home/users/myfolder/Mada' DIR host="server_name" user="user" pass='password'; filename outdir ftp ' ' DIR FILEEXT host="1.11.111.1" port=2222 user='user2' pass='password2'; data _null_; infile indir(stpsale) truncover; input; file outdir(stpsale); put _infile_; run; The code above returns error on both indir and outdir. The test using filename socket below show that the port 2222 is already used (because the Stunnel is running on localhost on port 2222) but I didn't know how to continue from this point filename local socket ':2222' server; data tcpip; infile local eov=v; input x $10; if v=1 then do; put 'new connection received'; end; output; run; At the moment call system below returns the error "ERROR: Shell escape is not valid in this SAS session." (but I'm running on SAS EG and I think changes are required in SAS MC to solve this error) data _null_; call system('dir /w'); run; Thank you for your help. Regards, Mada
... View more
06-16-2021
11:13 AM
Hi, Thank you so much for your answer. I know I can use the x cmd which would probably work ok in the dev environment but in prod environment x cmd are disabled. This is the reason why I tried filename ftp and socket. Thank you, Mada1
... View more
06-16-2021
06:30 AM
Hello, System: 9.4 on Windows Has anybody managed to use SAS to work with Stunnel? I am trying to "convert" the sh script below to run from SAS so that I can transfer files using the stunnel. The stunnel is already set up and the sh script below is working. user@server filedump$ sshpass -f "/folder/subfolder/passwordfile" scp -P 2222 -oKexAlgorithms=+diffie-hellman-group1-sha1 -oMACs=+hmac-sha1 -c aes128-cbc -p user@localhost:/folder/subfolder1/file.txt /home/users/folder/subfolder/ I would like to confirm that no private keys have been used. I have tried to use SAS filename ftp but it failed. I don't know if and where we can use +diffie-hellman-group1-sha1 and +hmac-sha1 I have also tried to configure SAS filename socket but so far is not working. Thank you for your help. Regards, Madalin
... View more
06-03-2021
11:58 AM
1 Like
Hello, Current configuration: SAS Viya version: 3.5 SAS Viya is installed on Linux Python version 3.7.9 Python SWAT version 1.9.0 Supposing that we have two libraries defined in SAS VIYA, one CAS and one not CAS. Would anybody know if is possible to upload a table from the non CAS library to the CAS library by using Python SWAT? The equivalent process in SAS Studio would be: proc casutil; load data=NON_CAS_LIB.tablename outcaslib="CAS_LIB" casout="targetTableName"; run; Can this be done in SWAT? After creating the SWAT connection I have tried using load_path like below but it didn't work. test=conn.load_path('NON_CAS_LIB/Table_A', caslib='CAS_LIB') Thank you, Madalin
... View more