SAS Address Cleaning Program

A while back I created a SAS program to clean U.S. addresses.  While not the most elegant thing in the world, it gets the job done (for the most part).  The SAS address cleaning program uses regular expressions to clean the addresses and they have placed in a separate include file.  Both of these files have been placed in a zip file which can be found here: SASAddressClean.zip.  Don't forget that I also created a similar program in C# which can be found here: CSharp_SelfInflictedProject_AddressCleaning.pdf.

Teiid (and related software) Installation Instructions

Here are my notes on how I installed and tested Teiid, the data virtualization software, on my laptop.  These instructions include additional information on how to install Eclipse, JBoss, Apache Spark, Apache Maven, Scala, etc. as well as how to test JDBC connections to Oracle and SQL Server using their specific JDBC drivers.  I also include an example on how to create your first virtual database as well as how to access it from within Microsoft Access.  Note that I'm not at master of this topic, so please consider these instructions as "alpha"!!!  Click here to download the installation instructions.  Please let me know if you want anything added or changed!

Android Programming Primer

I finally got around to learning and writing about Android programming.  Although I still have a lot of learning to do, this book may help a beginning Android programmer through some tough times.  Please visit Amazon.com and search for the Kindle eBook "Android from A to D:SECOND EDITION" or click on this link: Android from A to D. 

If you have already purchased the book -- THANK YOU!  As I stated in the book, Chapter 32 (renumbered to Chapter 99) as well as all of the appendixes have been placed in a freely available document downloadable here.

I have also created text files containing all of the code examples throughout the book. If you have the FIRST EDITION, the code is available here, and if you have the SECOND EDITION is it available here

