Category: SAS

Play Matrix within SAS(1): basic files processing

Recently I read Rick Wicklin’s IML blog with great interests(and anticipation for his fore-coming IML book,  Statistical Programming with SAS/IML Software). SAS programmers have the following programming tools to facilitate their daily work:

SAS data step: the basic SAS; a generation IV programming language, similar with other procedural languages such as C.
SAS Proc SQL: SAS’s […]

Summary Numerical Data in a Rolling Window

Obtain summary statistics over a rolling window for a given data, usually on a time dimension, is not quit easy in SAS, especially the rolling window may contain different number of records and the maximum number is unknown without pass the data once…

Create format from dataset

data fmt(keep=fmtname start label);&nbsp &nbsp &nbsp set temp;&nbsp &nbsp &nbsp fmtname=”TRTFMT”;&nbsp &nbsp &nbsp start=trtgrp;&nbsp &nbsp &nbsp label=trtlbl;run;proc format library=work cntlin=fmt;run;=================TEMP:trtgrp&nbsp &nbsp &nbsp trt…

NOTE: DATA Step’s _N_ is PROC SQL’s Monotonic

I’ve made a few posts over the last few months about SQL (particularly its use within Enterprise Guide). One of my unstated issues with SQL is the inability to do the equivalent of DATA step’s _N_ to count unique rows. The ability to add a sequence num…

PlatformAdmin.com now has a Blog Roll (and roll of rolls)

Thanks to Andy Ratcliffe for adding platformadmin.com to his blog roll on NOTE:. This was a timely reminder for me to add a blog roll to this platformadmin.com blog, something I had been meaning to do for some time now, and so I was prompted to make a start on it. You can find the […]

SAS Enterprise Guide 4.1: it’s not dead yet

Are you up to date on your hotfixes for SAS Enterprise Guide 4.1? If you’re not certain of the answer, you’ll find out next week when you might see this message appear:
This version of SAS Enterprise Guide will expire on December 1st, 2010.
If yo…

NOTE: SAS TALKS Celebrates One Year

At the same time as we mark the passing of Benoît Mandelbrot, SAS TALKS is celebrating its first birthday.

SAS TALKS is a series of free webinars offered by SAS and featuring SAS technical experts. You can watch any of the last year’s ten webinars fr…

Benoît Mandelbrot (1924 – 2010)

I was saddened to see reports of the recent death of Benoît Mandelbrot. I’m not clever enough to understand much of his work, but I do understand that his pioneering work on fractals (fractal geometry) led not only to some beautiful images but a…