Hi all,
I would like to retrieve SAS dataset from remote to local drive when executing a SAS job via SAS Integration Technologies.
The scenarios is as below:
I have 2 servers. On server1, SAS 9.4M2 is installed. And on server2, it is not. And, I would like to utilize SAS power on server1 from server2 where SAS is not installed.
And, a Java program has been made to execute SAS program on server2 via SAS Integration Technologies.
My goal is to solve:
If not considering the shared filesystem, how can it be implemented by Java code and SAS Integration Technologies?
Do you have any idea?
Many thanks in advance.
BR./Edward
@EdwardJin wrote:
Hi Kurt,
Thanks for your advice. And, we thought about that.
However, the path of the dataset is hardcoded in some of the SAS programs.
BAD IDEA. I'd fix that first and restructure the code so that things like that can be easily controlled by setting parameters.
Hardcoding is already biting you in the behind.
The thing is how can we not change any program, and still get the dataset at the same place.
You could run the program remotely and then use sftp or similar to copy the dataset to the network share server.
What would be the use of SAS datasets on a server that has no SAS installed?
Hi Kurt,
The filesytem where the dataset is located is shared to users' Windows PCs, and SAS client is installed on the PCs.
Hope it explains.
BR./Edward
@EdwardJin wrote:
Hi Kurt,
The filesytem where the dataset is located is shared to users' Windows PCs, and SAS client is installed on the PCs.
Hope it explains.
BR./Edward
Then have the share also mounted on the SAS server, and define a library to it. Then write to that, and the datasets are instantly available for all the PCs.
Hi Kurt,
Thanks for your advice. And, we thought about that.
However, the path of the dataset is hardcoded in some of the SAS programs.
The thing is how can we not change any program, and still get the dataset at the same place.
BR./Edward
@EdwardJin wrote:
Hi Kurt,
Thanks for your advice. And, we thought about that.
However, the path of the dataset is hardcoded in some of the SAS programs.
BAD IDEA. I'd fix that first and restructure the code so that things like that can be easily controlled by setting parameters.
Hardcoding is already biting you in the behind.
The thing is how can we not change any program, and still get the dataset at the same place.
You could run the program remotely and then use sftp or similar to copy the dataset to the network share server.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.