Sometimes SAS doesn’t shut down correctly and you get stuck with orphaned workspace. These orphaned workspace directories should be cleaned out now and again. You can run this code in SAS to find out where your workspace is and then go to the directo…
SAS truncates SQL columns to length 1024
At first I thought SAS was giving me errors because the input data was malformed. Before I found data entry operators typing invalid dates such as “3/30/33/2009″ : NOTE: Invalid argument to function INPUT at line 1248 column 26 NOTE: Mathem…
Dr. Goodnight and SAS in the news
I wanted to take a minute to share these two pieces of media that I discovered this week. In a video interview with Bloomberg’s Bernard Lo, Dr. Goodnight, CEO of SAS, talks about the emerging Asian market and about how SAS does business in Asia. …
Created my first SAS dataset without using SAS
Well, around 14 months ago, I started on a journey to understand the SAS dataset so I could read and write one independently. Originally, I needed the functionality for a client but it became an obsession to figure it out. Client work and personal matt…
Gliffy
Occasionally I like to sketch out data extraction flows, database schemas, use cases, etc. I prefer pencil and paper to the industrial strength tools like visio. But sometimes I need to share my little pictures and mailing my scratch paper just won’t…
PM Stories
These are stories I have collected over the years. i hope people enjoy.Project Managers In Practice (PIMP…sorry, PMIP)Our first story involves a young PM, new to the project and not very technicalOk, so I (senior consultant guy) have a project and th…