Category Archives: Ubuntu

Another Update on my Ubuntu Experiment

Environments are important. Whether it’s having the right desk and office chair, the perfect office or where you chose to live, my emotional satisfaction and motivations are impacted by my environment. It doesn’t matter whether you work solo or in a small group, your environment affects how you work and how well you work. I clearly remember driving to work on I270 in Columbus, bumper-to-bumper traffic and arriving at work in such a foul mood because of the commute. I moved to Grand Rapids, MI and there experienced cold overcast skies and lots of snow. I learned that I was suffering from SAD (Seasonal Affective Disorder.) I was able to change that for myself years ago, but the same principles apply whether you are looking at your work-flow and perhaps your workstation environment as it pertains productivity and satisfaction.


Lessons learned, my commute today… Home office to patio and a lot less stress.

Another month has passed since I went over to Ubuntu as my primary OS as wanted to get back to those who may be wondering how it has gone. I must say, even with a five year-old mediocre laptop, it has gone better than I thought it would. Almost every wound I have suffered has been self inflicted.

Am I as efficient and effective as with my Windows machine? The answer is “yes.” Programming in WPS and surfing the internet has been the same experience as with my Windows machines. I have gone back to my Windows PC for bookkeeping chores when I needed. I chose not to try to move that application for this experiment. I considered it too much work and out-of-scope.

Since I started this experiment, Canonical has decided that they are going to drop their GUI interface called Unity and return to Gnome. Unity it seems, was a project that was designed to “unify” the Ubuntu experience across platforms such as tablets, phones, laptops and workstations. From my reading, the decision was made to stop the financial hemorrhaging and focus on workstations and servers at the expense of phones and tablets. I actually found Unity easy to use and not a hindrance at all.

I can understand and appreciate the reasons for that decision however. Mark Shuttleworth (founder and CEO) wrote a blog post on how and why he came to that decision. Basically, Canonical is a business (not a charitable organization) and he is treating it as such. Move to your strengths and develop those areas where the revenue stream is best.

But back to my Ubuntu experiment. I could go through each application that I use and talk about the anomalies that I discovered but that would be really boring. But suffice to say, that using LibreOffice was decent and a good enough replacement for MS Word. LibreOffice Calc was good enough for my spreadsheet needs as well. I did suffer using MS OneNote a bit. I’m a huge advocate of using OneNote to keep my ideas, plans and outlines in one place. It’s one of my go-to applications.

The issue I have with OneNote is using the online version. Unexplainably, it would insert extra space between words or even letters at random. It wouldn’t do it often, but often enough to be irritating. Perhaps it is the browser I used and I should try OneNote with a different browser.

I’ve been writing a vertical market application over the last four to six months in my free time. This is a street mapping application using R, Google Maps and WPS. WPS has worked like a champ on Ubuntu Linux. Everything I threw at it worked straight away. The Eclipse workbench is exactly the same as you would see when on Windows. As a matter of fact, I like the font used by Eclipse better than the one on Windows.


By the way, the screen shot you see above that has the WPS Workbench displayed – this is the exact same interface you see and use with WPS Link on Linux. WPS Link is the “thin client” that World Programming distributes with their server software which allows users to interactively access the WPS software as if it was running on their desktop.

So, the question to be answered is “Can I move away from using Windows as my only OS platform for everyday use?” The answer to that is “yes.” I will most likely purchase a Dell Laptop that has Ubuntu pre-installed this summer and use that as my primary development workstation. I will keep a Windows workstation so I can test and develop on that platform as well. However, now that Skype is running decently on Ubuntu, there is no reason that I can find to not use Ubuntu. What do I give up other than forced reboots and forced updates? Not much…

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in beautiful Tucson, Arizona. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS consulting and contract programming services and is an authorized reseller of WPS in North America.

An Update on my Ubuntu Experiment

Just an update on my Ubuntu experiment that I wrote about in the last blog post.  I do have most everything installed that I want for the experiment. I’m going to use Ubuntu 16.04 as much as possible and only revert back to Windows when absolutely necessary.

So far, I’ve went back to my Windows workstation for QuickBooks to update some accounting information. I guess I could probably put QuickBooks into the cloud but at this point I’m going to hold off on that application until I get other things tested.

