MineQuest Downloads

Download programs, macro's and U.S. Census and Economic data in WPS data sets for Windows.

MQBatch

Macro Tools for WPS v2

Data Sets

WPS2R Macro

 

Macro Description	Macro Download
WPS2RBridge.zip - is a set of macros and sample programs that allow WPS users to execute R code from within the WPS WorkBench and return the results from R (both log and output) into the appropriate WPS log or listing window. Released: 3/3/2008	New Version!   WPS2RBridge.zip    (467 KB)   WPS2R Install Guide.PDF (450 KB)

     MQBatch Files

Download all four files below to a directory on your server. Take a look at the MQBatchFlowChart.pdf to get an idea of how MQBatch operates and be sure that you read the MQBatch Installation Guide before attempting an installation.

 

File Description	File Download
Creates the directory structure that is necessary to run MQBatch. Also contains the scripts, CMD files, and test programs. Updated: 6/22/2007	DirectoryInstall.zip (9 KB)
The .Net program that runs on the server and submits the users source code to the correct analytics program (SAS or WPS). This has been updated to allow LOG and LST files to be written back to the users PC. Updated: 6/22/2007	MQBatchv1b.zip (229 KB)
MQBatch Installation Guide gives step-by-step instructions on installing MQBatch on the server and the scripts that are required by UltraEdit. Updated: 6/22/2007	InstallGuides.zip (291 KB)
A simple flow chart that shows a high level view of how MQBatch operates on a desktop and server.	MQBatchFlowChart.pdf (12 KB)

      Macro Tools for WPS v2

Online HTML help can be accessed at: Macro ToolKit Help Files

A complete compilation of all the macro programs and PDF files in zip files for easier downloading. You can download individual macros and descriptions if you are not interested in having the complete compilation.

       Complete Compilation of all Macro Files

Macro Description	Macro Download
MacroToolkit.zip - Contains all the macro programs that are part of the MineQuest Macro Toolkit. Released: 6/20/2007	MacroToolkit.zip     (31 KB)
MacroToolKitPDF.zip - Is a Zip file that has all the PDF Files that document each individual macro program. Released: 6/20/2007	MacroToolkitPDF.zip    (488 KB)

       Financial Functions

Macro Description	Macro Download
Compound - This macro calculates the future value of an investment when interest is a factor. Released: 6/11/2007	Compound.SAS   (3 KB)   Compound.pdf     (25 KB)
DepAmt - This macro calculates the amount depreciated within a given year for a depreciating investment. Released: 6/12/2007	DepAmt.SAS   (3 KB) DepAmt.pdf     (24 KB)
DepRate - This macro calculates the annual depreciation rate of an investment. Released: 6/12/2007	DepRate.SAS   (3 KB)   DepRate.pdf     (25 KB)
LoanInt - This program calculates the rate at which interest is being charged on a loan. Released: 6/13/2007	LoanInt.SAS   (3 KB) LoanInt.pdf     (25 KB)
LoanPmt - This macro calculates the amount required as regular payments in order to repay a loan over a specified time period. Released: 6/13/2007	LoanPmt.SAS   (3 KB) LoanPmt.pdf    (25 KB)
LoanPrin - This program calculates the initial amount borrowed on a loan. Released: 6/14/2007	LoanPrin.SAS   (3 KB) LoanPrin.pdf    (24 KB)
LoanTerm - This macro calculates the period of time needed to repay a loan. Released: 6/14/2007	LoanTerm.SAS   (3 KB) LoanTerm.pdf    (25 KB)
SalvageValue - This macro calculates the salvage value of an item at the end of a given year. Released: 6/15/2007	SalvageValue.SAS   (3 KB) SalvageValue.pdf    (25 KB)

       Math and Statistical Functions

Macro Description	Macro Download
Comb - The COMB macro computes the number of combinations given n elements taken x at a time. Released: 6/16/2007	Comb.SAS    (3 KB) Comb.pdf      (19 KB)
Fact - Computes a factorial. Released: 6/16/2007	Fact.SAS     (3 KB) Fact.pdf      (16 KB)
Perm - The PERM macro returns the number of permutations given n elements taken x at a time. Released: 6/16/2007	Perm.SAS    (3 KB) Perm.pdf      (19 KB)
ProbChi - The ProbChi function calculates the tail-end value for points on a chi-square X2 distribution curve. 1 Released: 6/16/2007	ProbChi.SAS    (3 KB) ProbChi.pdf     (22 KB)
ProbF - This macro calculates percentile values on an F-distribution curve. 2 Released: 6/16/2007	ProbF.SAS    (3 KB) ProbF.pdf     (21 KB)
ProbT - This macro calculates right-tail values for points on a t-distribution curve. 2 Released: 6/16/2007	Probt.SAS    (3 KB) ProbT.pdf    (21 KB)

        Notes:   ¹. The computational precision of the ProbChi algorithm is limited to approximately 10^-7.

                     ². The ProbT and ProbF distributions are approximated.

        Macro Procedures

