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);
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

*–> 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”;


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



The PMML output generated is:

<?xml version=”1.0″ encoding=”utf-8″ ?>
<PMML version=”4.2″ xmlns=”″>
    <Header copyright=”World Programming Limited 2002-2015″>
        <Application name=”World Programming System (WPS)” version=”3.2.0″/>
    <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”/>
    <RegressionModel functionName=”regression” targetFieldName=”pop2″>
            <MiningField name=”year”/>
            <MiningField name=”lpop”/>
            <MiningField name=”pop2″ usageType=”target”/>
        <RegressionTable intercept=”-299.753951850233″>
            <NumericPredictor name=”year” coefficient=”0.166074316077245″/>
            <NumericPredictor name=”lpop” coefficient=”0.971762137737628″/>

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.

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: – a sample program for running the cleanwork utility. – 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.




New Software added to the Stack


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


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 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.

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 ( ) 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:


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.

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.

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.

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.


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.

More Concerns about Tucson and the State of the Economy

In the last blog post, we discussed issues around opening a western office in Tucson, Az. I have received four emails and two phone calls about the blog post and whether we thought our experience should be construed as the “norm.” One caller who is local to Tucson (and God bless him for taking the time to call and discuss) explained at great length the disconnect between Tucson and the city of Phoenix and the declining quality of life in Tucson.

That conversation got me thinking about some parallel cities where the same thing seems to have happened. That is, the local economy went downhill and how peer communities viewed the situation. Take a look at Columbus, Ohio and Cleveland Ohio. It’s so similar to how Tucson and Phoenix view themselves that it’s Eeerrie (Erie, get it?)

Columbus is the state capital, lots of white collar jobs and some light manufacturing. Columbus is home to The Ohio State University and Battelle Memorial Institute. Battelle is the world’s largest privately held think tank and employs 22,000 people. It’s also home to a number of Fortune 500 companies.

Having lived in Columbus for 30+ years, I can tell you that the people viewed Cleveland as part joke and part social welfare entity that really didn’t do much for the rest of the state. Cleveland was (and still is) dominated by democrats who’s agenda was to disperse as much social welfare as they could get their hands on. Cleveland’s reputation was so poor in Columbus that there was little serious contemplation about how the state could help the city. It found itself in a downward spiral and still has not been able to reconcile its union bias and liberal leanings to the rest of the state or rest of the country.

Now let’s drive two hours east from Cleveland and see what has happened to Pittsburgh. If there’s any single city that can be called the comeback city, it’s Pittsburgh, Pa. Here is a city (actually the whole regional area) that took an economic hit that was devastating. The bottom fell out of the demand for domestically produced steel. The city was on the ropes in so many ways but found a way to remake themselves just to survive. And boy have they. They have become a tremendously prosperous city.

Pittsburgh remade itself by utilizing the local universities. Carnegie Melon and the University of Pittsburgh are both powerhouse research institutions. Along with Duquesne University, Pittsburgh became an education and research Mecca. People in Tucson, most notably Regina Romero should take note of this. My understanding from reading articles on the Web and talking to business owners is that Ms. Romero (a Ward 1 Councilor) was instrumental in undermining Grand Canyon University and submarined the universities decision to not locate in Tucson. They have located in Phoenix and have invested over $400 million dollars ($400,000,000) in buildings, classrooms, dorms, etc… Just think about how many local jobs this would have created for Tucson. Here again we have a liberal political body that just seems happy to live in the 5th or 6th poorest city in the country. It’s just total ineptness.

Supporters of Ms. Romero are quick to say this was a misstep on her part and the larger council. I have to disagree. My definition of a misstep is that a mistake took place, something was overlooked, that it was unintentional. This was a deliberate act and Ms. Romero and the larger council were all purposefully part of this decision. Btw, the city didn’t want to let go of a golf course called the El Rio Golf Course where GCU wanted to build. Anyone who has visited Southern Arizona knows that there is no shortage of golf courses in the area. But there is a shortage of is water and golf courses consume an incredible amount of water. Go figure what the real reason is here but I suspect that Ms. Romero and the council are pretty much against religious universities and this was their way of thwarting Grand Canyon University opening a religious based school in Tucson.

I want to point out to the powers that are in Tucson that there are huge benefits beyond just the economic when you bring in companies and universities that are highly educated. You see, many of these organizations have programs that encourage employees to get involved in schools. Many companies actually adopt schools. These folks come into the class room and discuss careers, they tutor students in math, science and reading, they teach business skills. These services you get for almost nothing. Perhaps just a handshake and a “Thank You.”