I have to admit this laptop is on the heavy side but it has a really decent battery. On a full-charge I get around 7 hours. My 17” I7 Toshiba laptop gets maybe three hours and that’s if I put it into Eco Mode. The Dell e6420 also has an NFC hotspot and a finger print reader. I’m not using either one of those and don’t think there’s a driver for those hardware elements either.

I do have WPS, R, Python and R Studio all working well. I’m using Thunderbird for my email application and LibreOffice (using it to write this post) for my writing and documentation chores. I’m looking for a OneDrive connector that works seamlessly but so far, I’m still searching.

Just for kicks, I did try using Microsoft Office Online. This is the web version of office. It seems that I tend to skip letters in words or Office online would randomly adds spaces between words in my text. I’m not sure why but it seems to be constantly saving whatever I’ve entered. Meaning not saving in say 5 minute intervals or something similar. Could be something with Firefox too.

One thing I need to mention is that the performance is good. I have run dozens of WPS programs and they all have executed in a reasonable amount of time. I live in a world where the processing I do is measured in data sets of 10 million or less for my development. Using WPS on this laptop is a good experience and processes these datasets quickly.

I did get two emails over the week asking about WPS on Ubuntu. WPS does run fine on Ubuntu and I have no complaints on that. One emailer asked about the price of WPS on Linux and whether it was really cost effective as a workstation product.

WPL licenses WPS on Linux as a server product. You don’t get workstation pricing on Linux. Workstation pricing is only for Windows and Macintosh products. If you are expecting a Linux Workstation to be as cost effective (i.e. priced the same) as a Windows or Macintosh Workstation, then you will be disappointed.

I suppose that one could always license a small WPS Linux Server (2LCPU and say 8GB of RAM) and run it in a virtual machine using Xen or Virtual Box and still be less expensive than our competitor’s Windows workstation pricing. But if you’re a developer, you probably need to think about development and test platforms quite a bit.

Here’s a suggestion. Say you are a developer and are looking to develop a vertical market application. You could easily license both Macintosh and Windows workstation products and still be under $2500 a year. Of course, you have the cost of a MacBook or Mac Workstation to add on to that, but it is still very doable and capable as a development machine. Actually, a Mac Mini could work nicely for an Apple development machine. Just make sure you don’t buy the newer model that is not upgradeable since they soldered the RAM in place enforcing planned obsolescence.

The Macintosh product license could suffice for developing and testing code that is to be executed on Linux/Unix computing platforms. Of course, the Windows product license would do the same for Workstation and Server products.

I have taken a set of macro’s that I have in a library and compiled them under OS X. I’ve then copied them over to the Linux machine and it executes flawlessly. This is not an exhaustive test by any means but it does demonstrate what can be accomplished using a Macintosh Workstation. Perhaps a more complete Proof-of-Concept should be attempted and we could certainly arrange an evaluation for those products if you desire.

And finally, one more thought. If you are a developer creating a vertical market application and your target platforms are Windows, Linux and OS X and you need to have WPS Link and WPS Communicate for connecting to a remote server, then you will need a Linux Server or a Windows Server for test and development. If your product does not require pushing code that’s to be executed on the remote server, then just the Mac and Windows Workstations will likely suffice.

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in beautiful Tucson, Arizona. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS consulting and contract programming services and is an authorized reseller of WPS in North America.

I’ve always been a fool for a bargain…

My last blog post, I was pretty incensed with Microsoft and Windows 10. I just don’t understand some of their decisions as it pertains to professional developers who use their tools and have to struggle with how they force upgrades and perform reboots. I’m still upset so I’ve decided to try a little experiment.

I recently came across a five or six-year-old Dell laptop that was priced (I thought anyway) on eBay at an incredible price. This laptop is a Dell E6420 with an Intel I7 CPU and 4GB of RAM laptop for sale at $150 or best offer. Doing a quick perusal online, this laptop has a screen resolution of 1600×900, an NVidia graphics card and with a 9-cell battery which can get (supposedly) up to 10 hours of battery life. Hoping I was not making a rash decision, I decided to give it a try and make it part of my collection.

This little machine was missing a power adapter and a hard drive. It did power up on battery power so I know it works. I found a power adapter on eBay for $20 and I have an older 500GB HDD sitting in a file drawer. I think I might have a couple of 4GB SODIMM’s somewhere that I tore out of a Mac Mini. If I can’t find those SODIMM’s, then I will buy some RAM online. I may also discard the DVD drive and replace it with a small SSD down the road. I can’t remember the last time I used a DVD in a computer so it’s easy to let that go.

