A common question really and one that I get after posting code like yesterday’s All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has an…
Tag: Metadata
SAS Enterprise Guide: Best Practice for Centralized User Storage
A nice feature of SAS Enterprise Guide is the “Files” folder. This provides direct access to the file system where the workspace server is running. You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful. If this is not configured it defaults to a user-specific area. In some cases this may be the most appropriate location of the “Files” link. Simple Ways to Use Centralize SAS code developed by users Centralize SAS datasets or other types of data for users Stage incoming files from external sources for end users to consume and analyze Important Note: Make sure file permissions are set appropriately for the file system location on the server! How to Configure the “Files” Folder Use SAS Management Console to configure the location of the “Files” folder. This requires an administrative role to accomplish because it is seen across the enterprise. The workspace server runs SAS code from EG so it will be the item of interest in Management Console. Since users will access data and submit code through the SASApp context server, you will want to navigate to the workspace server through the […]
Peek Inside SAS BI Book: Building Business Intelligence with SAS
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 […]
SAS Management Console: Quick Tip when Creating a Metadata Library
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.
Impact Analysis – “Hawk Eyes” of SAS Data Integration Studio
As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in the database is linked up or imp…
SAS Enterprise Guide: Updating the Metadata with New/Modified Datasets
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…
Platform Suite for SAS – Dev/Test/Prod Tips
Here are some of my tips for using the Platform Suite for SAS when you have Development, Test and Production environments to support your SDLC.Install and configure one instance of Platform LSF and Platform Process ManagerIf you have separate machines …