So what happened with Pittsburgh? Companies have flocked to the region setting up research centers and local offices. They all want to be part of the technology and growth that comes out of the area. Computer Science, Robotics and Health Research is a big piece of this and both CMU, University of Pittsburgh and the Pittsburgh region are well situated to take full advantage of this sector of engineering, manufacturing and science. If you have any doubts about Pittsburgh’s comeback and don’t want to spend days reading about it, check out this blog:

What is so interesting to me is how much Pittsburgh has cleaned itself up. The technology companies that are now in Pittsburgh are typically low environmental impact and high wage organizations. You still see some brown fields but those are quickly being eradicated. You don’t see smog like you did in the 60’s and 70’s and it’s a very pleasant place to live and visit.

For the city of Tucson and Southern Arizona, the loss of IBM and Grand Canyon University is irreversible. The horses have left the barn so to speak. Getting organizations like this to locate to your community are probably once-in-a-lifetime events. If opportunities like this do come up again, don’t blow it. If you do, Tucson is going to start looking like Flint, or Detroit Michigan.

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.

Possible Office Expansion – Westward Ho!

As a company, we’ve been looking at expanding our footprint to the Western United States. Some reasons for it are purely selfish, a few are health related and some of the reasons deal with doing business with organizations that are two or three hours different in terms of time with the Eastern United States.

I want to start writing a few blog posts about this endeavor. We’ve been looking at opening an office in Tucson, AZ and even though the geography is strikingly beautiful, the realities of opening a business in Tucson is strikingly difficult.

Tucson is not very business friendly.

True. This city is known for its open hostility to businesses. This is well known out in the Western United States but not so much back in the Midwest or Eastern U.S. Tucson is basically a resort town with a few limited large businesses. The large employers seem to be University of Arizona, Raytheon (a missile systems developer), a medical complex and City and County Government. Note how many of the mentioned are either government entities or are attached to government funding. In other words, they tend not to create or produce capital but instead consume capital.

University of Arizona (UA) is probably the jewel in the city. But what is sad is that the vast majority of students who graduate from UA, cannot find a job in Tucson. They are forced to look for work in Phoenix, Los Angeles and the State of Texas. I guess there’s nothing smarter than spending the money to educate them and then throwing them out of the nest to seek work and develop products elsewhere!

Taxes are a mess. We still have not figured out what kind of states sales tax we would have to charge if we opened a business in Tucson. Each jurisdiction has a different sales tax rate and figuring out what your jurisdiction is (Tucson incorporated, unincorporated, are you north or south of River Road) is really tough. We’ve called twice and gotten two different answers. It also seems that sales taxes or Transaction Privileges Tax can change from month-to-month. If you go to the website, you will see tax tables for February and March.

As a small business or mid-sized business, we don’t want to spend our time trying to figure out how much the privilege costs us to sell a product from month-to-month. Also, when you compete nationally as well as globally, taxes have a big impact on your customers. Taxes have to be passed through to the customer if you want to survive.

The Transaction Privilege Tax Sales taxes is very high. Local municipalities add their own tax on to the state tax and when combined can be astronomical! In Tucson, you pay 8.1% sales tax. Probably one of the highest in the country.

There’s also a huge disconnect between the politicians/bureaucrats and the small business owners here in Tucson. We’ve talked to lots of small and mid-sized business owners and upper level managers, and just about every person we’ve talked with has felt that city and county government is a significant hindrance to the success of Tucson and the business economy.

One thing that I can’t stand is for folks to criticize and not offer suggestions or some possible solutions to the issues. So here are a few to start the discussion.

Suggestions for Improvement

The City has to become more business friendly. They are not going to be able to grow or even sustain the current economy unless they can bring in business from the outside. They cannot grow the economy to the level they need by developing the existing businesses.

Create a One Stop Business Center where potential companies can go to get the correct answers on what taxes they have to pay, the amount of sales taxes they have to pay, the licensing that is required, and other filing requirements. The city and county should set up a little store front that is in conjunction with companies like Comcast, Bank of America, the phone company, Office Max/Office Depot where there is an all-in-one business center. Here you can find out what kind of licensing, permits and taxes that you will be required to attain and pay. The private sector companies can have a small footprint to help new and even existing companies find out about services that they will most likely need and to sign them up. What company doesn’t need internet and banking services? We have not been able to locate such a source and as such, feel that the risks are quite high that we would miss something and be liable for fines and penalties.

