Category: SAS

NOTE: More on sorting and SQL

Further to my recent post on telling SAS that your data is pre-sorted, it’s worth mentioning the SORTVALIDATE system option. This yes/no option tells SAS whether the SORT procedure should verify if a data set is sorted according to the variab…

NOTE: What is PROC SORTT?

My friend and ex-colleague CB drew my attention to an intriguing thread on SAS-L recently. It asked “What is PROC SORTT” and drew a response from Paul Kent

At times we’ve issued “the same proc with a new name” as a way of allowing us to get feedb…

Special Request for Star Schema OLAP Cubes

When creating an OLAP Cube from a Star Schema table, the Dimensions / Hierarchies created must be free of all blanks. This is because the name is used as a table alias in the SQL Join.

The obvious error in the resulting code example below:
proc sql; c…

Find Documentation for Any Procedure

Q: I cannot readily reach data on specific procedures. What is the best way to find procedure documentation?

A: Try searching the SAS Procedures by Name and Product book. This document is available for SAS 9.2, but can be helpful for any SAS®…

Happy SAS Graphing!

I’m not a R user. Instead, I’m an observer. For example, I love the R Graph Gallery:
http://addictedtor.free.fr/graphiques/thumbs.php
As a SAS programmer, I also love Robert Allison’s SAS/Graph Examples and Michael Friendly’s SAS Graphic Programs and Macros (the only two SAS graph galleries available on website maintained by users):
http://robslink.com/SAS/Home.htm
http://www.datavis.ca/sasmac/
I used to be a casual user of SAS Graph. […]

What Superpower Would YOU Choose?

This was the question which occupied the 42 attendees at the Golden Horseshoe SAS User Group meeting on Friday morning during their networking break. As I walked around the room speaking with people, I caught snippets of SAS-related conversations bein…

World Statistics Day Meets Toronto Data Mining

Sometimes, if we step back and take a moment, it’s easy to appreciate how disambiguous the universe can be. As many statisticians will tell you, synchronicity occurs all the time in the world around us: unique cause and effect layers upon unique cause …