Hi all,
I'm currently converting SAS programs to EG projects so that we can move a group of non-programming analysts to solely EG ie remove Base SAS completely.
I've had someone tell me the process I'm using wont work if Base SAS is removed; they are telling me that EG is utilising the Base SAS engine. Here is how I've set things up - can someone please let me know if this will work?
I notice that SAS.exe turns up in Widows Task Manager when I hit local so I suspect that this may not work if Base SAS is removed but can someone please confirm?
The reason I want it processed locally is I have a VB script that converts the XML files to native Excel and then deletes the XML file.
I dont have access to a PC with just EG unfortunately to test.
Many thanks in advance
Steve
You can test what EG life would be like without a local server by (temporarily) unregistering your SAS workspace.
From your local PC, run:
PROGRAMFILES\SASHome\9.3\SASFoundation\sas.exe /unregserver
When you next launch EG, see Help->About and select Configuration Details. You should see that local SAS is no longer "detected".
To re-enable:
PROGRAMFILES\SASHome\9.3\SASFoundation\sas.exe /regserver
To accomplish your overall goal, you should be able to use your remote SAS to write Excel files (using tagsets.ExcelXP? Is that what you're doing?)
Then use the Copy Files task (which you need to download/install) to copy the remote Excel files to the local PC. You can even use the System Command task to kick off your VBScript.
Chris
Correct. Base or Foundation SAS must also be installed on the PC with EG if you want a "local SAS connection". Otherwise all processing must take place on a remote SAS server.
You can test what EG life would be like without a local server by (temporarily) unregistering your SAS workspace.
From your local PC, run:
PROGRAMFILES\SASHome\9.3\SASFoundation\sas.exe /unregserver
When you next launch EG, see Help->About and select Configuration Details. You should see that local SAS is no longer "detected".
To re-enable:
PROGRAMFILES\SASHome\9.3\SASFoundation\sas.exe /regserver
To accomplish your overall goal, you should be able to use your remote SAS to write Excel files (using tagsets.ExcelXP? Is that what you're doing?)
Then use the Copy Files task (which you need to download/install) to copy the remote Excel files to the local PC. You can even use the System Command task to kick off your VBScript.
Chris
Hi Chris,
Yes I am using ExcelXP to write the XML and then a VB script to convert. I tried to install the tasks above but getting errors. Is this because I'm running EG5.1? If so do you have a 5.1 version?
One other question I have is will the above solution cope with dynamically named files? Currently users enter as many client ids into the program as they need and hit go and it spits out an excel file per client eg 'Client Profile for ID 123456789.xls'
Found the answer on your site Chris:
http://blogs.sas.com/content/sasdummy/2013/05/19/unblocking-custom-task-dlls/
Just have to find a friendly IT admin to unblock the Dlls....
If you could let me know whether the tasks handle the dynamically created files though that would be great.
cheers
Steve
Thanks Chris, I have it working to a degree now. I've got the xml files being created on the server, being downloaded and converted to native excel files via the two tasks. I see I can also download using the wildcard so all good. I've just got to alter my vbscript to delete the xml file once saved as but that shouldn't be a problem; my current code does this via SAS code.
For anyone else who has problems with the dlls being blocked simply copy them to a flash drive formatted fat32 and then back again and voila the problem is gone. I kid you not.
cheers
Steve
Steve, I'm glad that you got it working and that the tasks are helpful.
That's a good trick with the flash drive -- I was aware of that approach, but was reluctant to document it for fear of subverting an IT process. But since I know the task DLLs are safe, I applaud your resourcefulness.
Chris
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.