Advanced Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 10, 2017 0

So, 27 US states are farther north than Canada, eh?

With all the recent talk about some people wanting to move from the US to Canada, I got to wondering how cold, and how far north Canada is. And after a few Google searches, I was surprised to learn that 27 US states are actually farther north than the southernmost point

Read More

English

Government | Travel

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 9, 2017 0

Basic ODS Graphics: What is wrong with my SG annotation data set?

SG annotation is a powerful technique for adding text, lines, arrows, shapes, and images to graphs. This post provides a macro that can help you when you make a mistake in writing the annotations.

Read More

English

Programming Tips

Rick WicklinAugust 7, 2017 0

The curse of non-unique eigenvectors

A SAS customer asked, "I computed the eigenvectors of a matrix in SAS and in another software package. I got different answers? How do I know which answer is correct?" I've been asked variations of this question dozens of times. The answer is usually "both answers are correct." The mathematical

Read More

English

Programming Tips

Chris HemedingerAugust 4, 2017 0

Viewing SAS catalogs and formats in SAS Enterprise Guide

Many years ago I shared a custom task that allows you to view and manage SAS catalogs within SAS Enterprise Guide. As a reminder, a SAS catalog is a special type of SAS file that acts as a container, like a folder, for a variety of content items called catalog

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 4, 2017 0

Basic ODS Graphics: Axis Options

In this post, I will review some of graphs from previous posts while concentrating on just the axes, grid lines, and reference lines. They might not be the most exciting parts of a graph, but there are multiple options that when properly used can turn a good graph into a great graph.

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 2, 2017 0

Is your city in the path of the total eclipse?

There will be a total solar eclipse on August 21, 2017, and the umbra (total shadow) will pass right across the United States! As a data guy, a map guy, and an astronomy fan, this is an opportunity I just couldn't pass up! Follow along as I apply my computer skills

Read More

English

Life Sciences

Learn SAS | Programming Tips

Leonid BatkhanAugust 2, 2017 0

CALL EXECUTE made easy for SAS data-driven programming

In my prior posts (Data-driven SAS macro loops, Modifying variable attributes in all datasets of a SAS library, Automating the loading of multiple database tables into SAS tables), I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing

Read More

English

Programming Tips

Rick WicklinAugust 2, 2017 0

Dimension reduction: Guidelines for retaining principal components

Last week I blogged about the broken-stick problem in probability, which reminded me that the broken-stick model is one of the many techniques that have been proposed for choosing the number of principal components to retain during a principal component analysis. Recall that for a principal component analysis (PCA) of

Read More

English

Data Visualization | Programming Tips

Robert AllisonAugust 1, 2017 0

Learning to speak like a local, in North Carolina

A lot of tourists flock to North Carolina. We have beaches, wreck diving, and lighthouses. We have the Great Smoky Mountains with whitewater kayaking, colorful fall leaves, and snow skiing. We have hot air balloon festivals & Scottish highland games. Oh, and some of the best barbecue you've ever tasted! But

Read More

English

Travel

Learn SAS | Programming Tips

Rick WicklinJuly 31, 2017 0

Flip it. Flip it good.

A SAS user needed to convert a program from MATLAB into the SAS/IML matrix language and asked whether there is a SAS/IML equivalent to the fliplr and flipud functions in MATLAB. These functions flip the columns or rows (respectively) of a matrix; "LR" stands for "left-right" and "UD" stands for

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonJuly 27, 2017 0

Which states rely the most on federal funds?

I recently saw an interesting PEW study showing the percent of each state's revenue that came from federal funds. They had some pretty nice graphs ... but just like jell-o, there's always room for more graphs, eh! Let's start with the map. Their map had an informative title, a reasonable gradient

Read More

English

Government

Data Visualization | Programming Tips

Warren F. KuhfeldJuly 27, 2017 0

Advanced ODS Graphics: Equated Axes and the Aspect Ratio

When displaying maps, geometric shapes (such as circles), or results of certain analyses, it is important to equate axes. This post illustrates options in PROC SGPLOT that enable you to equate axes.

