The SAS Dummy
A SAS® blog for the rest of us![Essential SAS tools to bring to your next hackathon](https://blogs.sas.com/content/sasdummy/files/2018/09/IMG_3486-702x336.jpg)
To succeed in any data-focused hackathon, you need a robust set of tools and skills – as well as a can-do attitude. Here's what you can expect from any hackathon: Messy data. It might come from a variety of sources, and won't necessarily be organized for analytics or reporting. That's
![Manage the current directory within your SAS program](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-3.png)
Using relative file paths in your SAS programs? Use the new DLGCDIR function to manage your SAS working directory -- even in SAS Enterprise Guide or SAS Studio -- to ensure your programs are working the way they ought to.
![SAS code golf: find the max digit in a string of digits code golf](https://blogs.sas.com/content/sasdummy/files/2018/07/golf.jpg)
"Code golf" is a fun programming pastime that challenges you to solve a problem with the least amount of code possible. Like regular golf, the goal is to use fewest code "strokes" to hit the mark. Here's a recent challenge that was posted to me via Twitter. @cjdinger @SASJedi got
![Using %IF-%THEN-%ELSE in SAS programs](https://blogs.sas.com/content/sasdummy/files/2018/07/ifthenfeature.png)
SAS programmers have long wanted the ability to control the flow of their SAS programs without having to resort to complex SAS macro programming. With SAS 9.4 Maintenance 5, it's now supported! You can now use %IF-%THEN-%ELSE constructs in open code. This is big news -- even if it only
![The Internet of Snacks: SnackBot data and what it reveals about SAS life snackbot feature](https://blogs.sas.com/content/sasdummy/files/2018/07/snackbot-702x336.jpg)
At SAS, we love data. Data is central to our corporate vision: to transform a world of data into a world of intelligence. We're also famous for enjoying M&Ms, but to us they are more than a sweet snack. They're also another source of data. My colleague Pete Privitera, with
![How to use SAS to read a range of cells from Excel Excel named range](https://blogs.sas.com/content/sasdummy/files/2018/06/tange1.png)
I've said it before: spreadsheets are not databases. However, many of us use spreadsheets as if they were databases, and then we struggle when the spreadsheet layout does not support database-style rigor of predictable rows, columns, and variable types -- the basic elements we need for analytics and reporting. If