Integrating MDM with your data warehouse
David Loshin explains how to integrate MDM with your data warehouse.
Uncategorized
Using Windows PowerShell to find registered tables and columns in SAS metadata
In a previous post, I described how to write a Windows PowerShell script to connect to a SAS Metadata Server. In this post, I'll show an example of something useful that you can do after you've established that connection. Specifically, I'll show how to "ask" the SAS Metadata Server about
Initializing vectors by using repetition factors
The SAS/IML language has a curious syntax that enables you to specify a "repetition factor" when you initialize a vector of literal values. Essentially, the language enables you to specify the frequency of an element. For example, suppose you want to define the following vector: proc iml; x = {1
Role of the sales force in forecasting
The war of business forecasting ideas is being waged in the trenches of the online discussion groups. Where else can great disagreement be exacerbated (and sometimes even resolved) by often civilized discussion, with participants from across the globe? One of the popular groups for business forecasting practitioners is Demand Planning, Sales Forecasting,
Using Windows PowerShell to connect to a SAS Metadata Server
SAS Integration Technologies provides a flexible platform to create all types of apps, from simple utilities to full-blown applications. As part of the research for my SAS Global Forum 2013 paper (Create Your Own Client Apps Using SAS Integration Technologies), I've been trying to invent some useful examples that you
SAS author's tip: Using JMP to conduct a significance test
This week's tip is from Robert Carver and his book Practical Data Analysis with JMP. If you're a JMP user, be sure to take a look at additional bonus content from the book. The following excerpt is from SAS Press author Robert Carver and his book "Practical Data Analysis with JMP". Copyright © 2010, SAS
SAS analysis of the #1 most popular baby names
I'm sure that most of you have seen the really cool interactive Baby Name Voyager, right? If not, go have a look and try it out (be sure to plug in your name, and the names in your family, and so on). Here's a screen-capture: That's a pretty cool application! ...
What happens if you misspecify the parameters for the "Table" distribution?
I have previously written about how to use the "table" distribution to generate random values from a discrete probability distribution. For example, if there are 50 black marbles, 20 red marbles, and 30 white marbles in a box, the following SAS/IML program simulates random draws (with replacement) of 1,000 marbles:
Master data model requirements
David Loshin discusses master data model requirements.
Empty subscripts: How to fill rows and columns of a matrix
Suppose that you have a SAS/IML matrix and you want to set each element of a submatrix to zero (or any other value). There is a simple syntax that accomplishes this task. If you subscript a matrix and do not specify a row, it means "use all rows." So, for
SAS author's tip: Creating a composite index for a new SAS table
This week's tip is from Michael Raithel and his classic book The Complete Guide to SAS Indexes. Michael has a wealth of SAS experience and is a frequent and sought-out speaker at SAS Global Forum and regional user group conferences. If you get the opportunity to hear him speak, don't
Old ways of local government communication not enough in today’s tech-driven world
Recently, I was having lunch with a city council member who shared a litany of comments about the outstanding job the city and its staff does in all areas of city operations. She remarked on how little the public understands about all the city does and how efficiently it’s done.
What are the odds of ... winning the lottery?
What are the odds of winning the lottery? This seems like a simple question (and yes, there is a simple answer), but there are a few technical details to work out first... Which lottery? Let's say the Powerball Lottery. When? The number of balls used in the Powerball lottery has
How to access any program or data set that appears in the SAS/STAT documentation
If you are like me, you've experienced the following frustration. You are reading the SAS/STAT documentation, trying to understand some procedure or option, when you find an example that is very similar to what you need. "Great," you think, "this example will help me understand how the SAS procedure works!"
Mathematical squiggles in SAS
John D. Cook shared a picture of "pretty squiggles" on his blog, as well as a prose description of the mathematics behind it. I'm more of a programmer than a mathematician, but I've attempted to transcribe his description into a SAS program. I used DATA step to generate the point
3 ways PROC DOCUMENT can make your life easier
PROC DOCUMENT makes your life easier by giving you the freedom from the pre-determined order in which SAS stores procedure output. You can also label, manage, and search your output so that it is at your fingertips when you need it. You can learn what a DOCUMENT does and get
Technical requirements for MDM/DW Integration
David Loshin explains the technical requirements for MDM/DW integration.
Time to trade in your jalopy macro?
Suppose you have an old jalopy that's perfectly reliable. Your jalopy gets you where you wanna go: no frills; no drama. Do you trade your old wheels in for a racecar that accelerates like crazy and corners like it's on rails? Or stick with what's old and comfortable? Your choice
How the J function got its name
In linear algebra, the I symbol is used to denote an n x n identity matrix. The symbol J (or sometimes 1) is used to denote an n x p matrix of ones. When the SAS/IML language was implemented, the I function was defined to generate the identity matrix. The J function was defined
If Netflix had used my viewing history to create its new show
Netflix has made a big splash in the news with its use of big data. By analyzing millions of data points about the viewing habits of its customers, the movie delivery giant used the insight it gained to devise the "perfect show". One of the defining characteristics of the show,
SAS author's tip: SAS/ACCESS interface to Microsoft SQL server
This week's SAS tip is from Frederick Pratter and his book Web Development with SAS by Example, Third Edition. The many real-world examples in the book guide lend it to being frequently excerpted on this blog! Previously featured tips include: Formatting XML documents, Configuring TCP security, and SQL pass-through. The following excerpt is from SAS
Guest Blogger: Len Tashman previews Winter 2013 issue of Foresight
Editor Len Tashman's Preview of Foresight Foresight has always presented its methods-based articles as either tutorials, which introduce and illustrate a methodology in nontechnical language, or as case studies, with a focus on the practical issues and challenges in generating forecasts. We lead off this issue with two practical issues articles. First, Stephan
How to make weather forecasting look good
Compare it to predicting the economy. So concludes an ABC News Australia story by finance reporter Sue Lannin, entitled "Economic forecasts no better than a random walk." The story covers a recent apology by the International Monetary Fund over its estimates for troubled European nations, and an admission by the
SAS-Termine 2013 - Highlights
Für einige der genannten Veranstaltungen haben wir ein kleines Kontingent an Freikarten: Bei Interesse bitte einfach anschreiben. Unter anderem ist SAS auf folgenden Events präsent:
A SAS graph for the Chinese New Year
I like to think that I have a graph for all occasions - Chinese New Year is no exception! ... The exact date of the Chinese New Year varies from year to year, because it's based on the lunar (moon) cycles. I thought it would be useful to create a
Find variables common to multiple data sets
Last week the SAS Training Post blog posted a short article on an easy way to find variables in common to two data sets. The article used PROC CONTENTS (with the SHORT option) to print out the names of variables in SAS data sets so that you can visually determine
Business forecasting effectiveness at the APICS Triangle Chapter (February 12)
If you happen to be in Raleigh, NC next Tuesday evening, please come out for the APICS Triangle Chapter professional development meeting, 6:00-8:00 pm. While I can't make any promises about the caliber of the evening's speaker (me), you are assured a good meal and good conversation with representatives from
A database professional’s best friend
To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does SQL do your work? (From my previous post you
Hats and apps on tap for my #SASGF13
When I travel to San Francisco in April for SAS Global Forum 2013, it will make my 12th time to attend the international SAS users group conference, and my 7th consecutive year. A lot of people assume that I automatically go every year, but the truth is that SAS employees
Simulate discrete variables by using the "Table" distribution
I wanted to write a blog post about the "Table distribution" in SAS. The Table distribution, which is supported by the RAND and the RANDGEN function, enables you to specify the probability of selecting each of k items. Therefore you can use the Table distribution to sample, with replacement, from