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…
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…
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…