Read More

English

Learn SAS | Programming Tips

Chris HemedingerJuly 26, 2017 0

Open recent files with fewer clicks in SAS Enterprise Guide

I use SAS Enterprise Guide every day, and for a wide variety of tasks. As a result, I have a huge collection of project files (EGP files) and SAS program files. I have always relied on the "recently used" list in the File menu to provide me with quick access

Read More

English

Data Visualization | Programming Tips

Teri PatsilarasJuly 26, 2017 0

SAS Visual Analytics 8.1: Configuring prompts with different source data

In a previous blog, I describe how there are a few new features related to report and page prompts in SAS Visual Analytics 8.1; namely the ability to configure cascading prompts in VA 8.1: Cascading Prompts as Report and Page Prompts. In this blog, I will cover how to configure prompts, either

Read More

English

Programming Tips

Rick WicklinJuly 26, 2017 0

Random segments and broken sticks

A classical problem in elementary probability asks for the expected lengths of line segments that result from randomly selecting k points along a segment of unit length. It is both fun and instructive to simulate such problems. This article uses simulation in the SAS/IML language to estimate solutions to the

Read More

English

Learn SAS | Programming Tips

Larry LaRussoJuly 25, 2017 0

Programming tips from experienced SAS users

Trivial Pursuit, Justin Bieber and Timbits. Some pretty great things have come from Canada, eh? Well, you can go ahead and add expert SAS programmers to that impressive list. In this video, six Canadian SAS programmers, with more than 115 years of SAS programming experience between them, share some of their favorite, little-known SAS programming tips. You're sure to discover a new trick or

Read More

English

Analytics | Data Visualization | Programming Tips

SAS KoreaJuly 25, 2017 0

얼마나 많은 여성들이 STEM 학위를 취득하고 있을까요?

4차 산업혁명은 전 세계 산업 구조는 물론 교육 환경에도 큰 영향을 미치고 있습니다. 지난 몇 년간 빅데이터, 사물인터넷(IoT), 인공지능(AI) 등 산업혁명을 이끄는 기술을 다루기 위해 필수적인 STEM(과학, 기술, 공학, 수학) 분야 교육에 대한 수요과 공급이 증가했는데요. 이처럼 STEM 교육에 대한 관심이 높아지면서 드러난 명암이 있습니다. 전 세계적으로 STEM 분야의 여성 비율은

Read More

Korean

Education

Programming Tips

Rick WicklinJuly 24, 2017 0

Difference operators as matrices

For a time series { y1, y2, ..., yN }, the difference operator computes the difference between two observations. The kth-order difference is the series { yk+1 - y1, ..., yN - yN-k }. In SAS, the DIF function in the DATA step computes differences between observations. The DIF function

Read More

English

Programming Tips

Kathryn McLawhornJuly 21, 2017 0

Selecting the top n% and bottom n% of observations from a data set

SAS® offers several ways that you can find the top n% and bottom n% of data values based on a numeric variable. The RANK procedure with the GROUPS= option is one method. Another method is The UNIVARIATE procedure with the PCTLPTS= option. Because there are several ways to perform this

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonJuly 20, 2017 0

Risks to US employment - automation and offshoring

Employment - that's been a hot topic here in the US lately. Many of the manufacturing jobs we had in past decades are gone now, and it would be great if there was a crystal ball to predict which jobs might be at risk of disappearing in the future. The

Read More

English

Government | Manufacturing

Data Visualization | Programming Tips

Robert AllisonJuly 19, 2017 0

Songs most frequently banned at weddings!

A lot of my friends seem to be getting married these days. Which got me thinking about wedding parties. Which then got me wondering what songs DJs do/don't play at weddings these days. And what was the outcome of my meandering thoughts ... a fun & interesting graph, of course! It

Read More

English

Sports & Entertainment

Learn SAS | Programming Tips

Lora D. DelwicheJuly 18, 2017 0

Organize your work with SAS® Enterprise Guide® Projects

