The past three years witnessed the rise of R, an open source statistical software. Search R related books in Amazon, and tons of recent titles show up ranging from graphics to scientific computation. Thanks to those graduates sprang out of school that …
Category: SAS
Use BYTE function to create special ASCII character, e.g. plus/minus sign
data _null_;      do i=0 to 255;            x=byte(i);            put i= x=;      end;      y=rank(‘a’);      put y=;run;BYTE function results:i=65 — 90 x=…
Pipeline Parallelism, time warps and a SAS Global Forum paper
Welcome to 2011! A new year, and for me, a new blog. My name is Michelle Buchecker and I have been using SAS since 1988. No, I’m not old, I can’t be. There must be just some weird time warp involved.
One of the aspects I love about my job i…
SQL tip – Inner join shorthand with USING
We write a LOT of SQL here and although SQL is a powerful database language, it can be tedious. So here is one tip for shortening all that typing. Typical join sytax: select some_columns from one_table join another_table on one_table.column_1 = another_table.column_1 and one_table.column_2=another_table.column_2 where some_column > someother_column ; Not too bad, right? In order for […]
A new year’s resolution that sounds like more fun than a spinning class
Last December I taught a SAS Programming 1: Essentials class at Statistics Canada (Statcan). My class could barely contain their mirth while I valiantly struggled to find the semicolon on the French keyboard. Far cry from my first move to Canada (…
Top 10 posts by views for 2010
So over the last 12 months the ranking for post views looked like (according to wordpress site stats, rather than google analytics): Post Views Home page 11,532 SAS BI Clients 4.3 and SAS 9.3 673 SAS EG 4.3 is here (but its hiding with Elvis) 533 SAS Articles 508 SAS Portlets for Sale 380 Making […]
Reporting Principles – TOGAF
On one of the projects we have been working on we were required to define some reporting principals using the TOGAF style. I had never used this style/methodology before, but found it great as it forced us to focus on describing these principles in a very succinct (saasinct way. We also found there was a wealth […]
10 tips for building a successful team or users group
Each time I attend a users group event, I’m amazed at the high caliber event that can be acommplished by volunteers in their spare time. I learned during a NESUG panel discussion that finding and motivating those volunteers may sometimes be diffic…