Category: SAS

Finding the Max Value In An Array

The max() function makes it easy to find the maximum value in a SAS array. Given an array like:array x[*] x1-x10;maxValue = max(of x[*]);Pretty slick, eh? Remember, it doesn’t return the position of the max element, just the max value.This can be pret…

SaviCellsPro and Exciting Changes

Well, it was hectic week. I went back to work again (on a cool project) and spent a lot of personal time on SaviCellsPro. Specifically on a new utility that I think is pretty darn exciting.In the past, when you used SCP, you needed to write the XML for…

Setting the HTML title tag in SAS ODS (the right way)

In our department and various places on the Intertubes, SAS programmers set the HTML title tag (which sets the title in web browsers and on search engines) in ODS using the headtext option: ods html headtext="<title>My great report</tit…

.NET Coders and the sas7bdat dll

I have been spending the last week working on how the interface to the sas dataset can be used by a .NET developer. It is of particular concern because once the initial dll is released, it will be hard to change it. Getting the interface ‘mostly’ corre…

Funny SAS Post – SAS on the Wii

It’s an older post, but I didn’t see it until now.  It’s worth reblogging about.  SAS talks about SAS on the Wii.

SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)

We can’t stress the importance handling character case correctly. Here are the two functions you need to know and use correctly. In order to convert all characters in a sting to lowercase, use the LOWCASE function. Example: data ds_2; set ds_1; *convert it to lowercase; new_char_var=lowcase(OLD_CHAR_VAR); run; In order to convert all characters in a […]

Progress on the sas7bdat

It is tough at times to be a consultant and get those side projects out of the way. That said, I finally had a chance to really work on the sas7bdat some more over the holidays. Not too much since my personal focus is my kids. A really tough project in…