If you have been using SAS for long, you have probably noticed that there is generally more than one way to do anything. (For an example, see my co-author Lora Delwiche’s blog about PROC SQL.) The Little SAS Book has long covered reading and writing Microsoft Excel files with the […]
Accessing Excel files using LIBNAME XLSX was published on SAS Users.
In case you missed the news, there is a new edition of The Little SAS Book! Last fall, we completed the sixth edition of our book, and even though it is actually a few pages shorter than the fifth edition, we managed to add many more topics to the book. […]
Test your SAS skills with the newest edition of Exercises and Projects for The Little SAS Book was published on SAS Users.
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam. Your SAS […]
Quick Tip to Use when Creating a Metadata Library Here’s a quick tip for SAS BI Administrators or anyone who has to create metadata library in the SAS Management Console. Often before I define the metadata library I am at the folder or the physical path of the library. Obviously, it’s critical that the path is defined correctly in the metadata. So here’s my quick tip. In the physical library, click or double-click the path and use the Ctrl+C keyboard shortcut to capture the path. As you assign the metadata library, in the New Library Wizard window, click New to assign the path. Instead of clicking the Browse button to navigate to your library path, do this instead: Double-click the Paths field and press Ctrl-V to paste the path.Some folks may not realize that is an editable line – so you can also make changes if needed.
When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data…