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.

clip_image002

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.

Posted in Linux, Ubuntu, WPS v3.2 | Tagged , , , | Comments Off on Ubuntu 16.04 Released and Quick Test Drive

WPS v3.2.2 Released

 

Earlier in the Week, World Programming released an update to WPS. Version 3.2.2 is mainly a maintenance release with a number of fixes.  There are some improvements and the two that caught my eye are:

25591: WPS can now handle record lengths up to, or even greater than 32K when writing to SAS7BDAT files.

25596: WPS on Linux now supports Sybase IQ 16.0 client drivers.

There are number of other fixes that are probably more important than the two I chose above (especially if you are on MVS).

You can upgrade your installation by going to the WPS Website and logging into the download servers (User ID and Password required.) You can also read a list of all the changes by clicking on the change log file on the right hand side of screen.

 

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.

Posted in SAS Replacement, Support | Tagged , | Comments Off on WPS v3.2.2 Released

Introducing WPS Express

Today, World Programming LTD announced the availability of WPS Express. WPS Express is a product for those interested in learning the Language of SAS. WPS Express comes with all the database drivers and other modules of the Standard desktop version of WPS.

What separates WPS Express from the Standard Edition desktop experience is the number of records that can be processed. Currently, WPS Express processes 100 records.

What WPS Express is meant be is a free product that allows you to learn the Language of SAS. As such, 100 records are probably sufficient to learn to program in the language, connect to many different databases, and run R.

One other caveat is that WPS Express is licensed to an individual and not to any organization. Again, it’s worth noting that this is a product to learn how to write code in the Language of SAS. Also, WPS Express is licensed on an annual basis so you will have to renew your license every year.

You can find WPS Express by going to the World Programming website and taking a look at: https://www.worldprogramming.com/try-or-buy/wps/editions/express

If you are interested in a more formal WPS training, especially on how to use the WPS Workbench, I recommend that you reach out to Art Tabachneck. Art has a placement company called Analyst Finder that helps companies and recruiters find analytical talent. Art also has a one-day training seminar and he can do the training online. I’ve seen the syllabus and slide deck and think it’s quite complete with regards to getting a thorough understanding of the power of WPS. Interested parties can reach out to Art at: art297@rogers.com

WPS Express, due to its 100 record limitations is not a practical product to use for evaluating whether to swap out SAS for WPS. Every organization would need the standard edition to process an unlimited number of records so that they could compare output of the products.

MineQuest Business Analytics is able and willing to help you and your organization with your evaluation of WPS. We can arrange for a free 30-day evaluation of the workstation products, both OS X and Windows as well as on all supported server platforms.

Interested in a quote or a free 30-day evaluation of the standard edition of WPS? If your organization is located in North America, simply fill out the Evaluation Request from our website.

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.

Posted in Business Intelligence, Eclipse, Licensing, SAS Replacement | Tagged , , | Comments Off on Introducing WPS Express

PROC REG WPS v3.2–New Graphics and PMML

So, those of you who have downloaded WPS v3.2, there are a number of new features. I want to show two new features using PROC REG. WPS now has the ability to create plots for PROC REG. Quite handy indeed!

Also, in Proc REG for v3.2, we see experimental support for PMML (Predictive Model Markup Language).

Here is some sample code that demonstrates the plots.

*–> Data is census population data from 1790 to 2010;
data census;
   input year pop @@;
   pop2 = Round(Pop/1000000,.1);
   popsq=pop2*pop2;
   lpop=lag(pop2);
cards;
1790 3929214 1800 5308483 1810 7239881 1820 9638453 1830 12860702 1840 17063353
1850 23191876 1860 31443321 1870 38558371 1880 50189209 1890 62979766 1900 76212168
1910 92228496 1920 106021537 1930 123202624 1940 142164569 1950 161325798
1960 189323175 1970 213302031 1980 236542199 1990 258709873 2000 291421906 2010 308745538
;;;;
run;

*–> PROC REG with the PMML attribute to output the model in PMML form.;

filename outfile ‘c:\temp\regpmml.txt’;
Proc Reg data=census outpmml=outfile pmmlver=”4_2″ plots;
model pop2 = year lpop;
Title “US Census Population – PROC REG”;
run;

 

US Census Population – PROC REG
The REG Procedure
Model: MODEL1
Dependent variable: pop2

Number of Observations Read 23
Number of Observations Used 22
Number of Observations with Missing Values 1

Analysis of Variance
Source DF Sum of Squares Mean Square F Value Pr > F
Model 2 206768 103384 9307.59 <.0001
Error 19 211.04266 11.10751    
Corrected Total 21 206979      

Root MSE 3.332793 R-Square 0.998980
Dependent Mean 111.704545 Adj R-Sq 0.998873
Coeff Var 2.983579    

