If you have spent anytime building SAS prompts for a stored process, then you might have noticed the prompts near the bottom of the list and wondered how anyone would use those or even need them. In a previous post, I showed you how to use the data l…
Category: SAS
Four ways to add row number in SQL Server
It is easy to sort any data in SQL Server, while it is not a trivial job to add a new variable of row number to an existent table. Here I come with four ways to realize the purpose.
/********** 0. Input data source *********************/
use…
Traffic report: the most visited posts of 2011
Lots of the visitors to this blog arrive here by way of Google search (welcome!). Thanks to search engines and a few well placed keywords, the same older posts (let’s call them “timeless topics”) seem to attract the most traffic from year to year. I hope that the searchers find […]
Performance help for customers running SAS on AIX
Back in September, I shared performance help for SAS 9 users who run on Windows 2008. At that time, I promised more insights from Margaret Crevar. Your next installment has arrived! For all the SAS customers running on AIX (5, 6, or 7), please note…
Self-assessments for SAS training courses
We all know SAS offers a rich variety of resources that help users to continuously build their skills. However one of the biggest questions plaguing SAS users is ‘where do I begin’ or ‘what’s next’. Considering the vast array of options t…
Impact Analysis – “Hawk Eyes” of SAS Data Integration Studio
As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in the database is linked up or imp…
Fat Fingers
I just looked at some code I had written a few months ago. It categorized things based on a bunch of criteria. At the end of the data step I output the categories that did not fit into a definition bucket nicely:if bucket in(12,11,10,7,6,5,4) then ou…
NOTE: 180 Terrific Ideas for Using and Learning the SAS System (Golden Oldies)
Continuing my mini-series of hints and tips from previous decades, here’s a paper from my first SAS Users Group International (SUGI) conference. The 18th SUGI (predecessor to today’s SAS Global Forum (SGF)) was held in 1993 in New York. Helen and Ginge…