All Posts
Will indexing my SAS data sets help? This is one of the most frequent questions I hear in SAS Technical Support. The response is always the same: “Maybe. Tell me about your data, and what you are doing with it.” Here is a primer on effective indexing. Indexing can improve
You’d better watch YouTube, you’d better not cry You’d better not post, I’m telling you why Big data is coming to town He’s making many lists (and selling them too), he’s writing it twice (for redundancy’s sake), He’s gonna find out whose naughty or nice Big data is coming to town
さて、今回ご紹介する例は、最近議論が活発な、「機械（コンピューター）が人間の作業を奪う（？）」お話です。 機械は人間から仕事（今回の例では、仕事ではなく娯楽と言ったほうが近いかもしれません）を奪ったことになるのでしょうか？それとも、真の楽しみを味わえるように、単に単純労働から開放してくれただけなのでしょうか？ 昨今、人工知能がもたらす変化という文脈で行われている議論ですが、今回は、昔からある最適化アルゴリズムで、人間の仕事を奪います。皆さんでその意味を考えてみてください。 イギリスの諜報機関GCHQがクリスマスメッセージとして送った難解なパズルが公開されており、優秀な人たちを楽しませています。その第一問が、以下の「お絵かきロジック」です。日本でも一時期流行しました。イラストロジックなどとも言われ、私自身もトライした記憶があります。 このパズルそのものについては、他の情報源に頼って欲しいのですが、簡単に説明すると、それぞれのセルを黒か白で塗りつぶすパズルで、行と列に書かれている数字は、黒マスが連続している数を順番どおりに示している「手がかり」です。いくつかのセルはすでに黒く塗りつぶされていますが、それらはこのパズルの答えを一つに確定するために必要です。 一部の箇所は、それぞれの行や列の情報だけを見て解くことが可能です。例えば、７番目の行を見てみましょう。手がかりは、(7 1 1 1 1 1 7)です。すなわち、全部で 7 + 1 + 1 + 1 + 1 + 1 + 7 = 19 個の黒いセルが必要となり、最低ひとマスは間隔が空いていないといけないので、7個の固まりの間の個数を考慮すると、7-1=6 個の白マスが必要となります。この二つの数字を足すと、19 + 6 = 25 となり一行の列数とおなじ数にちょうどなります。したがって、この結果から直ちにこの行の全てがあきらかになります。 黒7, 白1, 黒1, 白1, ・・・ ついてきていますよね。 しかし、そうは簡単にいかない箇所のほうが多いでしょう。その場合には、手がかりから部分的にしか黒く塗りつぶせないことになります。例えば、一行目を見てください。ヒントから(7 + 3 + 1 + 1 + 7) + (5
Over the course of my career as industrial engineer turned supply chain planning advocate I've had the opportunity to work hands-on with many manufacturing and supply chain planning solutions. This has included solutions offered commercially by the usual suspects of ERP and post-SCM consolidation supply chain solution providers. Most of these
In 2014, big data was on everyone’s mind. So in 2015, I expected to see data quality initiatives make a major shift toward big data. But I was surprised by a completely new requirement for data quality, which proves that the world is not all about big data – not
Here goes - a title for this week’s blog. Hmmm – How about “A few of my favorite things?” Um, no. I think, for me – what would be more apt is “Self Care during the holidays”, or maybe – “Some ways I try to stay sane during the holidays
Sometimes when trying to fuzzy match names you want to fuzzy match just a portion of the name: for example, Family Name and/or Given Name. A common mistake that people make is to feed in the Family Name and Given Name columns separately into the Match Codes node instead of
If you're just a casual Star Wars fan, you might be confused about the order of the movies. Here's a SAS graph that will help you make sense of it all, before Episode VII comes out this week! If you'd like to see how I created this custom graph, here's a
Bube, Dame, König, Ass oder die vier unterschiedlichen Arten von Anwendern die man in Datenmanagementprojekten überzeugen muss. Bube, Dame, König, Ass - Man könnte auch pokern (Excel reicht nicht).
Twenty-five years ago (when I was 12 years old), we realized that data, across the corporation, was not integrated. Nor did our data let us predict the future by looking at the past. So we started creating these stores of historical data soon to be called “data warehouse.” Here are
We want to extend a huge thank you to everyone who donated their leftover (and excess) Halloween candy this year, you outdid yourselves!! We tipped the scales at just under 250 pounds of candy! So what happened to ALL that candy? Well, we are happy to report that we were able
When we talk about the Internet of Things and “analytics at the edge,” we’re talking about modeling data as close as possible to the device – not far away in some warehouse or data storage appliance. So, generally, the edge is anything with a sensor that is transmitting data: an
Confusion is one of the big challenges companies experience when defining the data governance function – particularly among the technical community. I recently came across a profile on LinkedIn for a senior data governance practitioner at an insurance firm. His profile typified this challenge. He cited his duties as: Responsible for the collection
What would it take for you to keep 60 students interested and on task in a classroom for an entire hour? Some kind of magic or trickery? Maybe a bribe? Nope, all you need is an Hour of Code lesson plan, and you’ll be teaching computer programming to a classroom
The British spy agency GCHQ recently posted a grid-shading puzzle that the director sent out in his Christmas cards this year. The puzzle, shown here, is known as a nonogram and by various other names, including Paint by Numbers and FigurePic: Each cell is to be colored black or white,