Tag: tips and tricks

How SAS engines can read a range of data in Excel

Japan has a superfast train called the Shinkansen. The first I heard of it was when my sister visited Japan on a scholarship. Engine-awestruck, we wanted a ride, but weren’t able to get to Japan. Nor, did we know the language. (With over 5000 ka…

Jedi SAS Tricks: Custom Bookmarks

I was building a nice little PDF report the other day.  I love the way ODS PDF replicates the SAS Results window navigation structure as PDF bookmarks, but… I’d much rather write the text for the bookmarks myself.  So, I decided to &qu…

Why Can’t SAS Read My CSV file?

Many SAS users receive data in the form of CSV (Comma Separated Value) files, and need to convert them to SAS data sets. A typical record in a CSV file might look like this:Jeter,Derek,1995,,234,”22,600,000”

Note the following about the reco…

Is It Random or Repeated?

Last week, a student in my Mixed Models Analysis Using SAS class sent in the following text message during a discussion of crossover designs (sometimes known as ABBA designs, where factors vary within subjects, not ABBA designs where you’re like…

Possum Romance and Other Data Analysis Anomalies

Today I took my 3-year old, Elizabeth, to lunch at the on-site cafeteria. As she enjoyed some mac & cheese, we noticed a spot on the floor.

Elizabeth: What’s that, mommy?
Me: I don’t know, I think it must be where the rug got messed up …