Note that I have placed the Eclipse project for EquityYoStocks (the app used to demonstrate fragments) on Github here (https://github.com/sheepsqueezers/EquityYoStocks).  You should be able to download a zipped file to your desktop, unzip it, and then open it up in Eclipse. I'm no git guru, so if it doesn't work, let me know!

You can get a copy of this book from Amazon here.

 

Poor Man's Data Dictionary Files

Thank you for purchasing my book "Poor Man's Data Dictionary."  As promised, here are the web pages, templates and SQL code from the book as a compressed (.zip) file.  Click here.  Please, make sure to run your virus software on this file before using it! 

You can get a copy of this book from Amazon here.

 

SPSS Lecture Series

The SPSS Lecture Series is complete and consists of the following lectures:

  1. Programming SPSS

You can find this lecture by clicking on the Slidedecks link on the left and then clicking on the SPSS Presentations link, or click here.

 

Elements of Algebra by Leonhard Euler

After downloading a copy of Leonhard Euler's Elements of Algebra for Kindle and getting a really bad optical character recognition (OCR) version with all of the formulas screwed up, I decided to create a Kindle-friendly version as well as a print version of the book.  Both are available on Amazon and appear in the advertisements frame at the right of the home page.  The ISBN-13 number is 978-1508901181.   Here is the info from the back cover of the book:

This book, originally published in 1765, is a gentle introduction to algebra by one of history's greatest mathematicians, Leonhard Euler. Starting with basic mathematical concepts such as signs, fractions, powers and roots, logarithms, infinite series, arithmetic and geometric ratios, and the calculation of interest, Euler then discusses how to solve equations of varying degrees, methods of rendering certain formulas rational, and more. In 1771, Joseph-Louis Lagrange included an addendum to the French edition containing topics such as continued fractions and Diophantine equations.

This edition of Elements of Algebra was completely re-written using Microsoft Word and its Equation Editor over the course of several months and is not just another scanned copy of John Hewlett's original English language translation. This new edition contains Euler's Part I (Containing the Analysis of Determinate Quantities) and Part II (Containing the Analysis of Indeterminate Quantities), Lagrange's Additions as well as all of the footnotes by Johann Bernoulli and others.

While much of the text remains the same as that edition, several changes were made to make it more accessible to the modern reader:

1. The words "shew" and "shewn" were replaced by "show" and "shown", respectively.

2. The original notation for continued fractions has been replaced with the more modern notation.

3. Several German-to-English and French-to-English translation issues were resolved.

4. While the order is the same as John Hewlett's English language translation, in order to give the work more space, each chapter now begins on its own page.

5. Several inline formulas were moved out-of-line to give the work more space.

6. Several errors in the formulas were discovered and corrected.

7. The word "formulae" was replace by "formulas".

8. The footnotes were moved to a Notes section at the end of the book.

9. The overuse of the comma in several places was brought up to modern standards.

It is my hope that by creating this new "modern" edition, a renewed interest will be generated for a work which certainly does not deserve to be forgotten, written by a brilliant mathematician considered "the master of us all".

You can get a copy of this book from Amazon here.

 

PHP5, Amazon API and Facebook Development

I finally had enough time to learn PHP5, some of the Amazon Product Advertising API as well as a little bit of Facebook Development.  I combined all of these technologies into one website I created called Top-Itz (http://www.top-itz.com) as well as a Facebook Application called topitzapp (http://apps.facebook.com/topitzapp/).  The goal was to give Facebook users of the app the ability to add their own Amazon Associate Tag (aka, Amazon Tracking ID) into Top-Itz.  Each night, Top-Itz randomly chooses a new set of users and generates links based on those Amazon Associate Tags.  If someone clicks your link and purchases the item, you get some $$$ from Amazon!  Woo-hoo!  As usual, I documented how I did this in one document called Programming Top-Itz with PHP5, Amazon API and Facebook.  Click on the Documents link at the left, then click on Web Documents, or click here.  Note that Top-Itz is no longer up-and-running, but much of the information available in this document is valid.

 

.NET Lecture Series

The .NET Lecture Series consists of the lectures listed below.  Please be aware that some of the namespace lectures have information taken from Microsoft's MSDN .NET documentation webiste.  No copyright infringement is intended and is solely there as a way to quickly jog my own memory.  With that said, all of the examples appearing throughout this lecture series are my own examples which I painstakingly coded, compiled and executed.

  1. ProgrammingI-Introduction to Object-Oriented Concepts
  2. ProgrammingII-Beginning C#
  3. ProgrammingIII-Advanced C#
  4. ProgrammingIV-1 System Namespace
  5. ProgrammingIV-2 System.Collections Namespace
  6. ProgrammingIV-3 System.Collections.Generic Namespace
  7. ProgrammingIV-4A System.Data Namespace
  8. ProgrammingIV-4B System.Data.Odbc Namespace
  9. ProgrammingIV-4C System.Data.Oledb Namespace
  10. ProgrammingIV-4D Oracle.DataAccess.Client Namespace
  11. ProgrammingIV-4E System.Data.SqlClient Namespace
  12. ProgrammingIV-4F System.Data.SqlTypes Namespace
  13. ProgrammingIV-5 System.Drawing Namespace
  14. ProgrammingIV-6 System.IO Namespace
  15. ProgrammingIV-7 System.Numerics Namespace
  16. ProgrammingIV-8 System.Text Namespace
  17. ProgrammingV-Introduction to LINQ
  18. ProgrammingVI-Introduction to Visual C# 2010 Express Edition

You can find these lectures by clicking on the Slidedecks link on the left and then clicking on the .NET Presentations link, or click here.  I am currently working on additional .NET lectures and will upload them once they are complete.  Also, don't forget to look in the Documents section under .NET Documents for my C# Self-Inflicted projects you might be interested in.

 

Oracle R Enterprise (v1.1) Presentation

Finally, I had the time to create a presentation on how to use Oracle R Enterprise (v1.1). Click on the Slidedecks link at the left, then click on Database Presentations, or click here.

 

SAS Lecture Series

The SAS Lecture Series is complete and consists of the following lectures:

  1. Introduction to SAS
  2. Intermediate SAS
  3. SAS Macros
  4. Advanced SAS

 You can find these lectures by clicking on the Slidedecks link on the left and then clicking on the SAS Presentations link, or click here.

 

Oracle R Enterprise (v1.1): Installation and Usage Guide

R is great! Oracle is great! Combine them together you get great-great because Oracle has created Oracle R Enterprise with the ability to take advantage of R features from within your powerful Oracle database! I created a document outlining what I went through to install Oracle R Enterprise (v1.1) and how to use it. Click on the Documents link at the left, then click on Database Documents, or click here.

 

R Lecture Series

The R Lecture Series is complete and consists of the following lectures:

  1. Non-Programming Introduction to R
  2. Programming I
  3. Programming II
  4. Graphics I
  5. Advanced Topics

You can find these lectures by clicking on the Slidedecks link on the left and then clicking on the R Presentations link, or click here.

 

Technology Lecture Series

The Technology Lecture Series consists of the following lectures:

  1. Google Offerings
  2. Introduction to Microsoft Project 2007
  3. Introduction to SharePoint

You can find these lectures by clicking on the Slidedecks link on the left and then clicking on the Technology Presentations link, or click here.

 

More Articles ...

  1. Compiling ROracle for 64-Bit
  2. Database Lecture Series