Macro Description	Macro Download
BarChart - The BarChart macro invokes the Google Chart API to create a vertical or horizontal bar chart in your browser. Released: 12/16/2007	BarChartMacro.SAS      (5 KB) BarChartTestPgm.SAS  (5 KB)
PieChart - The PieChart macro invokes the Google Chart API to create a 2-D or 3-D chart in your browser. Released: 12/12/2007	PieChartMacro.SAS      (5 KB) PieChartTestPgm.SAS  (5 KB)
Rank - The RANK macro produces ranks for a single numeric variable. Released: 6/19/2007	Rank.SAS   (13 KB) Rank.pdf     (30 KB)
WPS2XML - The WPS2XML macro creates an XML file from a WPS dataset and optionally a DTD file and a Schema. Released: 6/19/2007	WPS2XML.SAS   (18 KB) WPS2XML.pdf    (43 KB)

       State and Zip code Functions

Macro Description	Macro Download
FipName - The FipName macro takes a two character State FIPS code and returns the state name in all upper case. Released: 6/20/2007	FipName.SAS    (4 KB) FipName.pdf     (20 KB)
FipNamel - The FipNamel macro takes a two character State FIPS code and returns the state name in upper and lower case form. Released: 6/20/2007	FipNamel.SAS    (4 KB) FipNamel.pdf     (17 KB)
FipState - The FipState macro takes a two character State FIPS code and returns the two character state postal code. Released: 6/20/2007	FipState.SAS    (4 KB) FipState.pdf      (17 KB)
StFips - The StFips macro takes a two character postal code and returns the two character state fips. Released: 6/20/2007	StFips.SAS    (4 KB) StFips.pdf      (18 KB)
StName - The StName macro takes a two character postal code and returns the state name in all upper case characters. Released: 6/20/2007	StName.SAS    (4 KB) StName.pdf      (18 KB)
StNamel - The StNamel macro takes a two character postal code and returns the state name in all upper and lower case characters. Released: 6/20/2007	StNamel.SAS    (4 KB) StNamel.pdf      (21 KB)
ZipFips - The ZipFips macro takes a five character zip code and returns a two character state FIPS code. Released: 6/20/2007	ZipFips.SAS    (7 KB) ZipFips.pdf    (19 KB)
ZipName - The ZipName macro takes a five character zip code and returns the state name in upper case. Released: 6/20/2007	ZipName.SAS    (8 KB) ZipName.pdf    (20 KB)
ZipNamel - The ZipNamel macro takes a five character zip code and returns the state name in upper and lower case. Released: 6/20/2007	ZipNamel.SAS    (8 KB) ZipNamel.pdf    (20 KB)
ZipState - The ZipState macro takes a five character zip code and returns a two character state Postal code. Released: 6/20/2007	ZipState.SAS    (7 KB) ZipState.pdf    (19 KB)

Data Sets

Below are a few datasets that contain U.S. Census Data in WPS format for Windows.  You will need a copy of WPS to read these data sets. As part of our SAS to WPS conversion services, we will be including these data sets to our clients. These data sets are to serve as replacement datasets for what SAS distributes with their U.S. installation of the base product.

File Description	File Download
U.S. Census 2000 County Population Data in WPD format for Windows. Contains the best population data from the SF1 Census file with only County level geography selected. Contains 3,219 County level records.	US_County2000.zip   (1.1MB)   File Description US County2000.zip   (pdf)   SF1 Census File Description (pdf) 5.2MB
U.S. Census 2000 City/Places Population Data in WPD format for Windows. This is an enhanced data set that is analogous to what SAS ships as uscity.sas7bdsat but contains many more useful variables. Contains 25,375 records.	US_CityPlaces2000.zip     (5.2MB)   File Description US_CityPlaces2000.zip   (pdf)   SF1 Census File Description (pdf) (5.2MB)
U.S. Civilian Unemployment Rates from 1/1/48 thru 3/1/07 in WPS format. The data is seasonally adjusted and monthly in nature. Source: St. Louis Fed and Bureau of Labor Statistics.	US_UnemploymentRates.zip (4K)
NAICS 2002. The North American Industrial Classification System. This WPS data set has 2,346 observations that contain the NAICS Code, NAICS Description, and the code type, i.e. if it is a 2, 3, 4, 5, or 6 character NAICS code.	NAICS2002.zip  (29K)