Nowadays, whether you write SAS programs or use point-and-click methods to get results, you have choices for how you access SAS. Currently, when you open Base SAS most people get the traditional SAS windowing environment (aka Display Manager) as their interface. But it doesn’t have to be that way. If

Read More

English

Programming Tips

Chris HemedingerJuly 17, 2017 0

Customize your keys in SAS Enterprise Guide with AutoHotkey

SAS power users (and actually, power users of any application) like to customize their environment for maximum productivity. Long-time SAS users remember the KEYS window in SAS display manager, which allows you to assign SAS commands to "hot keys" in your SAS session. These users will invest many hours to

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonJuly 13, 2017 0

Are more women getting STEM degrees?

For the past several years, efforts have been under way to recruit more women into the STEM (science, technology, engineering, and math) fields. I recently saw an interesting graph showing the percentage of bachelor's degrees conferred to women in the US, and I wondered if I could tweak that graph

Read More

English

Education

Advanced Analytics | Programming Tips

Rick WicklinJuly 12, 2017 0

The bias-corrected and accelerated (BCa) bootstrap interval

I recently showed how to compute a bootstrap percentile confidence interval in SAS. The percentile interval is a simple "first-order" interval that is formed from quantiles of the bootstrap distribution. However, it has two limitations. First, it does not use the estimate for the original data; it is based only

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldJuly 11, 2017 0

Basic ODS Graphics: Enabling, Selecting and Displaying Graphs

This post presents some basic aspects of ODS Graphics: enabling, selecting, and displaying graphs.

Read More

English

Programming Tips

Rick WicklinJuly 10, 2017 0

Bootstrap estimates in SAS/IML

I previously wrote about how to compute a bootstrap confidence interval in Base SAS. As a reminder, the bootstrap method consists of the following steps: Compute the statistic of interest for the original data Resample B times from the data to form B bootstrap samples. B is usually a large

Read More

English

Analytics | Programming Tips

Rick WicklinJuly 5, 2017 0

Test for the equality of two proportions in SAS

A SAS customer asked how to use SAS to conduct a Z test for the equality of two proportions. He was directed to the SAS Usage Note "Testing the equality of two or more proportions from independent samples." The note says to "specify the CHISQ option in the TABLES statement

Read More

English

Advanced Analytics | Programming Tips

Makoto Unemi (畝見 真)July 3, 2017 0

SAS Viyaでフーリエ変換

みなさま、こんにちは。 さて突然ですが、フーリエ変換ってご存知ですか？ おそらく物理学や経済学で波形データを分析したことのある方には馴染みがあるでしょうが、フーリエ変換は波形データを扱う手法です。 フーリエ変換では周期的な波形を、sin波やcos波の重ね合わせで説明しようというものです。 たとえば以下のような波形データは、どの時間にどのくらいの強さの波が流れているかを表現しています。 これをフーリエ変換することで、周波数と振幅で表すことができるようになります。 ↓　フーリエ変換！　↓   従来のSAS製品では波形データでフーリエ変換をする機能を提供していなかったのですが、SAS ViyaのSAS Forcastingという製品を使うことで、フーリエ変換を実施することができるようになりました。 SAS Viyaでできるのは短時間フーリエ変換（Short time Fourier transform）です。 今回はSAS Viyaでフーリエ変換を実施してみたいと思います。プログラミング言語はPythonを使用します。 まずは前準備として、必要なライブラリをインポートし、CAS sessionを作成します。 CAS sessionはSAS Viyaでデータ分析を行うCASというエンジンへ認証し、接続するものです。 # CAS sessionの用意 import swat   host = "localhost" port = 5570 user = "user" password = "p@ssw0rd"   mysession = swat.CAS(host, port, user, password)   #

Read More

Japanese

Programming Tips

Chris HemedingerJuly 3, 2017 0

Ten SAS Enterprise Guide program editor tricks

If you spend a lot of time in SAS Enterprise Guide (as I do), you probably get to know its features pretty well. But we don't always take the time to explore as we should, so there might be a few golden nuggets of editor knowledge that have escaped you

Read More

English