Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Rick WicklinSeptember 7, 2017 0

Construct polynomial effects in SAS regression models

If you use SAS regression procedures, you are probably familiar with the "stars and bars" notation, which enables you to construct interaction effects in regression models. Although you can construct many regression models by using that classical notation, a friend recently reminded me that the EFFECT statement in SAS provides

Read More

Advanced Analytics | Programming Tips

Makoto Unemi (畝見真)September 4, 2017 0

SAS Viyaで線形回帰

SAS Viyaで線形回帰を行う方法を紹介します。言語はPythonを使います。 SAS Viyaで線形回帰を行う方法には大きく以下の手法が用意されています。多項回帰：　simpleアクションセットで提供。一般化線形回帰または一般線形回帰：　regressionアクションセットで提供。機械学習で回帰：　各種機械学習用のアクションセットで提供。今回は単純なサインカーブを利用して、上記3種類の回帰モデルを作ってみます。【サインカーブ】 -4≦x<4の範囲でサインカーブを作ります。普通に $$y = sin(x) $$を算出しても面白みがないので、乱数を加減して以下のようなデータを作りました。これをトレーニングデータとします。青い点線が $$y=sin(x)$$ の曲線、グレーの円は $$y=sin(x)$$ に乱数を加減したプロットです。グレーのプロットの中心を青い点線が通っていることがわかります。今回はグレーのプロットをトレーニングデータとして線形回帰を行います。グレーのプロットはだいぶ散らばって見えますが、回帰モデルとしては青い点線のように中心を通った曲線が描けるはずです。トレーニングデータのデータセット名は "sinx" とします。説明変数は "x"、ターゲット変数は "y" になります。各手法で生成したモデルで回帰を行うため、-4≦x<4 の範囲で0.01刻みで"x" の値をとった "rangex" というデータセットも用意します。まずはCASセッションを生成し、それぞれのデータをCASにアップロードします。 import swat host = "localhost" port = 5570 user = "cas" password = "p@ssw0rd"

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonSeptember 1, 2017 0

Where do modern day pirates attack?

International Talk Like a Pirate Day is Sept 19 ... which always gets me thinking and wondering about modern-day pirates. Most movies usually focus on pirates from the Golden Age of piracy (a couple hundred years ago), when pirates typically stole ships and booty (treasure). But modern day pirates usually board

Read More

Government | Travel

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 30, 2017 0

Advanced ODS Graphics: Examining and processing templates

This post shows a variety of techniques including how to use PROC TEMPLATE and the SOURCE statement, PROC SGPLOT with multiple Y-axis tables, create comparable axes in two side-by-side graphs, create a broken axis, write and use a table template that wraps text, and find and display examples of certain statements in graph templates and fonts in style templates.

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 25, 2017 0

Using Notepad++ as your SAS code editor

News flash: My favorite SAS code editor is SAS Enterprise Guide. However, my favorite general purpose text editor is Notepad++, and I often find myself using that tool for viewing SAS log files and for making small modifications to SAS programs. Judging from the popularity of this SAS Support Communities

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 25, 2017 0

When's the next total solar eclipse?

The U.S. was really fortunate in having the recent total solar eclipse pass through so many of its states! This gave lots of people an opportunity to see it, with just a short (or moderate) drive. I think a little kid spoke for all of us when they said "Let's

Read More

Learn SAS | Programming Tips | Students & Educators

Matt ScicchitanoAugust 24, 2017 0

How to prepare for a SAS Certification Exam

I have been working in the field of Professional Certification and Licensure for roughly 10 years. In that time, I've worked with and observed close to 40 IT certification programs and there has been a recurring question I've encountered at each stop. While it is often phrased differently, it means mostly the same

Read More

Programming Tips

Rick WicklinAugust 23, 2017 0

The arithmetic-geometric mean

All statisticians are familiar with the classical arithmetic mean. Some statisticians are also familiar with the geometric mean. Whereas the arithmetic mean of n numbers is the sum divided by n, the geometric mean of n nonnegative numbers is the n_th root of the product of the numbers. The geometric

Read More

Learn SAS | Programming Tips

Kevin RussellAugust 21, 2017 0

Always save your code when creating a stored compiled macro

The stored compiled macro facility enables you to compile and save your macro definition in a permanent catalog in a library that you specify. The macro is compiled only once. When you call the macro in the current and subsequent SAS® sessions, SAS executes the compiled code from the macro

Read More

Data Visualization | Programming Tips

Robert AllisonAugust 21, 2017 0

Can you see these spots (after viewing the eclipse)?

Hopefully if you're viewing the eclipse today, you'll be using one of the safe methods that won't harm your eyes! ... But if you're somewhat of a trickster, here's an optical illusion you can send your friends after the eclipse, that might make them wonder (just for a second) if

Read More

Sports & Entertainment

Programming Tips

Rick WicklinAugust 21, 2017 0

6 tips for timing the performance of algorithms

When you implement a statistical algorithm in a vector-matrix language such as SAS/IML, R, or MATLAB, you should measure the performance of your implementation, which means that you should time how long a program takes to analyze data of varying sizes and characteristics. There are some general tips that can

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 18, 2017 0

Code debugging and program history in SAS Enterprise Guide

SAS programmers have high expectations for their coding environment, and why shouldn't they? Companies have a huge investment in their SAS code base, and it's important to have tools that help you understand that code and track changes over time. Few things are more satisfying as a SAS program that

Read More

Programming Tips

Gerry NelsonAugust 17, 2017 0

SAS Viya sharing credentials for database access

SAS Viya deployments use credentials for accessing databases and other third-party products that require authentication. In this blog post, I will look at how this sharing of credentials is implemented in SAS Environment Manager. In SAS Viya, domains are used to store the: Credentials required to access external data sources. Identities

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 17, 2017 0

Mapping out the next robot invasion!

Robots - everyone has probably been fascinated by the idea of robots at one time or another. From the early science fiction robots (such as Klaatu's robot Gort) to the mid-1980s movie robots (like Johnny 5), they have been portrayed in many different ways in fiction. These days, with the

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 15, 2017 0

Tracking floods and droughts in Jordan Lake, NC

If you know me, you probably know that I spend a lot of time on the water. I like speed paddling (dragon boat, outrigger canoe, surfski, and racing SUP), and I also have a big pontoon boat at Jordan Lake where I try to go fishing at least once a

Read More

Energy & Utilities | Government | Sports & Entertainment

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 14, 2017 0

Advanced ODS: Controlling precisely what output is displayed

PROC SGPLOT displays titles inside the graph. If you want to display a title inside the graph and a different title outside the graph, you can use the ODS LAYOUT or the GTL. The ODS LAYOUT gives you precise control over your output and enables you to display multiple graphs and tables in each page.

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonAugust 14, 2017 0

How far are you from North Korea?

With North Korea's growing missile capabilities in the news lately, I thought it would be interesting to create a map showing how far (or close) they are from other parts of the world. I first did a few searches on the Web, to see what maps are already out there.

Read More

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

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

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

Programming Tips

Chris Hemedinger

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

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

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

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

Programming Tips

Broken-stick method for retaining principal components

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

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

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

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

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

Learn SAS | Programming Tips

jump list in Windows

Chris Hemedinger

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

Previous 1 … 40 41 42 43 44 … 65 Next