Secure File Transfer Protocol has become the standard for transferring files outside our organization. However, it is not always the easiest thing to do in SAS. Here are a few code examples for you to steal. Importing a CSV file over SFTP: %let host=afhood.com; %let sftpOption=-o IdentityFile=/home/user/.ssh/id_rsa; %let filename=theFile.csv; %let sftpPath=/home/remoteuser/dir/; filename myfile sftp “&sftpPath.&filename.” […]
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 […]
Role-Based Access to Metacoda Security Plug-ins in SAS Management Console
This post explains how to provide role-based access to Metacoda Security Plug-ins in the SAS® Management Console (versions 9.2 and 9.3). Metacoda Security Plug-ins are initially only available to administrators, specifically members of the Managem…
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.
Review your metadata profiles using SAS Enterprise Guide automation
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 […]
Complete your order using preview results in SAS Add-in to MS Office
Recently I’ve made several online purchases buying eBooks for the new Amazon Kindle my daughter received as a holiday gift. The online checkout process is very straight-forward, especially with the ‘Continue’ buttons that change to a ‘Place your order’…