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

0
Visualize the bivariate normal cumulative distribution

When you are working with probability distributions (normal, Poisson, exponential, and so forth), there are four essential functions that a statistical programmer needs. As I've written before, for common univariate distributions, SAS provides the following functions: the PDF function, which returns the probability density at a given point the CDF

0
Compute the multivariate normal density in SAS

I've been working on a new book about Simulating Data with SAS. In researching the chapter on simulation of multivariate data, I've noticed that the probability density function (PDF) of multivariate distributions is often specified in a matrix form. Consequently, the multivariate density can usually be computed by using the

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

0
I have doubts

One of my new work friends says this frequently. But the statement is lost in his translation from Portuguese, it is not that he does not believe me, it is just that he has questions about how things happen so he can learn. I debate on which version of this

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

0

After some discussion with SAS Product Marketing yesterday, we devised this response to everyone's question about the Business Analytic differentiator that SAS provides. ********************************************************************************************************* Business Intelligence is one of the key components from SAS that ties into a suite of analytic techniques, information handling and performance infrastructures needed to deliver

0
Any SAS program can become a SAS Stored Process

Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could

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

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

0

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

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

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

0
Mobile is available for all SAS programmers

During the SAS Global Forum this past week, SAS offered several demos on mobile technology including: Michael Hecht, SAS, JMP iPad App Super Demo Chris Hemedinger hosted a Live Tech Talk on Tuesday that covered the new SAS Visual Analytics Explorer with demos on Microsoft Surface and iPad Apps Remember everyone is using mobile devices

0
The things I missed at #SASGF12

Unfortunately, my clone attempt didn't work like Chris Hemedinger's did. With all my papers, presentations, and demo hall duties, I realized yesterday that I certainly missed a lot. Included is my to-do list for items to watch and catch up on this weekend. Not really sure how I missed the