Blogs

Blogs

Advanced Analytics

Move beyond spreadsheets to data mining, forecasting, optimization – and more

Advanced Analytics

Rick WicklinJune 27, 2012 0

Create an ID vector for repeated measurements

I often use the SAS/IML language for simulating data with certain known properties. In fact, I'm writing a book called Simulating Data with SAS. When I simulate repeated measurements (sometimes called replicated data), I often want to generate an ID variable that identifies which measurement is associated with which subject

Read More

Advanced Analytics

Rick WicklinJune 22, 2012 0

Compute a running total for a "window" of time

A reader wrote for help with a computational problem. He has a vector of length N and the vector contains integer values in the range [1, 120], which represent months for which events occurred over a 10-year period. The question is: what is the 24-month period for which the most

Read More

Advanced Analytics | SAS Events

Waynette TubbsJune 15, 2012 0

Friday's Innovation Inspiration - A billion rows on the fly

The first time that I saw a demonstration of SAS Visual Analytics Explorer was awesome, but it didn't give me goosebumps. I got goosebumps the size of golfballs during SAS Global Forum Opening Session when Dr. Goodnight sat down at a computer screen and began to demonstrate how effortlessly users can

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 12, 2012 0

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 anyone got any tips on when those

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 11, 2012 0

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 (or mapped folder/drive structure). When editing

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 8, 2012 0

Selecting multiple individual dates in prompted reports

The date prompt from SAS Prompt Framework provides the options of single selection or a range, however what if you need to select multiple individual dates such as Monday (May 28), Wednesday (May 30), and Friday (June 1) of last week? There are a few alternatives to accomplishing this. Option

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallJune 7, 2012 0

Change your passwords without locking out your connection

Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your saved connection profile for SAS applications lock

Read More

Advanced Analytics | Data Visualization | Programming Tips

Open Stored Process GUI with Copy Selection

Angela HallJune 6, 2012 0

Backup or copy all components of your stored process before making changes

