A well-formed WHERE statement or subsetting IF can narrow down the output of your SAS DATA step. The SAS log does a good job of telling you how many records were processed by the action. For example, let's look at this simple DATA step with my "poor man's random sample",
Author
![Making up for lost time (UTC vs. DST)](https://blogs.sas.com/content/sasdummy/files/2012/03/fiveoclockworld.jpg)
Did you oversleep this morning? If you live in the United States of America, Monday morning seems to have arrived just a bit earlier, accompanied by a bit more "dark" than usual. That's because as good time-fearing citizens, we have all set our clocks ahead by one hour so as
A few years ago I had the privilege of presenting the last technical paper at SAS Global Forum. This year, conference chair Andy Kuligowski asked me to go one better than that, and present a talk at the official Closing Session. What will I talk about? That's a mystery (maybe
The next time you write a DATA step, try to express it in iambic pentameter. Or instead of a SAS macro function, how about a SAS macro sonnet? (Or, for the more base among you, a limerick?) That's the spirit behind the code {poems} project. You write a poem in
![Numbers great and small: the problem of Big Datum](https://blogs.sas.com/content/sasdummy/files/2012/02/fp1.png)
About once a month, a customer approaches SAS and asks a question of significance. By "significance", I don't necessarily mean "of great importance", but instead I mean "of how SAS handles large numbers, or floating-point values with many significant digits". In response, we always first ask why they asked. This
![SAS Report: You're soaking in it](https://blogs.sas.com/content/sasdummy/files/2012/02/nfreport.png)
Do you want your report to look good on the web, or to look good when you print it? Pick one. Before the SAS Report file format, that was the choice that you faced. HTML is perfect for the web browser. It's easy to scroll through tables, to apply an
![How do I export from SAS to Excel files: Let me count the ways](https://blogs.sas.com/content/sasdummy/files/2012/02/spreadsheet-619x336.png)
I have a love-hate relationship with spreadsheet data. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can
![Review your metadata profiles using SAS Enterprise Guide automation](https://blogs.sas.com/content/sasdummy/files/2012/02/mdprofile.png)
We call it the "metadata profile", but really it's like a telephone number that connects you to your SAS environment. Just as a telephone number has component parts (country code, area code, exchange), the metadata profile contains information that allow you to "dial in" to your SAS servers. This information
![Reaching a dubious peak](https://blogs.sas.com/content/sasdummy/files/2012/01/mediocrity.png)
So many of us struggle with this mountain. In fact, 68.27% of us get within sight of reaching the summit (while 95.47% of us are at least on a perceivable slope). We run, walk, crawl and sometimes slide our way uphill (from one direction or the other) until we finally
![SAS export to Excel just got a little bit easier](https://blogs.sas.com/content/sasdummy/files/2017/02/ProgrammingTips-3.png)
Note: as this is a popular topic, I've added a few notes with minor updates, including a link to a popular how-to tutorial video. In case you missed it, the first maintenance release for SAS 9.3 was recently released. Because we're all friends here, you may call it "SAS 9.3M1"