BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
megalopsuchos
Fluorite | Level 6

Hello and thanks for your help.  First of all, I am an administrator of SAS, among other things.

Our SAS environment is hosted on Windows 2012 and consists of 4 servers: 

Base/Foundation, Visual Analytics, MetaData and Middle-Tier.

Our SAS version is 9.4M3.

My most pressing need is to understand the best way to load data into memory and maintain the data in memory from Enterprise Guide to SAS Visual Analytics

 

Enterprise Guide uses the Base/Foundation Server for its processing and places generated datasets in a folder location on the Base/Foundation Server

 

There is an option in Enterprise Guide to load the datasets into Visual Analytics; however, the next time the LASR server is restarted, there is a possibility the tables may not reload in Visual Analytics<< this needs to be avoided and so far I've been relying on "ReloadOnStart" but SAS Support says that's a bad idea, and I agree

 

I've read on other threads and on user blogs of ways people have maintained datasets in memory from BI>VA. One of them mentioned writing a Windows script that moves datasets from Foundation/Base server to the SAS Autoload dropzone.

 

Another mentioned writing datasets to a "co-location," but did not specifically mention how to create, maintain a co-location. The SAS Base/Foundation server's dataset library is a shared network location.  

 

Why can't I reassign my dropzone location to the shared folder on Base SAS server and if possible, what's the best way to do this?  Or, I suggested to SAS support the windows script option...but I was worried... if I set up a windows task to copy datasets from Base SAS>VA drop zone, say every 30 minutes, would that be enough time to ensure the datasets would be finished running from Base SAS? So, I suggested using "datalock" but that is also not recommended, by SAS support.  Right now we are thinking a Windows script to move datasets from SASLib to the append folder.

 

Does anyone out there have a solution to this in use at the moment?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

Cool, good to hear you have solved your problem. Please mark the post as answered if you have no further questions on this topic. 

View solution in original post

3 REPLIES 3
SASKiwi
PROC Star

Using shared folders between your SAS App server and your SAS VA App server is definitely a good way to go. I'm not a great fan of VA autoload, although it has its place for adhoc usage. If I have regular updates of SAS VA data then I'd rather load them as soon as they are available all in the one SAS job.

 

The way we do it, we have scheduled batch jobs that run on our SAS App server that write the VA load tables to a shared folder. They then use SAS/CONNECT to sign onto the SAS VA server and load the tables into the VA LASR library. All this happens in a single SAS job which is very reliable, efficient and easy to maintain. SAS/CONNECT is required in our case because we run non-distributed VA on Windows 2012.

megalopsuchos
Fluorite | Level 6

Thanks for your reply.  I ended up doing something similar to your method.  Wrote a batch to copy the files with a nightly windows task.  Thanks again.

SASKiwi
PROC Star

Cool, good to hear you have solved your problem. Please mark the post as answered if you have no further questions on this topic. 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1681 views
  • 1 like
  • 2 in conversation