If you are like me, you probably have hundreds of cables, plugs and other accessories laying around and at least 20% of it you have no idea what it belongs to. Yet, you’re afraid to get rid of it because it might be something you need down the road. I guess that is one of the few advantages of being a hoarder. i.e. being able to talk yourself into almost any purchase!

So, being the Froogle individual consciousness consumer I am, I ended up winning this machine at best price of $80. It sounds so counter-intuitive to spend money on five-year-old piece of technology but it does give me the opportunity to try an experiment that I’ve wanted to do for the last year. Now motivated by Microsoft, I decided to just do it.

I’m sure many of you have seen the Dell XPS 13 laptop running Linux. It’s fairly pricey bit of kit but it does get rave reviews. It’s obvious that the XPS 13 is also more powerful. I’m also intrigued by the thought of trying to setup an environment where I’m not using OS X or a Windows environment at all. So right now, I’m not concerned with getting a machine with the ultimate in performance. I’m also a bit concerned with working on such a small screen for long periods.

I’m not at all confident that all the programs exist that I want (or need) to use are available on Linux. But, this is an interesting experiment non-the-less.

The idea behind this concept is to see if I can set up an everyday working environment for writing, programming and performing desktop analytics. I want to be able to plug this into a large monitor and use it as a typical workstation when I’m not lugging it around.

Also, I am not adverse paying money for software. I’m not a believer that everything I put on a PC or laptop with Ubuntu must be free or open source. I do expect to purchase a fair amount of software including UltraEdit.

Initial Software

I’m jumping ahead here because I’m going to have to solve some issues with the Ubuntu Install. I want to make sure the trackpad and power options work. Probably be wrestling with the webcam as well. These seem to be issues I found when Googling the internet. Update: the only thing I can’t get to work properly is the sound from the laptops speakers. I can get sound via Bluetooth, HDMI and the headphone jack. I am not sure how much time I want to spend on the sound issue since I typically use a Logitech USB headset or Bluetooth headset from SoundPEATS. Specifically, the model QY7 if you want some quality sound out of a set of ear buds.

I will post back on how this works out. In the meantime, if you have not yet downloaded WPS v3.3, I strongly suggest you grab that release and step up your game!

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in beautiful Tucson, Arizona. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS consulting and contract programming services and is an authorized reseller of WPS in North America.

Ubuntu 16.04 Released and Quick Test Drive

In the last week, Canonical has brought forth a new release of Ubuntu and it is pretty nice! Version 16.04 has a number of great features that should be of value to those who use Linux. One thing that Ubuntu has at this point is a vertical line of products. I can’t think of any other vendor who has an OS that runs on Phones, tablets, notebooks/workstations, servers and mainframes.

I decided to give it a try on one of my workstations running it in an Oracle Virtual Machine (Virtualbox to be specific) to see how WPS runs on this new release. Just to cut to the chase, it runs quite well. As a matter of fact, once I got the VM to use all of its allotted storage, WPS ran like a charm.


A couple of things that might be of interest to potential Ubuntu upgraders. First, Ubuntu 16.04 supports ZFS. That might be important to a few sites. The second is the support for LXD 2.0. From the Ubuntu website –

LXD 2.0

Ubuntu 16.04 LTS includes LXD, a new, lightweight, network-aware, container manager offering a VM-like experience built on top of Linux containers.

LXD comes pre-installed with all Ubuntu 16.04 server installations, including cloud images and can easily be installed on the Desktop version too. It can be used standalone through its simple command line client, through Juju to deploy your charms inside containers or with OpenStack for large scale deployments.

All the LXC components – LXC, LXCFS and LXD – are at version 2.0 in Ubuntu 16.04 LTS.

In addition to trying Ubuntu 16.04 in a VM, I have also tested it on a small server (6 LCPU with 32GB of RAM) running WPS. Although I have not benchmark tested this exhaustively, it does appear that using v16.04 with WPS 3.3.2 (which is the latest release) provides a modest performance increase. This is easily observed with multi-threaded Procedures such as Means and Summary.

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in beautiful Tucson Arizona. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and is an authorized reseller of WPS in North America.

A Summer Project

One of my summer projects is building and performance tuning a relatively inexpensive analytics server. Many of the parts that are being used have been scavenged from another server or two that have been retired. One thing I want to do this summer is report on what I have discovered in performance tuning a modest server.

