Dictionary tables are one of the things I love most about SQL! What a useful thing it is to be able to programmatically determine what your data looks like so you can write self-modifying and data-driven programs. While PROC SQL has a great set of dictionary tables, they all rely
Uncategorized
La vida de un infante es frágil y cuelga de un delgado hilo. Desde los recién nacidos prematuros hasta los bebés con meses de edad que luchan con problemas médicos, las unidades de cuidados intensivos neonatales (UCIN) tienen que estar preparadas para todo. Es por eso que los médicos, las
여러분은 ‘프로파일링(profiling)’하면 뭐가 제일 먼저 생각나나요? 아마 많은 분들이 범인을 추적하는 범죄 프로파일러(profiler)를 떠올릴 것 같은데요. 맞습니다. 프로파일링은 범죄 현장과 증거를 분석해 용의자의 범행 수법은 물론 성별, 나이, 습관, 성격, 직업 등을 추론하고 범인을 찾아내는 범죄 수사 기법 중 하나인데요. 최근 범죄 심리학을 다룬 드라마와 영화가 큰 인기를 끌며 대중에
Here in the US, we typically use top level domains such as .com, .gov, and .org. I guess we were one of the first countries to start using web domains in a big way, and therefore we kind of got squatter's rights. As other countries started using the web, they
David Loshin says simple approaches to identity resolution may not scale on a big data platform as data volumes increase.
Musings on Menopause and Fitness What the heck is happening to me??? I’m not sure if I’m happy or sad, freezing or on fire, coming or going, want to be healthy or eat an XL Papa Murphy pizza… Hormotional…Menopause… Like Mother Nature wasn’t cruel enough with menstruation, pregnancy, labor, delivery
みなさんは、SAS Viyaを無償で試す方法を知っていますか? 手順は簡単、 ① SAS Japanホームページ内のSAS Viya無償試用開始サイトにアクセス ② 無償試用版リストから希望の製品を選択 ③ SASプロファイル情報を登録 ④ 登録済みのSASプロファイル情報でサインイン ⑤ SASから届くメール内にある試用版サイトリンクをクリックし、同メール内に記載されたIDとパスワードでサインイン ⑥ SAS Viyaにサインインして試用開始 これだけです。 ※尚、このガイドは、2018年8月時点の内容に基づいて作成されています。利用手順は予告なく変更される場合がありますので、実際に表示される画面や送られてくるメール内容に従っての操作をお願いします。 ブラウザはChrome 64bit版が推奨です。(ブラウザは Chrome 61以上, Firefox 56以上, MS Edge40.1以上を使用してください) では、1ステップずつ詳しくご紹介しましょう。 ① SAS Japanホームページ内のSAS Viya無償試用開始サイトにアクセス 以下のリンクをクリックして、SAS Viya無償試用開始サイトを表示しよう。 https://www.sas.com/ja_jp/software/viya.html#preview ② 無償試用版リストから希望の製品を選択 この手順では、「SAS Visual Data Mining and Machine Learning」を選択した例で紹介しています。 (以下のリストに表示されていない製品に関しては、チュートリアル等使用をガイドするような資料は提供していませんが、同一環境内で試用することはできます。) ③ SASプロファイル情報を登録 (すでにSASプロファイル登録済みの場合は、このステップは必要ありません。) 以下の画面内で、「Create one」リンクをクリックします。
One way to assess the precision of a statistic (a point estimate) is to compute the standard error, which is the standard deviation of the statistic's sampling distribution. A relatively large standard error indicates that the point estimate should be viewed with skepticism, either because the sample size is small
Reading quite a lot of the press and commentary about analytics, you could be forgiven for thinking that these techniques were only usable for customer-facing work. Improving sales and marketing? Yes, you want analytics, using Big Data about your customers. But there are plenty of internal and operational issues where
A todos nos gusta ver nuestros productos favoritos con descuento, pero para que las organizaciones ejecuten una promoción, tienen que hacer mucho más que simplemente bajar los precios. Los costos reducidos llevan a un aumento de la demanda y a menos que esta se planifique con precisión, los fabricantes pueden
Today in higher education, savvy users expect to have the information they need to make data-informed decisions at their fingertips. As such, leaders in institutional research (IR) are under pressure to provide these users with accurate data, reports and analyses. IR has been tasked with transforming data and reports in
There have been several polarizing topics throughout history, such as religion & political affiliation. And for software developers there's one more biggie ... tabs -vs- spaces! Which group is right? Perhaps the opinion of the better programmers should have more weight(?) Is there a metric we can use to determine whether
Following the UK General Election result where no political party secured a clear majority ahead of the Brexit negotiations, it’s fair to say there’s lots of uncertainty facing the UK government right now. This, and the more outward looking post-Brexit era we're facing, are just two reasons why I believe
Most numerical optimization routines require that the user provides an initial guess for the solution. I have previously described a method for choosing an initial guess for an optimization, which works well for low-dimensional optimization problems. Recently a SAS programmer asked how to find an initial guess when there are
It has been almost a year since then-U.S. CIO Tony Scott introduced the federal open source policy that called for agencies to share federally-developed software source code. The policy, more than anything, aimed to make agencies more agile. Instead of redeveloping the same programs the open source policy would allow
If countries have a similar median age, does that mean they are also similar in other ways? My best guess at an answer is - probably. Perhaps if we plot the data on a map, we'll be able to see the answer more clearly. I first started thinking about this
Regulations, corporate drivers, leadership and market influences have combined to produce a patchwork of uneven progress on initiatives such as distributed generation, customer choice, asset optimization and the industrial Internet of Things. These initiatives all rely on analytics to gain the most return on investment. To better understand organizational readiness
In part 2, Jim Harris explains more about why you should address data quality and governance issues on the way to data lakes and Hadoop.
When I was in college, I lived in the Alexander dorm, where each room had an American student and an International student. I learned a lot about the rest of the world, and I also heard a lot of different languages being spoken. I'm really impressed when I hear people
There's been a lot of talk in the media lately about the death of retail. Every week, it seems like another retailer announces the closing of stores, acquisitions or even going out of business. Many relate it to the growing competitive landscape with the convenience of online shopping and lure
In a previous article, I showed two ways to define a log-likelihood function in SAS. This article shows two ways to compute maximum likelihood estimates (MLEs) in SAS: the nonlinear optimization subroutines in SAS/IML and the NLMIXED procedure in SAS/STAT. To illustrate these methods, I will use the same data
지난 3월 31일 막을 올린 ‘2017 KBO 프로야구 정규시즌’이 어느새 중반부를 넘어섰습니다. 개막 두 달 만인 5월 30일 최소 경기 수 기준 역대 다섯 번째로 누적 관중 300만명을 넘어서며 식지 않는 인기를 과시하고 있는데요! 이처럼 수많은 관중들의 마음을 얻기 위해 그라운드 위 선수들의 치열한 경기 외에도 야구장 곳곳에서 다양한 시도들이
‘세계 야생 동물의 날(World Wildlife Day)’에 대해 들어보셨나요? 지난 2013년, 국제 자연 보호 연맹(IUCN) 산하 ‘멸종위기에 처한 야생동식물종의 국제거래에 관한 협약(CITES: Convention on International Trade in Endangered Species of Wild Flora and Fauna)’의 170여개 체약국은 3월 3일을 멸종 위기에 처한 야생 동물·식물에 대한 관심과 대책을 촉구하는 기념일로 지정했습니다. 이에 따라
Maximum likelihood estimation (MLE) is a powerful statistical technique that uses optimization techniques to fit parametric models. The technique finds the parameters that are "most likely" to have produced the observed data. SAS provides many tools for nonlinear optimization, so often the hardest part of maximum likelihood is writing down
Registration is now open for the SAS Analytics Experience 2017, being held September 18-20, in Washington, DC. (The Analytics Experience moves to Amsterdam, October 16-18 -- details on that event to follow.) For anyone interested in FVA analysis, Chip Wells and I will be delivering a half-day pre-conference training session
If you were a fan of the original Star Trek television series, you probably remember lots of little details about the show. And you might even feel sorry for the people who don't get the clever references you make to things from the show. If you're that person, then you'll
Utilities can save as much as $10 million a year for every one percent improvement in forecast accuracy by optimizing asset utilization and trading strategies. Changing energy markets and an influx of data from the smart grid are providing more opportunities to reap value from energy forecasting. Improving energy forecasts
Todd Wright says addressing GDPR compliance might be just the catalyst the insurance industry needs.
In a world that never stands still, especially in the post-Brexit whirlwind the UK will soon be entering, it’s imperative that government is agile and responsive. More importantly, how can this capability be arrived at without breaking the bank? The UK Government recently released its Transformation Strategy 2017 to 2020.