Help! Why does the WHERE clause choke on the INPUT function?

A student brought in this coding problem after her manager was struggling with this issue for a while. They played guessing games, but to no avail. Here’s what happened when they submitted data step and proc sql code using a WHERE clause with an INPUT function? data aileen; length hcn […]

Post a Comment

Jedi SAS Tricks - These aren't the labels...

In the first Star Wars movie, Obi-wan uses Jedi mind tricks to convince the stormtroopers that the droids they see are not the droids they're looking for.  A colleague at SAS passed along a question from a SAS user where the column labels they were seeing were NOT the labels […]

Post a Comment

Producing normal density plots with shading

When teaching statistics, it is often useful to produce a normal density plot with shading under the curve. For example, consider a one-sided hypothesis test. An alpha value of .05 would correspond to a Z-score cutoff of 1.645. This means that 95% of a standard normal curve falls below a […]

Post a Comment

SAS tutorial: Create simple scatter plots with two variables using SAS

This SAS tutorial video will show you how to generate plots for two continuous numeric variables with Base SAS. Basic scatter plots, linear or curvilinear regression lines, confidence intervals or ellipses, and multiple plot overlays are demonstrated. To learn more about this topic, check out our SAS Programming 1: Essentials […]

Post a Comment

SAS tutorial: Print a simple listing with SAS

In this tutorial video, you will learn to print a simple listing with Base SAS. You see how to write a PRINT procedure step to display a SAS data set. You also see how to use statements and options to subset observations and variables and enhance the report.   Learn […]

Post a Comment

SAS tutorials: Filter and sort data in SAS

These two tutorial videos will show you how to filter and sort data in Base SAS. In this first video, you will learn to use a WHERE statement in Base SAS to filter or subset SAS data. Data sets can be very large and filtering data enables you to select […]

Post a Comment

SAS tutorial: Read a SAS data set

In this video, you learn how to use a SET statement in the DATA step to read a SAS data set using Base SAS. The DATA step is a very powerful tool for data manipulation. You can watch more video tutorials by visiting: support.sas.com/training/tutorial/. To learn more about the SAS […]

Post a Comment

Best cities to celebrate St. Patrick’s Day

In my younger years, I enjoyed celebrating St. Patrick’s Day in Savannah, GA. Did you know the city dyes the fountain water green and has a parade that attracts over 400,000 people? It is now time for me to find additional cities to celebrate the holiday. Based on the DriveTheNation […]

Post a Comment

SAS tutorial: Import a comma-separated file into SAS

In this tutorial video, you will learn how to read comma-separated-value (CSV) files with Base SAS using a DATA step. This enables you to create a SAS data set copy that transforms each field in the raw data file into a variable in the data set. Watch and learn how... […]

Post a Comment

Olympic graphs ... on steroids!

Michele Ensor recently posted a wonderful blog with a graph of the 2014 Winter Olympics medal count. I'm going to further refine that graph, making it an Olympic graph ... on steroids! :) Here is Michele's graph: First, let's give it a few simple cosmetic changes. I always like to have […]

Post a Comment