The server consist of a six core AMD processor and 16GB of RAM to start out with. I would like to experiment with different combinations of RAM, hard drives, hard disk controller cards and perhaps an SSD or two. The OS will be Linux, Ubuntu 14.04 specifically.

My baseline build has just two work drives in RAID-0 and use the SATA 3 ports on the motherboard. I will use the Workstation Performance Assessment Program that I wrote about back in 2012. I’ve slightly modified that program so that it doesn’t spew output in the listing with the exception of the actual performance benchmark.

One thing I have already learned is that you need to make sure that you have the Write Cache enabled. In Ubuntu, you would do this by going to Disks and clicking on the options button at the top right of the dialog box and then selecting Drive Settings. Simply select the Write Cache and click on Enable Write Cache. You will need to do this for each disk in the raid array.


When I enable the write cache, my timings for the PROCs and data steps that took place on data sets that existed on the work array dropped 35%. That’s a big improvement!

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in Grand Rapids, Michigan. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and is a authorized reseller of WPS in North America.

Thursday Ramblings

Does anyone do comparisons of graphics cards and measure performance in a VM? Specifically, do certain graphics cards boost performance when running VM’s on the desktop? I like to see my windows “snap” open when I switch from VM to VM. As a developer, I often wonder if spending an additional $150 on a popular graphics card will yield a perceptible performance boost.

Speaking of graphics cards, we recently bought a couple of used Nvidia Quadro graphics cards from a local CAD/CAM company that is upgrading their workstations. I got these at about 5% of their original retail price so I’m happy. We were having problems getting a couple of servers to go into sleep mode using Lights Out and we discovered that we needed a different graphics card to accomplish this. The plus side is that these are Nvidia cards with 240 CUDA cores and 4GB of RAM. So we now have the opportunity to try our hand at CUDA development if we want. I’m mostly interested in using CUDA for R.

One drawback to using CUDA, as I understand it, is that it is a single user interface. Say you have a CUDA GPU in a server, only one job at a time can access the CUDA cores. If you have 240 CUDA cores on your GPU and would like to appropriate 80 CUDA cores to an application — thinking you can run three of your apps at a time, well that is not possible. What it seems you have to do is have three graphics cards installed on the box and each user or job has access to a single card.

There’s a new Remote Desktop application coming out from MS that will run on your android device(s) as well as a new release from the Apple Store. I use the RDC from my mac mini and it works great. I’m not sure what they could throw in the app to make it more compelling however.

Toms Hardware has a fascinating article on SSD’s and performance in a RAID setup. On our workstations and servers, we have SSD’s acting as a cache for the work and perm folders on our drive arrays. According to the article, RAID0 performance tends to top out with three SSD’s for writes and around four on reads.

FancyCache from Romex Software has become PrimoCache. It has at least one new feature that I would like to test and that is L2 caching using an SSD. PrimoCache is in Beta so if you have the memory and hardware, it might be advantageous to give it a spin to see how it could improve your BI stack. We did a performance review of FancyCache on a series of posts on Analytic Workstations.

FYI, PrimoCache is not the only caching software available that can be used in a WPS environment. SuperSpeed has a product called SuperCache Express 5 for Desktop Systems. I’m unsure if SuperCache can utilize an SSD as a Level 2 cache. It is decently priced at $80 for a desktop version but $450 for a standard Windows Server version. I have to admit, $450 for a utility would give me cause for pause. For that kind of money, the results would have to be pretty spectacular. SuperSpeed offers a free evaluation as well.

If you are running a Linux box and want to enjoy the benefits of SSD caching, there’s a great blog article on how to do this for Ubuntu from Kyle Manna. I’m very intrigued by this and if I find some extra time, may give it the old Solid State Spin. There’s also this announcement about the Linux 3.10 Kernel and BCache that may make life a whole lot easier.

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in Grand Rapids, Michigan. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and is a authorized reseller of WPS in North America.

Creating a WPS Launch Icon in Ubuntu

I use Ubuntu for my WPS Linux OS and it’s pretty easy to install. However, unlike the vast majority of people out there who run it in batch mode; I like to run it in interactive mode using the Eclipse Workbench. Hence I want an icon that I can click on to start WPS. Here’s how to do it.

