Published Tips

If we just need to know if a variable exists in a dataset, we can open the dataset and look for it.  If we are feeling fancy, or frustrated trying to find it, we can use a PROC CONTENTS.  But sometimes we need to know if a var

Hash code is the new, cool thing for creating efficient code when working with very large datasets.  Hash code can be used in a myriad of ways, the most common of which is to lookup information from one dataset to use in another or

Sometimes multiple pieces of information are stored in a single variable.  Often it becomes necessary to separate the information into the constituent parts. Sometimes we have a delimiter with which to do this, but sometimes the va

Given a situation where we need to perform the same operation on multiple variables in a dataset, for example, suppose I have 20 variables, call them ratio1, ratio2, ratio3, etc.  And I need to convert all the ratios to percentages

Working in an old client's new programming environment, and suddenly nothing is where I expect it to be.  The formats were causing me a great deal of grief.  I kept adding them to the format catalog but then they were never av

With my recent upgrade to SAS v9.2 I discovered, much to my horror, that there was a glitch in ODS PDF that causes lines with a superscript to be double-spaced!  My reports contain a lot of superscripts.
The issue report at SA

I need to count the number of records from TC which will satisfy the below condition. Does anyone know how to do this without using transpose?

Select all records from TC, where EX.EXSTDTC <= TC.TCDTC <= EX.EXENTC. Then sum

The code below is meant to calculate the cumulative days of exposure to drug at a specific dose (in this example at 4.5g).  The code does not work as expected.  The EX4_5L is missing on all records.