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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.