What is the most efficient way to drop/keep columns (variables) in sas tables (data sets)?For the most part, we would correctly say “using a keep= option on the data set as it is being read into the current step.” A quick example to illustrate: data s…
Efficiently Drop/Keep SAS Data Set Columns
What is the most efficient way to drop/keep columns (variables) in sas tables (data sets)?For the most part, we would correctly say “using a keep= option on the data set as it is being read into the current step.” A quick example to illustrate: data s…
Dynamic dashboard ranges – its all in the data
Business Problem: The traffic lighting (red/green/yellow) range is different for one group/category than the others but the indicator needs to include all group values. Recommendation: It’s all in the data. Here is an example. For the Candy_Sales_Summa…
Bad words in SAS – PG rating
Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye,…
NOTE: More Tip Sheets
In response to the SAS/Base tip sheets I mentioned a couple of weeks back, Rick Wicklin sent me a comment to say he’d been inspired to publish a couple of tip sheets for SAS/IML. He’s highlighted these in his latest posting on his The DO Loop blog. One…
NOTE: More Tip Sheets
In response to the SAS/Base tip sheets I mentioned a couple of weeks back, Rick Wicklin sent me a comment to say he’d been inspired to publish a couple of tip sheets for SAS/IML. He’s highlighted these in his latest posting on his The DO Loop blog. One…