Parameter Estimates
Variable DF Parameter Estimate Standard Error t Value Pr > |t|
Intercept 1 -299.75395 71.30929 -4.20 0.0005
year 1 0.16607 0.03878 4.28 0.0004
lpop 1 0.97176 0.02754 35.28 <.0001

ResidualPlot2

DiagnosticsPanel3
 

The PMML output generated is:

<?xml version=”1.0″ encoding=”utf-8″ ?>
<PMML version=”4.2″ xmlns=”
http://www.dmg.org/PMML-4_2″>
    <Header copyright=”World Programming Limited 2002-2015″>
        <Application name=”World Programming System (WPS)” version=”3.2.0″/>
    </Header>
    <DataDictionary numbeOfFields=”5″>
        <DataField name=”year” optype=”continuous” dataType=”double”/>
        <DataField name=”pop” optype=”continuous” dataType=”double”/>
        <DataField name=”pop2″ optype=”continuous” dataType=”double”/>
        <DataField name=”popsq” optype=”continuous” dataType=”double”/>
        <DataField name=”lpop” optype=”continuous” dataType=”double”/>
    </DataDictionary>
    <RegressionModel functionName=”regression” targetFieldName=”pop2″>
        <MiningSchema>
            <MiningField name=”year”/>
            <MiningField name=”lpop”/>
            <MiningField name=”pop2″ usageType=”target”/>
        </MiningSchema>
        <RegressionTable intercept=”-299.753951850233″>
            <NumericPredictor name=”year” coefficient=”0.166074316077245″/>
            <NumericPredictor name=”lpop” coefficient=”0.971762137737628″/>
        </RegressionTable>
    </RegressionModel>
</PMML>

Interested in a free 30 day evaluation of WPS? If your organization is located in North America, simply fill out the Evaluation Request from our website.

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 a authorized reseller of WPS in North America.

Posted in MineQuest Business Analytics, SAS Replacement, WPS V3 | Tagged , , | Comments Off on PROC REG WPS v3.2–New Graphics and PMML

CleanWork for Windows

Recently, we decided to go back through some of our older programs and take a look at them and see if they could be updated and/or made open source. We wrote Cleanwork years ago and we often provided it to organizations that used our consulting services as a freebie and a way to say “Thank You.”

CleanWork does pretty much what the name says. It is a WPS program that when run, will clean out the work folders of old and orphaned directories that are no longer used. WPS comes with a cleanwork program for Linux and Mac but not for Windows. The version written by MineQuest will run on Windows Workstations running Vista, 7, 8, 8.1 and 10. It will also run on Windows Servers such as Windows Server 2008, 2008 R2, 2012 and 2012 R2. Basically, it will run on all Windows Servers except 2003 and before. It also runs on all Windows Workstations except XP and before.

Cleanwork is packaged in a zip file that contains the source code, the Usage Document, License and a sample program. Cleanwork has been tested to execute only on the WPS platform.

If you are running WPS on a Windows Server you may want to set cleanwork to run on a schedule. This is a perfect utility to automate and run on a regular schedule. For busy server installations, I could see setting a scheduler to run cleanwork every few hours.

The zip file contains five files. These are:

clean.sas – a sample program for running the cleanwork utility.

cleanwork_source.sas – the actual source code that implements the utility.

CleanWorkUsage.docx – a Microsoft Word document that explain how to use cleanwork.

SASMACR.wpccat – a compiled version of the macro that  is ready to run.

license.txt – The license agreement for use of the source code and user document.

You can find the download by going to the bottom of the page here.

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.

 

 

 

Posted in Code Tips, Licensing, WPS | Tagged , , , , | Comments Off on CleanWork for Windows

New Software added to the Stack

 

Here is some cool software that I’ve started using during 2015.

Places

Here is a cool tool if you find yourself pushing data all around. From server-to-server, cloud-to-server or anything in between. CoffeeCup software has a nifty utility called Places. It can read and write to Amazon Cloud Services, OneDrive, Box, Dropbox, Google Drive, Instagram and Flickr. I picked it up on a weekend sale for $9. Well worth it.

CrashPlan

Crashplan is one of the best pieces of software we have at the house. We back up our Windows tablets, PC’s and Mac’s onto a small PC with a large hard drive. It’s very easy to install and there are options that allow you to back up the target PC on to a portable drive or even to the cloud (which is an additional expense, but still quite reasonable.)

Microsoft Office 16

I use Office all day long. I love it and Office 16 has raised the bar even further. I’ve been loathe at using OneNote but have finally started to use it since it syncs so well across so many of my devices. I use Word and Excel extensively and really don’t see a single issue since I upgraded from the previous versions.

Skype – Skype is just about the best communications system I use. I make phone calls, video calls and text. Buying a subscription with a phone number gets you one step further towards being able to work remotely and not having to use a damn cell phone.

