I have been calling us data geeks – but turns out our new name is actually the more respectable data scientist. Wonder if we get white lab coats with our names over the pocket? That would be so cool. Anyway, check out AllAnalytics.Com – there is a community of folks talking about big data, data analysis, and even trends for the future. Great Place to Get Ideas AllAnalytics.Com is a great resource for SAS users – they discuss a lot of the topics that we work with everyday. I love learning about all the different ways us data scientists are solving problems. Today they are discussing how those personals – Find Your Mate sites work. I say you cannot apply analytics to love … but maybe I’m a romantic scientist. Chance to Win a Free Copy of BI Book Next Friday at 2 PM (EST), AllAnalytics.Com is hosting my co-author, Angela Hall, and I to talk about our new book, Building Business Intelligence with SAS: Content Development Examples. So Angela and I will be available to discuss the writing process, working with SAS Press, and even answer some of your BI questions. SAS Press has donated two copies of […]
Enterprise Guide: Zero My Hero – Using the Z Format
Working with account numbers can require adding a leading zero. You can use the Z format but it can be a little tricky. Not so long ago I showed you how to use the Z format to create a new data item in Information Map Studio. However, I noticed many people are still searching for this information and when I was using it myself I was not able to find much on it. This post explains how to create a new column in Enterprise Guide following by the actual coding steps in PROC SQL: Creating a New Column in SAS Enterprise Guide Query Builder To add the leading zeros, you have to use the Z format and a numeric variable. Using the Query Builder, you can create a new column in your data. In this example, you’ll see how to change the numeric ACCNO to a character variable with the leading zeros. This example starts with the ACCNO_TWO dataset. To create the new column, do this: From SAS Enterprise Guide, open the Query Builder with the ACCNO_TWO dataset. Select Computer Columns button. In the Computer Columns window, select the New button (not shown). From the New Computed Column window, select […]
Mahalanobis distances on a heat map
I just learned Mahalanobis distance from Rick’s blog post yesterday, and realized its significance in detecting outliers. One of SAS’s online documents shows how to use PCA method to find Mahalanobis distances. And in SAS 9.3, the popular&nbs…
Ready for the Next Generation of SAS?
There’s so much excitement about big data, data scientists, and all things that mean you need some serious SAS BI skills. On Monday I was discussing the Kinsey Insitiute projections for data related jobs, but even the New York Times ran The Age of Big Data an article about it. Appears everyone is talking about it! oooh … Buzz! I love it. SAS BI Developer Demand is Growing The past December, BusinessIntellience.Com, reported that SAS Business Analytics SMB Sales Jumped 42 Percent and went on to comment that ”[this] jump demonstrates that enterprises of all sizes are seizing business analytics as a vital competitive tool.” Last week, the same webzine was reporting that SAS in Leaders Quadrant for Business Intelligence Platforms according to the Gartner Inc report. As SAS Institute sells more SAS BI solutions, naturally more SAS BI Developer jobs become available. On the Indeed.Com you can search out job trends to determine which fields seem to be growing. [Disclaimer! These figures are based on Indeed.Com job postings and I have no idea what their counting rules are – so I realize this could be that more recruiters use Indeed or Indeed has a better aggregation methodology.] With that said, check out the SAS BI […]
How to open a SAS OLAP cube in SAS Web Report Studio
Business users of SAS are finding the Web Report Studio capabilities incredibly beneficial for viewing, creating, and sharing reports on the Web. The easy-to-use query and reporting software provides a point-and-click interface for building reports f…
SAS Certification hits the big 4-0
The SAS Global Certification program concluded 2011 with a bang by awarding the 40,000th SAS credential. Program growth has continued to accelerate ever since the 1999 launch, with a dramatic 53% growth in the total number of SAS certifications awar…