Tag Archives: WPS V3

On ErrorAbend

One issue I always had with the SAS system as a developer was when I had a job that ran in batch that had an error. The SAS System would set the number of observations to zero and go into syntax checking mode for the remainder of the program.

This had some virtues but more often than not, the error was thrown because I had misspelled a variable name in a MEANS statement or FREQ statement that was used for checking my output. This would cause SAS to go into the syntax checking mode and all the rest of my program would not execute even though it was proper.

WPS, when running in batch doesn’t do this but if you want the same effect for your batch jobs, it’s easy enough to implement. Consider the following macro – called %ErrorAbend. %ErrorAbend simply checks that the program is not running in the FOREground and checks the value of the &syserr variable after every PROC or data step and if it returns a value of 3, then issues a note and sets the number of observations to zero.

%macro onerrorabend;
  %if %eval(&syserr eq 3) and &sysenv NE FORE %then %do;
     options obs=0;
     %put NOTE: WPS has been set with OPTION OBS=0 and will continue to check statements.
  %end;
%mend;

Below is a sample program that when run in batch, puts the system into syntax checking mode and basically stops the execution of any downstream statements.

data a b;
do ii=1 to 2000;
  x=ranuni(0)* 10;
  y=Round(ranuni(0),.01)* 100;
  z=round(ranuni(0),.01)* 10000;
  

  a=ranuni(0)* 10;
  b=Round(ranuni(0),.01)* 100;
  c=round(ranuni(0),.01)* 10000;
  
  e=ranuni(0)* 10;
  f=Round(ranuni(0),.01)* 100;
  g=round(ranuni(0),.01)* 10000;
  
  i=ranuni(0)* 10;
  j=Round(ranuni(0),.01)* 100;
  k=round(ranuni(0),.01)* 10000;

  output;
end;
run;

proc freq data=a;
tables ik;
run;

%onerrorabend;


proc means data=b;
run;

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 WPS vs SAS Pricing Comparisons on a Windows Server

We updated our server pricing comparison of WPS on a two, four and eight core server with SAS on the same hardware. We included the cost of the SAS/Toolkit (it’s included with WPS) in the comparison, but for many, it might not be something that is important for them.

At any rate, the figures are there so that an individual or an organization can subtract out the price if they so choose and see for themselves the pricing difference for the two products for the first year and a three year window. It’s pretty amazing how cost effective WPS is on a server in comparison to SAS.

You can view the document by clicking: Pricing_Comparisons_Between_WPS_and_SAS. (pdf ~467kb)

Don’t forget there’s still time to get into the action to win a Google Nexus 7 Tablet. If you register to take out a WPS evaluation before September 30th, 2012, you will automatically be registered in the drawing for the tablet. Certain conditions apply so read the the earlier blog post for all the details. You can request a WPS evaluation by going to the MineQuest Business Analytics website at the WPS evaluation page.

WPS 3.01 Now GA

Just a note to let you know that World Programming has released version 3.01. If you are running any older versions of WPS, I would suggest that you install the new release because of the bug fixes and a few new procedures.

This current version contains PROC REPORT, PROC DBLOAD and PROC RELEASE (for mainframe users). There are some significant performance improvements for PROC LOGISTIC and FASTCLUS.

Also, there are three new WPS data access engines. The new databases supported include Kognitio, PostgreSQL and Vertica. There’s also support for Bulk Loading for DB2 and Greenplum.

The number of database access engines that are included in WPS is pretty amazing. SAS Institute charges dearly for database access engines and I believe that’s a problem for shops that are looking to roll out Business Intelligence across the enterprise.

With the introduction of PROC REPORT, most Pharma organizations and CRO’s can move their SAS Language code base easily over to WPS. If I was running a CRO or doing the analytics work that required FDA approval, I would be taking a serious look at WPS in lieu of of the SAS System. It’s so cost effective, it could mean the difference in profitability for a small or mid-size CRO.

Finally, there’s still time to get into the action to win a Google Nexus 7 Tablet. If you register to take out a WPS evaluation before September 30th, 2012, you will automatically be registered in the drawing for the tablet. Certain conditions apply so read the previous blog post for all the details.

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

Bridge to R Study Edition now available

After giving some consideration to creating a Study Edition of the Bridge to R, we finally have put the package together. Starting on Friday, May 18th, you can request a download package for the Bridge to R SE to use to learn and experiment with using WPS.

The Bridge to R SE is limited to reading 1500 records from a WPS dataset and passing those observations on to R. This should be sufficient for testing your R programs running in WPS and to learn the language nuances of the Bridge to R.

For more information and download instructions, go to the Bridge to R SE page. There’s also a short video that shows what the Bridge to R can do for you.

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