topic Re: Is there way in SAS to copy file from one server to another server without supplying the passwor in SAS Programming

Is there way in SAS to copy file from one server to another server without supplying the password

soujanyak — Thu, 07 Apr 2022 15:52:57 GMT

Is there way available in SAS to copy file from one server to another server without supplying the p

soujanyak — Thu, 07 Apr 2022 15:51:12 GMT

Re: Is there way in SAS to copy file from one server to another server without supplying the passwor

ballardw — Thu, 07 Apr 2022 15:58:54 GMT

What type of file?

Password where? To access the file, the server, the transfer program? Lots of places a password may be required.

Do the two servers share anything like common network disk access?

Re: Is there way in SAS to copy file from one server to another server without supplying the passwor

soujanyak — Thu, 07 Apr 2022 16:34:26 GMT

it is a sasdata sets, where I need to put my user id and password for server to move files

Re: Is there way in SAS to copy file from one server to another server without supplying the passwor

ChrisHemedinger — Thu, 07 Apr 2022 16:42:30 GMT

Methods to move files among two SAS environments:

If the two environments are "connected" using SAS/CONNECT, you can use PROC UPLOAD/DOWNLOAD. This requires a signon statement that may need credentials.
SAS supports a FILENAME FTP statement if need to connect SAS with another node that supports an FTP server. Again, usually you need credentials.
If your two environments are both accessible via a SAS Enterprise Guide session, you can use the Upload SAS Data Sets/Download SAS Data Sets tasks, or the Copy Files task, to move files between them using your EG session in the middle.
As @ballardw says, if the two machines are connected on the network with addressable folders, you might be able to use FCOPY() function to copy the files across. Or assign a library to each and use PROC COPY or PROC DATASETS with a COPY statement.

There's nothing about SAS that will allow you to bypass the need to authenticate though -- you will need credentials or federated permissions for whatever systems you're going to access.

Re: Is there way in SAS to copy file from one server to another server without supplying the passwor

SASKiwi — Thu, 07 Apr 2022 20:46:58 GMT

What is the OS of the server you are copying from and the OS of the server you are copying to? If they are the same, then you can use OS functionality to do the copy. If the OS's are different you will have to use SAS to transport the datasets so that they will be usable.

Talk to your SAS administrator. They will most likely be able to guide you as to the best approach.