The open source R software for analytics has a reputation for being hard to learn. It certainly can be, especially for people who are already familiar with similar packages such as SAS, SPSS or Stata. Training and documentation that leverages … Continue reading →
Leverage metadata user synchronization macros for other uses
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…
SAS EG 5.1 – Data Exploration Feature
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 […]