Tag Archives: WPS 3.1

SAS Increases Prices for Workstation Product

Just noticed that SAS raised their prices for desktops. The 2014 price for a single workstation was $8700 for the first year and has increased to $9,000. This is for the Analytics Pro product and only available on Windows Workstations. Note that SAS does not sell workstation licenses for Apple’s OS X operating system because it doesn’t support OS X natively. SAS also increased the license fees for individual access engines from $3,000 to $3,100 USD.

The $9,000 price also does not include any Access Engines used to interface into databases such as Oracle, MySQL, DB2, etc…

The price increase is 3.44% and when you factor in annual inflation for 2014 (.76%) it seems rather odd that they would have an increase. Actually, by the time you get done adding two access engines (say ODBC and one other) you are looking at first year fees of $15,200. That’s a lot of money!

Our product pricing for 2015 for the WPS Workstation product here in the US has held steady. There are many reasons for this including currency issues and obtaining scales of economy are some of the reasons behind this. Remember, I’m only referring to US pricing.

If you are interested in what WPS has to offer in v3.1 on Windows and Mac Workstations, take a look at the document WPS for Workstations v3.1 to see what a bang for the buck that WPS is for any organization.

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.

Post Installation Steps for WPS Workstations

We recently wrote a short technical document on a set of post installation steps that MineQuest Business Analytics recommends after you install WPS on your workstation. We are often asked what needs to be done after WPS is installed to get the greatest performance out of WPS without too much hassle.

The document walks you through modifying your WPS configuration file, moving your work folder to another drive, why you want to install R (for using PROC R of course!), creating an autoexec.sas file, turning out write caching and a few other pointers. You don’t need to to all of the suggestions, after all they are just suggestions, but they are useful modifications that will enable you to get more out of WPS on your workstation.

You can find the document “Post Installation Steps for WPS Workstations” in the Papers Section of the MineQuest website.

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.

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.

ubuntu_disk_cache

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.

What’s New in WPS v3.1

We have a new release of WPS out the door and we wanted to share the news! This is a major release and includes a number of new features and procedures.

New and Enhanced Communication Features

WPS Link – WPS Link is an interface for the communication between a desktop version of WPS (or a fat client) and a WPS Server. WPS Link implements the Eclipse Workbench that allows a user to submit WPS programs from their desktop to a server. WPS Link also includes a file explorer where a user can store their programs on the server and access them as if they were on their desktop. WPS Link will only talk to a WPS Server and does not provide desktop-to-desktop communications. WPS Link is included as part of your WPS license fee.

WPS Communicate – is a product that allows for the remote submitting and scripting of WPS programs to a server. It differs from WPS Link in that WPS Communicate allows for the Upload and Download of files and data sets programmatically. Communicate will only communicate between a desktop copy of WPS and a Server or Server-to-Server. WPS Communicate does not provide desktop-to-desktop communications. The WPS Communicate client is included in your desktop license and a server connection is included with a server license of WPS.

 

New Procedures

PROC ARIMA – Arima (autoregressive moving averages) is a time series modeling technique to help better understand your data or predict future points in a data series.

PROC EXPAND – is a procedure that allows the WPS user to expand or contract time series data and interpolate missing values as well.

PROC FORECAST – a forecasting module that implements basic forecasting methods that are highly automated. Proc forecast is able to forecast hundreds of series at a time using either separate variables or with the use of the By statement.

PROC HTTP – allows access to remote “cloud-based” files.

PROC JAVAINFO – allows the WPS developer to ascertain information about the Java environment that WPS is using.

PROC KDE – The KDE procedure performs either univariate or bivariate kernel density estimation.

PROC R – Proc R is the first procedure written by World Programming that is unique to WPS. Proc R allows you to execute R code from within the Eclipse environment and to exchange data frames and WPS data sets between the two applications.

PROC Soap – The Proc Soap procedure reads in XML from a file using a fileref and writes XML output to another file that also has a fileref.

PROC VARCLUS – Varclus is a procedure that implements variable reduction by separating variables into non-overlapping groups (i.e. clusters).

PROC X12 – is a procedure that seasonally adjust time series data either monthly or quarterly.

 

New System Features

DBCS – Double Byte Character Support is now available for the first time in this release. DBCS allows for support for languages that have more than 256 characters. Not available on z/OS.

JavaObj – is an interface that allows the WPS and Java developer to run Java Programs from WPS.

Secure Email – WPS now has support for secure email.

 

Database Engine Features

SAP Hana – Support for SAP’s in-memory database is now included as a new access engine.

Actian Matrix – A new database engine for Actian Matrix (formerly Paraccel) has been implemented and is included as a component of the system.

Netezza – WPS engine for Netezza named pipe bulk loading and unloading.

MySQL – Added bulk insert functionality for MySQL.

SSL – added support for SSL (Secure Sockets Layer).

 

Pricing and licensing

Pricing for the new release remains the same starting at $1,311 for a new workstation license. Don’t expect any price increases until the end of the year. In regards to licensing, there are no up-charges for Data Service Providers.

 

Evaluations and Quotes

MineQuest Business Analytics is an Authorized reseller of the World Programming System. Contact us to arrange your free 30 day product evaluation on a desktop or server. Contact us for a quote or to arrange a free 30 day evaluation for any of our products.

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.