Blink 7

SQL for SAS Programmers - Part 1 - Extracting Data

The first part of this tutorial deals with using the PROC SQL statement to perform basic data extraction. Screenshots of the code and output are included. Readers who wish to follow along on their own systems or copy the code can download the files provided below (right click and select “save as” or “save link as”): (download) SAS Code for Tutorial Part 1 (download) SAS...

SQL for SAS Programmers - Introduction

What is SQL? SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS). A DBMS consists of one or more tables of data, typically joined in a hierarchical fashion, and a series of programs for organizing the data. Typical tasks performed with SQL code include the following: Retrieve (or query) data from one or more data...

Tutorial: Adding Hotlink Protection to Wordpress

What is Hotlinking? Hotlinking (also known as inline linking, piggybacking, leeching and bandwidth theft) refers to when one site links directly to an object on a second site. Typically, the object is a picture that can then be displayed on the linking site without the owner having to copy the actual file from the second site. How Hotlinking can Affect your Wordpress Blog Hotlinking not only allows...

SAS Tutorial: Creating Categories with PROC FORMAT

When performing data analysis on a cohort population, it is often desirable to categorize characteristics can have many values. Age, income level and credit card score are examples of population attributes that can be placed into “buckets” and easily analyzed based on broad categories (without having resort to linear or logistic regression). While variables can be quickly encoded using IF statements,...

SAS Tutorial: Loading Tab-Delimited Files

Imagine you are given a list of major Canadian political donators and wish to load it into SAS for further analysis. The list is in a text file with fields delimited by tab characters. SAS Enterprise Guide (EG) offers wizards to automatically import a variety of file formats, but using these GUI’s preempts the chance for automation or additional processing during import. Using code to load data...

Tutorial: Manually Adding Digg Support to Wordpress

What is Digg? Generally referred to as a social news site, Digg is technically a user-driven news aggregator. Registered Digg users can “digg” (i.e. bookmark and submit) an article on a web page by submitting a URL, along with a brief description. URL submissions are placed on display for other Digg users (registered or not) to read, comment on, rate, and bookmark for themselves. How Digg can...