Tucson should take a look at neighboring communities and see what is working for them. We see a huge difference between Oro Valley or the city of Marana in contrast to Tucson in terms of business climate and health. We have been steered many times to these communities by realtors, lawyers and bankers as the place you want to be in locating a small or midsized business.

Accentuate the positive. Craft a national story about how the educational resources (UA) is an asset to growing technology businesses. Talk about what kind of research is being done at the local level and by small businesses in the area. Talk up success stories. Discuss the low cost to lease office space.

Advertise in major publications like Fortune, Forbes and Bloomberg about Tucson and the business opportunities and the resources available in Tucson.

Do something about the sour state of education in the area. Elementary and High School is poorly funded. Same goes for community colleges. As a matter of fact, we just learned that the state of Arizona has stopped all funding of community colleges except for one county. As a business owner, I don’t want to have pay to attract talent from other states and help pay relocation costs. Support for education has to become a priority over support for state prisons.

Take advantage of the contacts and expertise of the Snow Birds and other wealth that is located in the Catalina Foothills. There is some amazing wealth in the Foothills. We’ve met folks who have run and sold large businesses who spend time in the Foothills who are worth tens and hundreds of millions of dollars. They grimace and grin almost as if it’s sport at the missteps that the city and county have taken in the last decade or two as it pertains to creating a viable and sustaining local economy. These folks are amazingly well networked and have the ability to move businesses here as well as encourage businesses to locate here.

Poach businesses from other States. Property taxes are very low in Arizona. Businesses are sensitive to labor rates, real estate costs, property taxes and educational resources for their employees as well as for the growth of the business. Tucson needs to set up a highly visible group that does nothing but pursue large companies to relocate to the area. Start raiding California for the technology companies by offering tax incentives as well as building an environment for cross-pollination of ideas, networking, concierge services for new businesses, free site location services, seven day permit approvals, etc…


The two questions I have to ask Tucson is “Does a Liberal leaning political government mean that it has to be at odds over the creation of jobs or even synonymous with the lack of jobs? Is there a conflict over creation of wealth by attracting small and mid-sized businesses and does that inherently mean that there’s an ever expanding gap of those who have vs. those who have not?” It doesn’t appear to be that way for liberal cities like San Francisco or Seattle, but it does seem that way for Tucson.

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.

WPS on a Dell Tablet

One of the things I believe we all see is the tremendous emergence of mobile hardware and software. We see it on phones the most but we also see it on tablets. I’m very intrigued at the moment on tablets that can run Windows applications and has enough connectivity options to be able to use it in an office for taking notes, making presentations, etc..

About a year ago, I bought a Dell Venue 8 Pro running Windows 8 (now 8.1) with 2GB of RAM and internal storage of 32GB. I slipped in a 64GB Micro SDHC card for some additional storage. Today I would buy a 128GB card since prices have fallen so much instead of the 64GB card. I also bought a Dell Bluetooth keyboard for it as an accessory. The keyboard makes it much easier to use for any serious work rather than use the virtual or software keyboard.


The Dell Venue 8 PRO has an Atom 1.8GHZ Quad Core processor. It does amazingly well for the most part. The only issues I tend to notice is that sometimes there’s a slight hesitation using the browser and loading web pages. I’m not sure if it is the internet connection or the processor but it doesn’t happen enough to be too bothersome.

One of the really cool things is that it has Miracast technology built into the tablet. With Miracast, I can “beam” my screen to another screen, such as a TV or Workstation Monitor so others can see what is on the tablet. This is very convenient and Miracast works well. Especially if you are using Microsoft’s Miracast dongle.

Since I bought this as a Christmas present for myself (I needed a toy) I decided to load WPS on the tablet to see if I could actually get it to work and see if it is useable. I’m happy to report that it works quite well. Of course, the primary issue that prevents serious work on a large dataset is the small memory footprint. But that too can be overcome.

I like to take my tablet out on to the patio or to the pool early in the morning or in the late afternoons. At both places I have WiFi access so I can check email and browse the web. But using WPS Link (software that comes with WPS that allows you to connect to a server running WPS) I can submit my jobs to the server and run extremely large jobs. With WPS Link, I submit my code to the remote server and get the log and listing right back into the WPS Workbench.

Since the WPS installation package is relatively compact, taking only 342MB on my tablet, it is great that it takes so little space and Note that Windows 8.1 on the Dell Tablet is 32-bit so you need to install WPS 32-bit. I can still run and monitor any jobs or tasks that I have submitted. One nice thing with WPS Link is that I have the option of storing my WPS source programs either on the tablet or on the remote server.

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.