09-01-2017 03:00 AM - edited 09-01-2017 03:07 AM
Can anyone help me.
I have two server or environment on which I am working. I have one dataset named smart.org on the second server. I need to transfer the dataset to the first server in the work library so that I can use it to join one of my output table. Take example for referece
sample1.app.server1.com port 8564
sample2.app.server2.com port 8562
Both have common username and id
I am currently logged in and working in the second server sample2.app.server2.com and want to read the dataset from the first server from the library smart and pull the dataset org and store it in the work library in the current environment
The path of smart library in the first server is sks/emea/data/sm. What code I need to write in the second server in EG to pull the data. I am aware of unix/putty transfer via scp command or winscp but I want to use proc download/upload or something in the code to do that. does anyone help me with code.. how can i log in and read data from another server.
I have already created output file named work.incentive in the first server whcih has fields like salesname, salesperson, salary. I want to join the field department from smart.org to the incentive output. I know about join part though
09-01-2017 03:21 AM
Do you have SAS/CONNECT installed and licensed on both servers? If you do then PROC DOWNLOAD or UPLOAD is a good option.
Also what operating systems do the two SAS servers run on? Are they the same or not? If they are not the same and you don't have SAS/CONNECT then another option is to use PROC CPORT to create a transport file, FTP it to the other server in BINARY mode, then CIMPORT it on the other server.
09-01-2017 03:27 AM
09-01-2017 04:18 AM
A lot of sites have a full separation between PROD and DEV/TEST environments. If so then the likely only way to move data from one environment to the other is via your local environment (your client).
If using SAS EG download the data to your PC/Laptop environment, connect to the other server, upload the data and then process the data in your target server environment.
If there is a connection between your two servers possible and you've got SAS/Connect then you can also directly create a remote sesstion on your other server and then transfer the data from this server to your calling environment.
09-07-2017 06:38 AM
You need SAS/Connect licensed. If you do then everything else here: https://support.sas.com/documentation/cdl/en/connref/69581/HTML/default/viewer.htm#titlepage.htm