I really dig the SAS Enterprise Guide 5.1 – Data Explorer Tool. How many times have you received a new data set that you know nothing about? While it’s not like it takes forever to run some PROC FREQ/MEANS – but what if it’s already done for you or can be done quickly? Did that get your attention? Here’s how to use this new feature with your data. Open Data Exploration from File Menu From the File menu, select Open > Data Exploration. Then navigate to the dataset you want to open. I am using SASHELP.SHOES since many of you may already be familiar with it. The dataset is open and a new window appears to the right side of the dataset. At the bottom of the window, you can view some general information about the dataset (i.e. 395 rows and 7 columns). All the Statistics You Can Handle This is what I really like – I can run all statistics for all variables at once. From the new window, click the Charts icon and then Click to run all statistics. Notice when I selected the Charts icon, the window changed to list each variable type (character, numeric, currency) […]
Category: SAS
Rainbow Table Salt
DISCLAIMER: I am not an expert at cryptology. But I generally understand the industry best practices and have implemented this stuff on several sites. That said, read on at your own risk 🙂
There’s been a lot of talk about LinkedIN passwords ge…
Create a .CSV file of SAS dataset without column names or header row?
SAS places the variables names in Row 1 when you try to
create an excel or .CSV file of the SAS
dataset. I have found a tip to tell SAS not to keep variable names in
the row 1 of .CSV file.
SAScommunity.org page has put together nice informati…
High-performance analytics: it may be a show, but it’s not an act
Last Friday morning I took a meeting with SAS CEO Jim Goodnight. Despite the hassle, I was happy to rearrange my busy schedule to squeeze him in. Ha! Just a little joke there about my inflated sense of importance! Actually, the meeting was part of a regular series called “Conversations […]
How did you find that metadata?
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…
Where is the SAS code for that stored process?
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 (…
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 […]
Links for 2012-06-09 [del.icio.us]
Simplenote.
An easy way to keep notes, lists, ideas, and more.