What if you would like to make a copy of an existing stored process to test out your changes before making them live? The copy command is available from within SAS Management Console or from the SAS Enterprise Guide Open Stored Process GUI as seen below (note you can only

Read More

Advanced Analytics | SAS Events

Waynette TubbsJune 1, 2012 0

Friday's Innovation Inspiration - High-performance analytics with Jim Goodnight

One of the coolest things that I saw at SAS Global Forum was Dr. Goodnight dissecting a hologram of a SAS high-performance server and describing how the technology works with analytics. This is the height of innovation. You have got to watch this! Here are a few great

Read More

Advanced Analytics

Rick WicklinMay 29, 2012 0

Did you know that PROC IML automatically loads certain modules?

In the SAS/IML language, a user-defined function or subroutine is called a module. Modules are used to extend the capability of the SAS/IML language. Usually you need to explicitly load modules before you use them, but there are two cases where PROC IML loads a module automatically. Modules in IMLMLIB

Read More

Advanced Analytics

Waynette TubbsMay 25, 2012 0

Friday's Innovation Inspiration - Put up or shut up

Put up or shut up is one of those great sayings from my generation. Loosely translated it means, stop complaining if you aren't going to do something about the problem. In this week's Innovation Inspiration, the author decided to teach American middle schoolers how to question the information that they

Read More

Advanced Analytics

Rick WicklinMay 23, 2012 0

Compute statistics for each row by using subscript operators

In a previous blog, I showed how to use SAS/IML subscript reduction operators to compute the location of the maximum values for each row of a matrix. The subscript reduction operators are useful for computing simple statistics for each row (or column) of a numerical matrix. If x is a

Read More

Advanced Analytics | SAS Events

Waynette TubbsMay 18, 2012 0

Friday's Innovation Inspiration - Jenine Milum creates a report

At SAS Global Forum, one of the most difficult areas for me to show to you are the poster presentations. This year, I asked Steve Polilli, a colleague who is great with a Flipcam, to video a few for me. I picked out three that I will use in the

Read More

Advanced Analytics | SAS Events

Waynette TubbsMay 11, 2012 0

Friday's Innovation Inspiration - High schoolers analyzing high schoolers

Part of what captivated me about this paper and poster presentation were the presenters - these guys are high school kids using SAS to do a visual analysis of Internet use by high schoolers. The idea was so compelling that Anna Brown and Inside SAS Global Forum went to talk

Read More

Advanced Analytics

Rick WicklinMay 9, 2012 0

The power method: compute only the largest eigenvalue of a matrix

When I was at SAS Global Forum last week, a SAS user asked my advice regarding a SAS/IML program that he wrote. One step of the program was taking too long to run and he wondered if I could suggest a way to speed it up. The long-running step was

Read More

Advanced Analytics

Rick WicklinMay 7, 2012 0

Checking your answers: Are computed values close to the true values?

In statistical programming, I often test a program by running it on a problem for which I know the correct answer. I often use a single expression to compute the maximum value of the absolute difference between the vectors: maxDiff = max( abs( z-correct ) ); /* largest absolute difference

Read More

Advanced Analytics | SAS Events

Waynette TubbsMay 4, 2012 0

Friday's Innovation Inspiration - A trend, fraud sniffer

Jenn Sykes (you probably remember her from this great sentiment analysis post last year about American Idol), presented Predicting Electoral Outcomes with SAS® Sentiment Analysis and SAS® Forecast Studio at SAS Global Forum 2012. In addition to predicting elections, Sykes tells Anna Brown from Inside SAS Global Forum, that there is a lot of unstructured data

Read More

Advanced Analytics

Rick WicklinMay 4, 2012 0

Expand data by using frequencies

A reader asked: I want to create a vector as follows. Suppose there are two given vectors x=[A B C] and f=[1 2 3]. Here f indicates the frequency vector. I hope to generate a vector c=[A B B C C C]. I am trying to use the REPEAT function

Read More

Advanced Analytics

Rick WicklinMay 2, 2012 0

The DIF function: Compute lagged differences and finite differences

To a statistician, the DIF function (which was introduced in SAS/IML 9.22) is useful for time series analysis. To a numerical analyst and a statistical programmer, the function has many other uses, including computing finite differences. The DIF function computes the difference between the original vector and a shifted version

Read More

Advanced Analytics

Rick WicklinApril 30, 2012 0

The LAG function: Useful for more than time series analysis

To a statistician, the LAG function (which was introduced in SAS/IML 9.22) is useful for time series analysis. To a numerical analyst and a statistical programmer, the function provides a convenient way to compute quantitites that involve adjacent values in any vector. The LAG function is essentially a "shift operator."

Read More

Advanced Analytics | SAS Events

Waynette TubbsApril 27, 2012 0

Friday's Innovation Inspiration - One step ahead of fraudsters

As always, SAS Global Forum holds a wealth of inspiration. The conversations that I have with you guys while I'm there almost always start with, "I just heard/saw/read the coolest thing. I can't wait to get home and get started using this!" For those of you who missed this year's

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 20, 2012 0

What would SAS Stored Process Key #51 be?

This past Monday, Tricia and I released our 2nd book this year. "The 50 Keys to Learning SAS Stored Processes" provides a step-by-step approach to transitioning from SAS code into user driven (prompted) stored processes. Trimming down all the things you can do with SAS Stored Processes is next to

Read More

Advanced Analytics

Rick WicklinApril 20, 2012 0

Popular! Articles that strike a chord with SAS users

I blog about a lot of topics, but the following five categories represent some of my favorite subjects. Judging by the number of readers and comments, these articles have struck a chord with SAS users. If you haven't read them, check them out. (If you HAVE read them, some are

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallApril 16, 2012 0

All the possible uses for PROC STP

PROC STP is a new procedure for SAS 9.3 Stored Processes. It's so new and different that I have not had the opportunity to use it yet in a customer engagement. When writing about it for the now released "The 50 Keys to Learning SAS Stored Processes" book, I had

Read More

Advanced Analytics

Carpenter's Guide to Innovative SAS Techniques

Waynette TubbsApril 13, 2012 0

Friday's Innovation Inspiration - A chapter from the book

Today, I have truly taken a chapter from the book - perhaps in more ways than one. I happened to notice that Art Carpenter's most recent book is titled, "Carpenter's Guide to Innovative SAS Techniques." Of course, you know that linking innovation and SAS are going to be a trigger

Read More

Advanced Analytics

Waynette TubbsApril 6, 2012 0

Friday's Innovation Inspiration - ROI-focused marketing, predictive analytics

A small, North American marketing firm (a division of a much larger international firm that provides data-driven, multichannel marketing solutions) provides its clients with "effective one-to-one marketing and ROI-focused strategies by applying advanced predictive analytics."

Read More

Advanced Analytics | SAS Events

Waynette TubbsMarch 30, 2012 0

Friday's Innovation Inspiration - Get a real job

There may be some of you who don't remember this song, but in high school and early college it was one of my favorites. "Get a haircut and get a real job," by George Thorogood and the Destroyers, really spoke to the rebel in me. Most of my rebellious days are behind

Read More

Advanced Analytics

Waynette TubbsMarch 23, 2012 0

Friday's Innovation Inspiration - Cutting steps with DATA step

I think this DATA step Post-It author may be a bit like my mother. When I was a child, my mother was always coaching me on two things: being independent and being efficient. I believe those are the two traits she considered most admirable in a person. It's little wonder

Read More

Advanced Analytics

Waynette TubbsMarch 16, 2012 0

Friday's Innovation Inspiration - Tracking competitive zeal

You can keep track of and report anything with SAS, even motivation - or the lack thereof. This team has developed a portal to analyze and report their ride data. It could just as easily be used for groups who want to work together to lose a few pounds, train

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallMarch 16, 2012 0

Stop recreating the wheel, save those common joins into a permanent view

When you are constantly taking the data tables and completing joins to begin working on your reports or analysis it might be time to consider creating permanent views. Then you can just add the view to the Enterprise Guide project rather than dealing with the joins in a Query Builder

Read More

Previous 1 … 42 43 44 45 46 … 52 Next