By Eli Kling using sas V9.2/BaseFrom time to time the developers in Cary make an addition that excites even sas–dinosaurs like myself. Not everyone sees the potential of, or even the need for proc FCMP. However, I think it signals a major change in…
Allowing direct access to OLAP Cubes & Data Tables from Web Report Studio 4.3
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 […]