On the Ubuntu desktop, right mouse click on an empty part of the screen and you will get a little option menu. Click on “Create Launcher…” You will see a dialog box pop up that looks like:


On my Ubuntu Linux Server, I installed WPS into a folder named wps-3.0.1. The directions below use that folder name as our example. You may have installed WPS into another folder so be sure to consider that when performing the tasks below.

Name: WPS 3.01

Command: /home/minequest/wps-3.0.1/eclipse/workbench

Comment: WPS 3.0.1 Linux

Click on the icon on the upper left hand of the Create Launcher Dialog Box (the little spring) and you will get a choose icon list box. Simply go to the WPS install folder and go into the eclipse folder. There you will find a file named icon.xpm. Click on icon.xpm and then click Open and then click OK.

That’s all there is to it. You should have the WPS icon installed and available from your desktop.

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in Grand Rapids, Michigan. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and is a authorized reseller of WPS in North America.

Cool and Useful Software

I always enjoy reading other folks blogs on how they work and the tools they use most every day. It’s a great way to learn about new tools and how to work more efficiently. I have to rave about the phone system we use here at MineQuest. We use VOIP and our provider is VOIPO out of Texas. The quality is tremendous as well as the support. The cost is amazing for what you get. The benefits of VOIPO are numerous for a small business, but the one I like the most is a softphone. I can travel and still be able to use my phone system almost as well as if I was in the office. You can visit the VOIPO web site to get pricing and view all the features that they offer.

Of course I use Skype. I can use Skype to call overseas and to text message with friends, family and business contacts. I have contacts that are almost always on Skype and the number of Skype contacts that I have just continues to grow. If you want or need to do business overseas, then Skype maybe the only way you can do so cost effectively. I hope to see more integration of Skype into other products and services and the availability of an easier to use API. If you don’t have at least a free Skype account, you should visit the Skype website and get Skype today.

I recently started to use a new Linux distribution called ZorinOS. I have version 6.1 and essentially, ZorinOS is Ubuntu Linux with the coolest GUI interface. With ZorinOS, you can change the interface to mimic Windows XP, Windows Vista, Windows 7, Mac OS X and the Ubuntu Unity Interface. If you are a Windows User and want to start using Linux with minimum fuss and frustration, ZorinOS is something to try. Check out the ZorinOS website to learn more.

I also signed up for Microsoft’s Office 365. There are a number of plans available and you can see all of them at the Microsoft web site. But if you have multiple machines like I do, desktop, laptop and a Mac, Office 365 gives you five simultaneous installs for $100. This is an annual license and I love that I get Outlook on all my desktop machines. I love the simplicity and the fact that I get cloud storage to store my documents so I can access them from anywhere.

About the author: Phil Rack is President of MineQuest Business Analytics, LLC located in Grand Rapids, Michigan. Phil has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and is a authorized reseller of WPS in North America.

Bridge to R v3

The newest version of the Bridge to R is finally done. The Installation and User Guide has been written and the sample programs have been updated. This release is a milestone for us because we have the Bridge to R running on three major platforms. These platforms are Windows (both desktop and servers), Mac OS X on x86, and Linux on x86.

The manuals are available online and can be found at and select the appropriate guide from the left hand side of the page. We will be revising the guides over the next few months as we port some additional utilities over to the OS X and Linux specific versions.

We will continue to provide the Bridge to R to customers who license WPS from MineQuest as a no cost solution.  If you have licensed WPS from another reseller or from World Programming, there is a cost involved to acquire the Bridge to R. The cost for the Bridge is $240 on a desktop (Windows or OS X) without regard to the number of logical CPU’s on the workstation.

The cost for the Bridge to R on a Windows or Linux server is $599 annually per logical CPU. Running R on a large server is advantageous because you can often access  much more memory than a desktop traditionally offers and servers tend to have faster CPU’s.

If you have licensed WPS from MineQuest and desire a copy of the new version, contact us and we will begin shipping the files on Saturday, March 31st.

About the author: Phil Rack is President of MineQuest, LLC. and has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and a reseller of WPS in North America.

Introducing WPS Version 3

It’s a new year and version 3 of WPS is out and available. There’s a lot of new items in this release and I think it has been well worth the wait. I personally feel that this is the block buster release that will turn heads in the corporate environment due to so many added features. With version 3, World Programming has made the software more friendly and easier to use, added new procedure support both statistically and in the core language, and added support for more language elements.

