All Posts
Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could
SAS customers are both bright and generous. Recently, I met several who gathered to discuss SAS Enterprise Miner and SAS Model Manager predictive analytics and data mining software. Hiring the best I loved listening to their discussion on what they look for and how they find the people who will
It is exciting and overwhelming when you first get new software for information management, reporting and analytics. This is especially true once your users first get their hands on the data and new reports. I recall first hand when I was a system engineer and had been with SAS for
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE
When the IASUG conference founder and 2012 co-chair John Xu was asked what makes this one-day event so successful year after year, he said, “The most important factor is the leadership. We are lucky that we have core conference volunteers committed to supporting the conference.”
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 anyone got any tips on when those
Stored process code can exist within the metadata itself for version 9.3 (the benefits of which I discussed earlier). But for all other versions (and as a option in version 9.3) the SAS code is stored as a .sas file within the server's file system (or mapped folder/drive structure). When editing
CTSPedia.org is a website of Knowledge Base for Clinical and Translational Research. On this site you can find sample graphs for statistical analysis of safety data for Clinical Research. Graphs included in this resource have been submitted by contributors, and include a graph for Liver Function for different tests by treatment.
In this Flipcam video by SAS' Steve Polilli, Don Kros and Jon Boase discuss the methodology they developed to help SAS users in their organization advance their SAS skills. Kros and Boase submitted a poster, which you'll see in the video, and a paper "The Path to Developing Your Organization's SAS Skills,"
The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option
If you are like many SAS Enterprise Guide users, you've amassed a large collection of project files (EGP files) that contain important content: programs, logs, notes, results, and more. However, to most tools and processes, the EGP file is opaque. That is, you can't see what's inside of it unless
A graph in a recent article in Fortune magazine caught my eye. The graph shows the cost of hosting the Summer Olympics over the past eight events. Here is what I termed the "Medal" graph. Now, practitioners of the art of Effective Graphics would likely find some shortcomings in the graph. Clearly
This week's %NLINMIX macro tips come from the esteemed authors of SAS for Mixed Models, Second Edition. Ramon C. Littell, George A. Milliken, Walter W. Stroup, Russell D. Wolfinger, and Oliver Schabenberger combined their expertise to write this indispensable guide. This 800 page book has made a big impact in the user community
Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your saved connection profile for SAS applications lock
It’s going to be a busy summer with a lot of travel. I’ve been invited to several user conferences so I’m really excited to get to meet even more SAS users, pick up some great tips for others, and wear myself out chatting.