Skype is improving and becoming more robust with each iteration. New features seem to be aimed at the enterprise market but I suspect we will see some of these trickle down to the small business market very soon. The ability to do a web conference similar to Webex will be a big boon for small business customers and software developers working from home.

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.

Posted in Web Conferencing, Windows | Tagged , , | Comments Off on New Software added to the Stack

Richmond, CA Hackathon – Meeting of the Minds

On the weekend of October 17-18th the Meeting of the Minds Civic Hackathon will take place in Richmond, California.  Amongst the various tools and facilities that will be available for the Hackathon, World Programming will be providing WPS software (www.teamwpc.co.uk/products/wps ) and support for any SAS programmers taking part in the event who would like to create and run programs in the language of SAS. The WPS software will be available on a server provided by Cisco and also for installation onto your own workstations running Linux, OS X or Windows.  Teams who use WPS software at this event will be given a license at no cost, and can use the product and all of its features for an additional 6 months after the event.

There will be data sets that can be used to create civic oriented applications and the data is categorized into Economic Development, Public Spaces, Health and Environment, Sustainability, Digital Divide and Education. So there is plenty of data available for a myriad of subject matter experts to use.

There is a $5,000 cash prize from Qualcomm awarded to the winner.

More information on the Hackathon can be found at: http://tinyurl.com/p6ymuot

 

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.

Posted in Business, Business Intelligence, Linux, OS X, Vertical Market Applications, WPS Evaluation | Tagged , , , , | Comments Off on Richmond, CA Hackathon – Meeting of the Minds

Macro Catalog Compatibility

Here’s something rather interesting that I discovered earlier today. If you create and compile a macro catalog on say Windows, you can simply copy that catalog onto Linux or Mac OS X. The compiled catalog is now accessible on all the x86 WPS supported platforms.

Think about how important that can be. If you are a developer and want to be sure that your catalogs are portable across x86 platforms, then you are in good shape with WPS. Think of the cost savings. With WPS, you could create compile and distribute on x86 systems. In contrast, our competitor would require you to purchase a Linux and Windows version of there software to do the same.

‘nuff said!

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.

Posted in Business, Business Intelligence, Licensing, Linux, OS X, Windows | Comments Off on Macro Catalog Compatibility

Tucson – Western Office

We’ve finally made the move to Tucson and are getting ready to move into new office space in the next few weeks. We are still finalizing some of the corporation issues but we have made some progress. Moving a business is never easy! I thought it would be interesting to share with some of my readers what we have discovered about Tucson as a place for small business and emerging technology businesses.

First, it’s pretty well known nationally that the city of Tucson, and to some degree Pima County is not very embracing and welcoming when it comes to small business and technology businesses. There are a few exceptions to this and I want to point out two of these at the very beginning. Thryve and StartUp Tucson are very hands-on and welcoming. These folks have a plan and great ideas. They deserve a lot of support.

The reputation of Tucson for not being business friendly is well known. There are lots of folks who have left the Tucson area and migrated back east. They are quick to talk about the raw beauty of Southern Arizona as well as how terrible the business climate is in the area. Much of the blame seems to be around a very welfare centric government, higher than average union memberships, highest sales taxes and property taxes in the state of Arizona and an alarming lack of good leadership.

It’s a common refrain among the folks I have met here who have migrated to the Tucson area that you either bring your job or bring your money. The meaning behind that is the job scene here is pretty poor so you need to have a job that is portable – where you can basically work from anywhere. The bring your money part of it means you need to be wealthy enough to move here as in being a retiree because it’s slim pickings otherwise. Which has some ramifications if you are married and your spouse needs to find a job.

When was the last time you saw an advertisement in Fortune, Forbes, or Bloomberg’s Businessweek on the virtues, attractions and compelling reasons for locating your business to Southern Arizona?

Issues surrounding education are enormous here. We have discovered that the politicians and ruling elite (currently a democrat majority) and specifically referring to the Mayor, City Council and Pima County board of Supervisors are anti-education. Strange as that sounds, the facts are there.

TUSD which stands for the Tucson Unified School District is generally just awful. I have not yet met anyone who sends their child to a TUSD school. The priorities expressed are so out of whack with reality that it’s kind of entertaining. Everyone we have met here sends their children to a charter school (Basis Tucson) or to a private school. TUSD is widely viewed as being inferior at every level including curriculum, teachers, superintendent and school board. Once you earn that reputation, it’s really hard to shake it. It tends to follow you for decades.

The Tucson political elite tends not to support higher education either. Even with the University of Arizona in the city, Tucson shuns any venture supporting higher education. Grand Canyon University was very interested in building a major campus in Tucson. GCU is a private school that has a religious orientation. Building a campus in Tucson would have meant hundreds of good paying jobs at occupational levels from janitorial and maintenance to faculty positions. However, the city council torpedoed this, in large part by council member Regina Romero. It just defies any logic how this once in a life time opportunity was wasted by the (ignorant) elite running this town.