I’ve been beta testing WPS 3 for a few months now and so I’ve had a bit of time to try the software out and evaluate it extensively. Below is a list of items and features that really stood out to me in WPS V3. It’s far from being exhaustive but these are probably the most pertinent for many WPS users and SAS customers who are considering WPS as an alternative to SAS.

Workbench Support on Additional Platforms

The Eclipse workbench is available on Unix, Linux, Windows, AIX, Solaris and OS X platforms. The GUI that you’ve been using on Windows is now available on all the platforms except for z/OS. Amazingly, the Eclipse Workbench is identical (and I mean identical) across the platforms. Now when companies and organizations add servers to their data center and the users will have the same identical experience (read no learning curve) on all the platforms.

Apple OS X Support

WPS has been available on Apple’s OS X for a while, but now it has the Eclipse Workbench as the GUI. The WPS implementation on OS X is native, meaning you don’t have to run Parallels or Boot Camp to run WPS on your Mac. WPS is a true 64-bit implementation on OS X. The technical specifications for the Mac OS X implementation is that it needs to be an x86 chip and you will need version 10.5 (Leopard) or higher. WPS V3 works fine on Lion as you can see in the screen shot below.

Click here to view larger image.

About a month or two ago I bought a Mac Mini just to test WPS and to port the Bridge to R over to it. The Mac implementation is a bit prettier than on Windows or Linux in my opinion. It may be the font, but it does look nice as you can see in the image above. In testing WPS on OS X, I was amazed how easy it was to transfer my knowledge of the WPS implementation on Windows over to OS X.

There’s a lot of folks who love their Macs and WPS running natively gives the Mac faithful a SAS language compatible system that takes full advantage of their hardware. Mac users give up nothing over the Windows or Linux versions of WPS and desktop pricing for the Mac is the same as for the other desktop platforms. I’m excited for the university students where there is a preponderance of Macs and I can see the take up of WPS because of the hardware and operating system support.

Linux Support

As mentioned earlier, the workbench is also available on Linux. I have it running on both Ubuntu 10.4 LTS and Fedora 13. As you can see in the screen shots below, WPS looks the same on each of the platforms. One thing to note about the Linux version, it is only available as a server license. But for shops that have a Linux platform, WPS executes exactly like the Windows version in that it provides the end users the same experience as it pertains to the GUI.

Click here to view larger image.

Many shops run Red Hat as their preferred version of Linux and WPS does run just dandy on that platform. I find that many of the larger customers we have do use Red Hat, but I suspect that the smaller businesses use Ubuntu or Fedora instead.

AIX and Solaris

The workbench is also available on these platforms. I don’t have a license or even a machine to run these two implementations on, but I would suspect that the experience is identical to the Apple and Linux versions discussed above.

WPS Link

This is an exciting feature that is being introduced in WPS 3.0. WPS Link is a Client/Server architecture that allows you to remotely execute code on Linux or Unix servers. So for example, you can be running WPS on your Windows or Mac OS X desktop and submit your WPS code over to a WPS Linux server. The log and listing files come back from the remote machine to your desktop. WPS Link is different from SAS/Connect in that this is just a client to execute your programs on the remote box. You can’t upload and download files from the desktop to the server. But, if a lot of your processing takes place on the server and that’s where your data sets reside, this is a nifty solution for processing data on a remote server.

WPS Link is easy to setup from you WPS Desktop. Simply go to the Server Connection tab and select Local. Right mouse click on Local and you get a drop down menu. Select New || Server Connection || Remote SSH.

From that point you get a dialog box where you simply fill out the hostname (or IP Address) the Connection Name (how about “WPS Remote Server”) your user name and the Launch Command. The Launch command was the most difficult part for me. It’s simply the location of the folder where WPSLinks module is located. On my server it is:


Make sure you have SSH running on your Linux server and you will be able to remotely start WPS on the server from your desktop!

Submitting code from the desktop to the WPS Server is relatively easy. Simply go to the Submit Icon and you will find a downward facing arrow next to it. You can select whether you want to run the code Locally or on the Server. One of the cool innovations with WPS Link is that you can have multiple servers registered and choose which WPS server you would like to run your code on. Note the options in the drop down menu shown below.

