Last week I alluded to some very useful applications of the Copy Files task. This is one of them. If you have SAS Enterprise Guide 7.13 or later, the Copy Files task is in the Tasks->Data menu. In earlier versions, you'll have to download/install the task as a custom task.
Every time you see a rainbow, do you look to see where it begins and where it ends? Legend has it that there is a pot of gold at the end of each rainbow with leprechauns guarding it. While this might be popular Irish folklore, and you may not find
For programmers who are learning the SAS/IML language, it is sometimes confusing that there are two kinds of multiplication operators, whereas in the SAS DATA step there is only scalar multiplication. This article describes the multiplication operators in the SAS/IML language and how to use them to perform common tasks
Recent versions of SAS Enterprise Guide (version 5.1 and later) use Microsoft .NET 4.0, which enforces additional security requirements before running custom task DLLs that you download from the Web, including those that you download from support.sas.com. Because these task DLLs are downloaded from the (big and scary) Internet, the
Students with missing test scores are often highly mobile students and are more likely to be low-achieving students. It is important to include these students in any growth/value-added model to avoid selection bias, which could provide misleading growth estimates to districts, schools and teachers that serve higher populations of these
SAS Global Forum 2013 is a couple weeks in the past, but the feedback and anticipation shared by customers as they heard about SAS 9.4 are still fresh in our minds here at SAS. As we put the final touches on the June release, the excitement we felt in San
The PharmaSUG 2013 conference in Chicago this week was awesome. From the perspective of graphics, there was great interest in using SG Procedures, Designer and GTL for building clinical graphs. It was nice to see many papers by users on how they are using these tools for creating graphs on a daily
A few months ago I released the Copy Files task for use with SAS Enterprise Guide. The task allows you to transfer any files between your PC and a SAS Workspace session, much like an FTP process. It doesn't rely on FTP though; it uses a combination of SAS code,
Are you an NFL fan, or curious about analyzing social media data? -- Well, in either case, this blog's for you! I recently read a fascinating Facebook article that included a U.S. county map showing which NFL (U.S. football) team had the most 'likes' in each county (based on ~35 million
As we have seen my previous post "Seeing SAS data through metadata", there is a fundamental difference between accessing a SAS library using a physical reference or a metadata reference to that library. By now, you should now be an expert on the nuances of physical references to SAS data
Last week someone posted an interesting question to the SAS/IML Support Community. The problem involved four nested DO loops and took hours to run. By transforming several nested DO loops into an equivalent matrix operation, I was able to reduce the run time to about one second. The process of
Ever heard your grandmother say when you were little: If you have your heart set in the right place, you can achieve anything you set out to do! That’s what SAS users tried to do at SAS Global Forum 2013 held at Moscone West, San Francisco. The conference had a
I've conducted a lot of univariate analyses in SAS, yet I'm always surprised when the best way to carry out the analysis uses a SAS regression procedure. I always think, "This is a univariate analysis! Why am I using a regression procedure? Doesn't a regression require at least two variables?"
Do you remember when CPU time was a high-priced commodity? "Today, if you are any good at what you do, the constrained resource is you," says Timothy Berryhill from Wells Fargo. Berryhill has years of experience with SAS on "many platforms and operating systems." He says there are several things
The SAS Global Forum conference last week was awesome. From the perspective of graphics, there were more papers from uses on graphics and ODS graphics then in recent times. I will post a summary shortly. One of the interesting papers was "#113-2013 - Creating Clark Error Grid using SAS/GRAPH and Annotate..."
In today's fast-paced, jam-packed work day, many people answer email and read reports after business hours. And more and more, they're doing those things on a smartphone or tablet. How are your users accessing and using your reports? Statistics South Africa has found that their end-users would prefer a mobile
At a recent conference, I talked with a SAS customer who told me that he was using an R package to create a three-panel visualization of a distribution. Unfortunately, he couldn't remember the name of the package, and he has not returned my e-mails, so the purpose of today's article
Even though it's been around for well over a decade, SAS Enterprise Guide was still a hot topic among attendees at SAS Global Forum this year. In the Technology Connection -- the big session on Monday morning -- SAS R&D staff used the conference agenda content to demonstrate the power
PROC UNIVARIATE has provided confidence intervals for standard percentiles (quartiles) for eons. However, in SAS 9.3M2 (featuring the 12.1 analytical procedures) you can use a new feature in PROC UNIVARIATE to compute confidence intervals for a specified list of percentiles. To be clear, percentiles and quantiles are essentially the same
Google holds the gold standard for maps and we have heard our users loud and clear. SAS will introduce enhanced mapping features in SAS Visual Analytics Explorer, SAS/GRAPH®, and other products.
In my last blog, I discussed the growing commitment among governors to infrastructure investment, and to coming up with innovative ways to find dollars to fund the needed improvements to the transportation network. I heard it over and over again during the Transportation Research Board (TRB) Annual Meeting in January
Rick Styll from SAS presents the latest features of SAS® Enterprise Business Intelligence which include improved dashboards, navigation and better integration with Excel and email clients.
Stephen Overton from Overton Technologies, LLC discusses the features of OLAP technology in business intelligence reporting.
According to research, less than half of an organization's data is structured data; nearly 80 percent is unstructured data that may come from social media, customer letters, web pages, invoices and freeform survey answers. Getting the information you need from that data can be a quick and automated experience or
Justin Choy from SAS presents an overview of best practices for providing data to clients and users while also maintaining analytic integrity of models and processes.
Learn how to leverage the power of hash tables for sentiment analysis with David J. Corliss from Magnify Analytic Solutions.
Imagine using software to build the perfect sports team. That’s exactly what an Indian cricket league did using SAS® Enterprise MinerTM! Pankush Kalgotra tells us how he used predictive modeling to select the best players for the Indian Premier Cricket League on the SAS Global Forum livestream: sasglobalforum on livestream.com.
American country songs are known for topics such as mama, trucks, trains, heartbreaks and drinking. How many of these topics are included in the top country songs over the past 25 years? Deovrat Kakde of Kavi Associates used SAS Text Miner to find out! He shares some of his more
Tricia Aanderud from And Data and Angela Hall from SAS share the advantages of SAS® Stored Processes with the SAS Global Forum! In this discussion, you will learn tips and tricks for using stored processes within SAS BI clients. Watch their presentation, "Stop Your "Wine"ing: Use a Stored Process", now
What is data mining and how do you find those golden chunks of information that transform your business? David Dickey from NC State University gives examples of how tools such as SAS® Enterprise Miner™ can help in his presentation "Finding the Gold in Your Data: An Overview of Data Mining"