As further evidence of the anti-education mentality by the elected elite, one of the very first considerations to stave off an operating deficit at the county level was to shut down a number of library branches. What consideration was given to reducing hours on weekends or create summer hours? Instead, it was the heavy handed threat to just shut down these branches. I have to wonder if the idea is a back handed attempt to keep certain patrons from reading and learning about how bad the local government is instead of offering a high quality service.

Pima Community College is another horror story. Having just been removed from probationary status after two years with the possible loss of accreditation. Still in question is the quality of the education, the college readiness of students who enroll at PCC and the faculty in particular.

Tucson is said to have the 5th highest poverty rate in the country as reported by CBSNews. I suspect that the city elite has not recognized or correlated that education and poverty are highly related. That would be a very simple observation to make for even the most casual observer. The public school system is so badly managed they can’t even attract teachers to fill 200 open positions. Low salary and miserable conditions are often cited as reasons for so many unfilled vacancies. At least that’s what I hear when I talk to some of the local business people. TUSD has to recruit teachers from outside of the state, in part because the districts reputation is so awful.

There have been some gains made in Tucson. Comcast is opening a call center in the area will employ around 1100 people. There has also been an announcement in the last year about some warehousing and distribution jobs being created as well. Let me say, any new jobs are welcome and I have to applaud Comcast for opening a call center here, but Tucson needs jobs that are better paying than what is typically found at call centers and warehouses.

Tucson seems to move from one crisis to another. Tucson never really appears to solve a problem but instead offers to kick the problem down the road by considering additional research or offering to fund a feasibility study on a given project. Long term problem solving and positioning the area for future growth is not a strong forte demonstrated by city or county leadership.

My advice, if you are considering moving or opening a business in Southern Arizona is to do your homework. Unless it’s absolutely necessary, don’t locate in Tucson proper (meaning the incorporated areas of Tucson). Take a look at the Catalina Foothills, Oro Valley and Marana as your future home base. These three communities seem to have the highest quality of life, income and education attainment in the area. They also have the best elementary and high schools. There’s plenty of quality office space in these areas. If you do a lot of sales online in Arizona (hence you have Arizona sales tax) the Catalina Foothills is probably the place to be. Two other areas that deserve mention but I have not yet researched these communities are Green Valley and Sierra Vista. Depending on their tax base, educational infrastructure and distance from other communities, they may be worthy of consideration.

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.

Posted in Business, Consulting, Legal, Other | Tagged , , | Comments Off on Tucson – Western Office

Why WPS needs to be part of your Corporate BI Stack

Recently, I’ve been talking to a few customers about why they decided to bring WPS into the company. After all, these firms have lots of money and talent. They can pretty much license any software they feel they need as long as it gets the job done. Of course, there are constraints due to pricing and training, but for the most part, these companies have free reign.

Below are the four major topics that everyone has touched on. Remember, these are large firms that are stalwarts in the analytics field offering products and services that are dependent on their IT and business staffs to generate revenue.

Innovation

WPS is rapidly growing and introducing additional procedures to the product. The customers that I have spoken with have all stated that WPS contains all the PROCS that they need to access, analyze and report on the data. Remember, we are talking about Fortune 500 companies here so that says a lot about how fleshed out the product is at this point.

Efficiency in Licensing

If you are a large corporation, it is likely that you have offices overseas. Licensing WPS is a dream compared to our competitors. There’s no multiple sales teams to have to work with and no differentiated licensing.

Also mentioned was that ALL the library modules are included in the price. There is no longer any confusion on what is part of the product.

Cost Reductions

It’s well known that WPS is a high value low cost alternative to the SAS System. Whether considering expanding the footprint with workstations or servers, WPS is an extremely competitive proposition. This is especially true on the server side. Since WPS is priced so competitively, even small workgroups can easily afford a server for their department.

Sole Source provider

One of the most interesting responses I received, and one that caught my attention (especially from a risk mitigation perspective) was that they didn’t want to find themselves beholden to a single source supplier of the language. I asked why they were concerned about that issue specifically. The three major points brought up are:

  1. They lacked flexibility in how they could use the product to deliver data, analytics and reports to their customers.
  2. They could take advantage of new concepts and features as they are introduced across two platforms.
  3. Fear that they would be held hostage in pricing negotiations. With a multiple providers, they felt they had leverage if they chose to not expand their footprint with the sole source provider.

 

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.

Posted in Business Intelligence, Pricing, SAS Replacement, WPS, WPS Evaluation | Tagged , , , , | Comments Off on Why WPS needs to be part of your Corporate BI Stack