WPS Link comes standard as part of your WPS purchase. So if you license WPS on the desktop, WPS Link will be available to you as part of your desktop license. Also be aware that in this first release, WPS Link requires WPS running on an AIX, Solaris, Linux Servers and Linux on Mainframe System/z. I suspect that you will see Windows Servers being supported in a later release. But for our customers running large volumes of data on Linux or Unix, this feature will be very welcome.

One other note of importance on WPS Link. You can connect from a desktop to a server and server-to-server. You cannot link from desktop-to- desktop.

Procedure Support

In version 3, World Programming has added support for the following statistical procedures.

  • T-Test
  • GLM

Database Engine Support

One of the things that SAS does that I really don’t like is the up-charge for database engines. With WPS, you get the database engines as part of the WPS license. You don’t buy these separately. With version 3 of WPS, there is now support for an XML Libname engine and Sybase databases.

If you’re a shop that has a few different databases from different vendors, it would be financially wise to take a look at WPS just for the cost reduction with the included access engines.

Other Enhancements

WPS has now implemented multi-threaded support for PROC MEANS and PROC SUMMARY. It’s always fun to look at the execution time for CPU and Real Time when dealing with multi-threaded procedures. From some of the WPS documentation you can see that the multi-threaded support that is used in MEANS and SUMMARY has made it into procedures that make use of this code such as PROC TTEST and I assume PROC CORR.

Also, for those of you who were unaware, PROC SORT is also multi-threaded and is very fast. If you do a fair amount of sorting in your environment, it would be beneficial to be running on a 64-bit platform and load up with memory. The more memory you have available to WPS, the more data it can store in RAM when sorting and this results in faster sort times.

There is now an import and export wizard for importing files into WPS and writing out WPS data sets to text files. This is pretty big in my opinion. I could never remember the PROC IMPORT statements even though I use them often. Probably everyone uses a code template for importing and exporting but this just makes life easier.

The data set viewer has been enhanced over the previous release. You can view the variables labels instead of just the variable names. You can also show and hide variable columns.

Also supported for the first time is the SYSTASK and WAITFOR commands. I’ve been waiting for these two language statements to be supported for a while. As part of the Bridge to R on Windows there is a module called MPExec. MPExec allows you to run multiple programs in parallel. I’ve had to resort to using other methods in lieu of SYSTASK and WAITFOR to get this to work. Now that these two commands are available, we will update MPExec to use these features instead, thus MPExec will become portable to other platforms.


Performance has improved in each release of WPS and WPS v3 is no exception. With multi-threaded support for more procedures and better data handling, WPS is a very viable candidate to replace SAS at many organizations. MineQuest has many customers who run large data sets (millions, ten millions and hundred millions) of records through the WPS System and performance is more than adequate. These companies are able to save loads of money over the competing software system.


With affordable pricing, customers can use WPS to perform reporting and analytics in areas and for departments that just wasn’t justifiable before. Using WPS in lieu of SAS allows many organizations to expand the analytics platform and run more data through the system. This is because such advantageous pricing allows them to purchase an additional server at great savings over our competitors.

Data Service Providers

We love Data Service Providers! Seriously, we find that DSP’s are some of our best customers. With WPS V3, licensing terms stay pretty much the same. World Programming LTD does not have DSP fees and you are free to use WPS to service your customers by providing them with data sets, reports and analytics. For any organization that is paying DSP fees, we can dramatically reduce your license fees. Your customer is your customer.


Before you download the latest release of WPS, there is one caveat to keep in mind for upgrading. If you are using batch command files to run your jobs, you need to modify the name of the WPS executable in your .bat or .cmd file. The program name you want to use is WPS.EXE (as opposed to the former name which was WPSI.EXE).

Also in WPS V3 the WPD dataset has changed and is faster and more robust. You can still read WPD V2 datasets but V3 datasets are the default in this release.

Finally, you will need a new license key to be able to install V3. Don’t expect to simply download it and run it using the V2 key as you have been able to do previously. If you are a MineQuest customer, contact us if you want to upgrade to V3 and we will facilitate getting you a license key.


MineQuest is offering free 30 day evaluations of WPS V3. You can contact us at (614) 457-3714 to request an evaluation or by email. If you prefer to request your evaluation by email, send a request to

About the author: Phil Rack is President of MineQuest, LLC. and has been a SAS language developer for more than 25 years. MineQuest provides WPS and SAS consulting and contract programming services and a reseller of WPS in North America.