Category: SAS

SAS XPT Files, IBM Floats, and C#

Well, I recently was asked if I could support XPT files, you know, the SAS transport format. Well, SAS transport formats are documented and fairly straight-forward to read so ‘why not?’.Got started coding, client provided a nice sample, all went well. …

Now That’s What I Call Data Visualisation!

This video from the McLaren Formula 1 team is artistic as well as informative. The film merges photography, animation and sculpture and is a truly unique way of representing aerodynamics.

The car in question is the McLaren P1 supercar from McLaren …

Using a SAS function to validate a National Provider ID (NPI) value

We are careening towards the holiday season, and this year more than ever before it’s going to mean one thing: Online Shopping. As you enter your credit card number over and over to complete your many purchases, you might occasionally transpose or mistype your account number. Does it surprise you […]

SAS PROC METALIB and ODS OUTPUT

The SAS® METALIB Procedure, available in SAS 9.3, 9.2 and 9.1, is used to keep logical table metadata in sync with the physical tables that the metadata describes. It can also be used to report on any differences or discrepancies between the physi…

A SAS 9.3 Macro Trick: %put &=var

This is new since SAS 9.3 on how to display macro variable name and its value. Try to run %let var=1,2,3; %put &=var; or %macro test(var);     %put &=var; %mend; %test(%str(1,2,3)) and you will get in Log window VAR=1,2,3 You can read from SAS 9.3 online doc: If you place an equal sign between the […]

SAS Stored Process: Shake, Rattle, and a lil’ DelGobbo Style

One of the great things about attending user conferences such as WUSS is that you get to meet all kinds of fun and interesting people.  Vince DelGobbo is a witty, smart, and clever SAS developer, who also happens to work at SAS Institute.  Vince work…

Constructing block matrices with applications to mixed models

The other day I was constructing covariance matrices for simulating data for a mixed model with repeated measurements. I was using the SAS/IML BLOCK function to build up the “R-side” covariance matrix from smaller blocks. The matrix I was constructing was block-diagonal and looked like this: The matrix represents a […]