As many of you may already know, you can run WPS on a Windows Server using a Terminal Server (TS). What is really exciting is that the cost of WPS on a server is the same price as on a desktop. So, if you have a two-core CPU on your desktop, you can run WPS on a two-core CPU under Windows 2000 or 2003 Server for the same cost. This is a great deal being offered by the World Programming Corporation, the developers of WPS.
So, let’s take this a step further and think about how you can leverage this opportunity. If you don’t have a TS installed, MineQuest has another option that you can explore. We just finished writing MQBatch. MQBatch is a program that allows you to use UltraEdit as your editor on the desktop and submit SAS source code to WPS on the server. MQBatch watches a directory and its subdirectories watching for a program with the extension of .WPS or .SAS and then invokes WPS to run the program. MQBatch makes sure that the LOG and LST files are written back to the user’s assigned subdirectory on the server. What’s really nice is that UltraEdit will detect when the .LST and .LOG files have changed and automatically reload them in the editor.
As it is currently written, you can only run MQBatch as a windows program (not as a service) on the server. It is quite configurable and you can use it to run SAS as well as WPS in this manner. This is a nice feature for being able to convert from SAS to WPS.
Speaking of conversions, it’s really stunning when you think about the cost of SAS in comparison to WPS. Because we are making MQBatch free, the only thing you have to license (other than WPS for the server) is UltraEdit. Currently, an UltraEdit license is $50. So, your total out of pocket license cost for WPS is less than $850 for five users on a Windows Server. Compare that cost with SAS\Base, SAS\Connect, and SAS\Access on a Windows Server!
You can download MQBatch from our website at www.MineQuest.com. Go to the downloads section and download the three files that make up MQBatch. Briefly, the three files are:
DirectoryInstall.zip – sets up the directory structure that is necessary. The directories that are created are for users to submit code into as well as the necessary scripts needed to install and run the UltraEdit Client.
MQBatchInstallGuide.zip – the installation guide for installing MQBatch. Read this first before attempting the install. You have to unzip the DirectoryInstall.zip file as the first step.
MQBatch.zip – the .NET program that makes all this possible. MQBatch is a file watcher that detects when a WPS or SAS program is submitted to the users folder and invokes the correct programs either WPS or SAS.
If you don’t have UltraEdit, you can get a 45 day trial from www.UltraEdit.com. UltraEdit is a superb editor and you can use SAS Syntax Highlighting in the editor as well.
If you have any questions installing MQBatch (there are multiple steps), Read the Installation Guide. If you’re still stumped, feel free to send e-mail to firstname.lastname@example.org and we will do our best to help you get MQBatch running so you can execute WPS or SAS programs on your server.