New in 4.3, Web Report Studio users can directly report on data from OLAP cubes and data tables without the previously required information map. However, by default advanced users can only access OLAP cubes and information maps. Allowing direct access …
SAS vs R in data mining (1): challenges for SAS
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 …
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 (…