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) […]
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 (…