 Hi everybody, it's Monica Wahee from Deathwench Professional Services, where I always say let Deathwench do your data. And I'm here today to promote my new book, Mastering SAS Programming for Data Warehousing. And why am I here to do that? Because you got problems. I got problems. If you're a data scientist, you got data problems. And what I've got in my book are solutions for you, all my data warehousing secrets that will make your data warehouse gorgeous. But let me convince you, let's start with chapter one. Chapter one, I go over the history of SAS, like how the IO engine was built and the analytic engine. And unfortunately, you kind of need to know that in order to do modern data warehousing with SAS. Like, I actually talk about the cards and like, if you should use where or where you should use if, you know, the if and where problem. And in chapter two, I talk about how we read big data in in the modern times with SAS. So I really start to hook you up there. Talk about Live Name, talk about Proc Seaport, Proc Import, touch a little on Proc Sequel. So I got stuff for you. I even show you how to unpack an XPT, right, and how to pack it back up if you need to put it away, right? So you want chapter two, okay? Then we move on to chapter three. What's that? SAS labels and formats, okay? Not R, not Python, not Tableau, not even SQL. You'll never use these except in SAS. So and actually, you need to know them because you can actually use them to not only improve your IO, but to make your reports like Predator. So you want to go through chapter three. Then in chapters four and five, we go over stuff that's really like top secret that I'm sharing with you. Like nobody I know knows how to do this. And it's about how to design your ETL and how to design your reporting. So what does that mean? Well, it means about making metadata. It means about designing variables, designing processes. How are you going to do your ETL pipeline? Who's going to do what? How are you going to do your reporting? How are you going to spec your report? How are you going to verify your report? All that's in there. And it's got code for you. I got code. I got code on GitHub. You can download and play with it. SAS University Edition, free, free, free, right. Okay. So then after chapters four and five, I have to hit you with chapter six, which are arrays. So anybody uses SAS, you know, arrays, can't live with them, can't live without them. You need them for IO, but boy, are they hairy to use. And you got naming convention problems. But another solution I include for you, how to deal with those array naming conventions. So you definitely want to read chapter six. But then finally, we go to chapter seven, where we instantiate the ETL plans that we made in chapter four. So it's about how to actually do the ETL that you designed. And then chapter eight is about automating that ETL with macros and macro variables. Now it's important. Macro variables and macros are not the same thing. I cover all of that in chapter eight. And then we move on to chapter nine, because guess what? We need chapter nine, because that is debugging and troubleshooting. Because if you've made it to chapter nine, you've got macros, you've got data input, you've got reports, and you're probably going to need to do some troubleshooting. Finally we make it to, I admit, my favorite chapter. And that's chapter 10. That's about how to serve user needs. So it's a little touchy-feely. But it's also very professional, because it's really about management and leadership and how you can make your data warehouse shine, not just from the point of view of the data in it and the reports, but also from the point of view of the management and the stewardship of the data. Then in chapter 11, we get back to the information superhighway. How do you connect SAS with other products? How do you pipe and SQL? How do you connect it to Tableau? What about the cloud? What about Snowflake? Well, to cut to the chase, it's an open database connection and the SAS access component, but there's devil in the details, so you want to read it. Finally, in chapter 12, which is the last chapter, and I saved it for last, is really about reporting to the web. And if you go back to chapter one, like SAS is pretty old, the web wasn't there. So SAS struggles a little bit with reporting to the web, but now we have SAS Viya. So there's new stuff, so you want to read it. All right, so what are you waiting for? If you've got data problems, I got your solutions. What you want? What you want? I got it all here in mastering SAS programming for data warehousing. So you can click on the description and buy it at Amazon if you've made your decision. If not, I've also put a link in the description to a blog post I made that explains what's in each chapter. And those of you who are professors and educators like moi will really like the book because I've got little questions at the end, and of course, there's the code on GitHub. All right, please buy my book and make your data warehouse beautiful.