Learn SAS | Programming Tips

Ron CodyMay 26, 2017 0

Standardizing phone numbers using SAS

How many times have you entered a phone number on a web page, only to be told that you did not type it the "correct" form? I find that annoying. Don't you? In my latest book, Cody's Data Cleaning Techniques, 3rd edition, I show how to convert a phone number

Read More

English

Learn SAS | Programming Tips

Charu ShankarMay 25, 2017 0

Take that SAS option

Elizabeth is courageous. Scoliosis since birth, corrective spinal surgery replaced her spine with steel, tripping on stairs permanently broke her right ankle. Then she decided to come take yoga with me. To help ease back pain & reduce hip stress, I offered options like bent legs not cross. In class

Read More

English

Programming Tips

Jody CarltonMay 19, 2017 0

Demystifying and resolving common transcoding problems

Technical Support regularly receives incoming calls from customers who have encountered the following transcoding warning: WARNING: Some character data was lost during transcoding in the data set xxx.xxx. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding People are not always

Read More

English

Learn SAS | Programming Tips

Michael A. RaithelMay 15, 2017 0

The Little SAS Program’s Big Night Out

The little SAS program’s official name was Extract_Transform_Load_ 0314.sas.  But, that name was much too formal, way too long, and did not roll off of the tongue very easily at all.  So, everybody simply called her:  ETL Pi. ETL Pi was conceived in a 2-hour project strategy meeting in conference

Read More

English

Learn SAS | Programming Tips

Rick WicklinMay 15, 2017 0

INTCK and INTNX: Two essential functions for computing intervals between dates in SAS

Last week I showed a timeline of living US presidents. The number of living presidents is constant during the time interval between inaugurations and deaths of presidents. The data was taken from a Wikipedia table (shown below) that shows the number of years and days between events. This article shows

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonMay 12, 2017 0

Map of idioms, from around the world

An idiom is a group of words established by usage as having a meaning not deducible from those of the individual words. For example, "don't cry over spilled milk,"  or "the cat is out of the bag." Idioms are fun to use, and fun to hear - don't you agree? And

Read More

English

Education | Travel

Learn SAS | Programming Tips

Rick WicklinMay 10, 2017 0

Simulate lognormal data in SAS

A SAS customer asked how to simulate data from a three-parameter lognormal distribution as specified in the PROC UNIVARIATE documentation. In particular, he wanted to incorporate a threshold parameter into the simulation. Simulating lognormal data is easy if you remember an important fact: if X is lognormally distributed, then Y=log(X)

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonMay 9, 2017 0

How to add rivers and lakes to your SAS maps

Water is in the news more & more lately - people seem to either have too much, or too little, at any given time. Therefore being able to plot rivers and lakes on a map could be a very useful skill to add to your graphical bag of tricks. A few

Read More

English

Government

Programming Tips

Rick WicklinMay 8, 2017 0

Timeline of living US presidents

Quick! What is the next term in the numerical sequence 1, 2, 1, 2, 3, 4, 5, 4, 3, 4, ...? If you said '3', then you must be an American history expert, because that sequence represents the number of living US presidents beginning with Washington's inauguration on 30APR1789 and

Read More

English

Programming Tips

Chris HemedingerMay 7, 2017 0

How to download and convert CSV files for use in SAS

In his recent article Perceptions of probability, Rick Wicklin explores how vague statements about "likeliness" translate into probabilities that we can express numerically. It's a fun, informative post -- I recommend it! You'll "Almost Certainly" enjoy it. To prepare the article, Rick first had to download the source data from

Read More

English

Analytics | Programming Tips

Lavanya MandavilliMay 4, 2017 0

Linking to target reports and sections in SAS Visual Analytics 7.4

SAS Visual Analytics 7.4 comes chock-full of new features. Report and section linking come with an added benefit. If you set up linking from one section to another section in the same report, or from one report to another report, you have the option to configure linking such that any filter

Read More

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanApril 27, 2017 0

Automating the loading of multiple database tables into SAS tables

When developing SAS applications, you can feed database tables into your application by using the libname access engine either by directly referring a database table, or via SAS or database views that themselves refer to one or more of the database tables. More on Automation with SAS: Let SAS write

Read More

English

Analytics | Data Visualization | Programming Tips

Rick WicklinApril 26, 2017 0

Visualize a design matrix

Most SAS regression procedures support a CLASS statement which internally generates dummy variables for categorical variables. I have previously described what dummy variables are and how are they used. I have also written about how to create design matrices that contain dummy variables in SAS, and in particular how to

Read More

English

Data Visualization | Programming Tips

Robert AllisonApril 25, 2017 0

Using loops in your SAS graph code

If you're a SAS programmer, you have likely used loops in your SAS code to make life easier from time to time. In this blog post, I demonstrate a few ways you can use loops to do clever things in your graph code. Perhaps even the old dogs can learn

Read More

English

Learn SAS | Programming Tips

Kirk Paul LaflerApril 25, 2017 0

Determining the size of a SAS data set

When developing SAS® data sets, program code and/or applications, efficiency is not always given the attention it deserves, particularly in the early phases of development. Since data sizes and system performance can affect a program and/or an application’s behavior, SAS users may want to access information about a data set’s

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonApril 21, 2017 0

Your mapping toolkit tip #6 - Geocoding your addresses

You've got a database containing the addresses of all your customers ... but how can you plot them on a map or analyze them spatially? First, you'll need to convert the address into a numeric coordinate (latitude & longitude). SAS can do that ... with Proc Geocode! But before we

Read More

English

Programming Tips

Martin MinceyApril 21, 2017 0

Use SAS to send an email that embeds a graph in the body of the email

When using the SAS® system to email graphics output, a common request is to use SAS to send an email in which the graphics output is embedded in the body of the email. This functionality is not available until the second maintenance release for SAS® 9.4 (TS1M2). If you are

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldApril 20, 2017 0

Advanced ODS Graphics: Steps to think about when creating a graph

Today, I focus on the steps needed to make a graph that is composed of multiple heterogeneous components (in this case, dendrograms and a heat map).

Read More

English

Advanced Analytics | Learn SAS | Programming Tips

Rick WicklinApril 19, 2017 0

Regression with restricted cubic splines in SAS

Restricted cubic splines are a powerful technique for modeling nonlinear relationships by using linear regression models. I have attended multiple SAS Global Forum presentations that show how to use restricted cubic splines in SAS regression procedures. However, the presenters have all used the %RCSPLINE macro (Frank Harrell, 1988) to generate

Read More

English

Learn SAS | Programming Tips | SAS Events

Jane EslingerApril 18, 2017 0

How to control the name of Excel sheets when they are all created at once

Ok, so you know how to create multiple sheets in Excel, but can anyone tell me how to control the name of the sheets when they are all created at once? In the ODS destination for Excel, the suboption SHEET_INTERVAL is set to TABLE by default.  So what does that

Read More

English

Data Visualization | Learn SAS | Programming Tips

SAS KoreaApril 18, 2017 0

Proc SGplot으로 '멋진' 지도를 만드는 법

예술가들은 몇 가지 도구만으로도 멋진 그림을 그릴 수 있습니다. 물론, 물감, 색연필, 목탄 등 선호하는 도구는 저마다 다를 수 있겠지만 말이죠. SAS에서 멋진 그래프를 만드는 방법도 크게 다르지 않은데요, 오늘은 그 방법을 예를 들어 설명해보고자 합니다. SAS에서는 SAS/Graph Proc GMap을 사용하여 멋진 지도를 만들 수가 있습니다. GMap은 SAS가 지도 제작용으로 특별 개발한

Read More

Korean

Data Visualization | Learn SAS | Programming Tips

Robert AllisonApril 17, 2017 0

Your mapping toolkit tip #5 - determine which sales region your customers are in

A new prospective customer enters their personal information on your web page, and they want to have a sales rep contact them ... but you need to know which sales region they're in, so you can assign them to a sales team. Now, multiply that by thousands of prospective customers!

Read More

English

Programming Tips

Chris HemedingerApril 14, 2017 0

Using SAS to access Google Analytics APIs

Every day before I even wake up, I have little "SAS robots" that do work for me. These are SAS batch jobs that gather data from external services and build data marts, generate reports, and send e-mail. One of those SAS jobs gathers Google Analytics data about our SAS blogs

Read More

English

Learn SAS | Programming Tips

Leonid BatkhanApril 13, 2017 0

One deadly sin SAS programmers should stop committing

Even if you are a traditional SAS programmer and have nothing to do with cybersecurity, you still probably have to deal with this issue in your day-to-day work. The world has changed, and what you do as a SAS programmer is not just between you and your computer anymore. However,

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonApril 13, 2017 0

Your mapping toolkit tip #4 - importing maps into SAS

SAS provides a map for each country, but there are likely other maps you want to use that SAS does not provide. If you have other maps in the Esri shapefile format, you're in luck - you can import those maps and use them! In this blog post I share

Read More

English

Learn SAS | Programming Tips

Susan SlaughterApril 12, 2017 0

What’s your SAS interface?

I recently asked a SAS user, “Which interface do you use for SAS?” She replied, “Interface? I just install SAS and use it.” “You’re using the SAS windowing environment,” I explained, but she had no idea what I was talking about. This person is an extremely sophisticated SAS user who

Read More

English

Data Visualization | Programming Tips

Robert AllisonApril 12, 2017 0

Your mapping toolkit tip #3 - removing internal borders

In recent versions of SAS/Graph, we have been shipping new/updated maps of each country, with 2 levels of detail (such as state & county, or province & division). But what if you only want a map showing the higher level of detail? In this blog post I share my third

Read More

English

Analytics | Programming Tips

Rick WicklinApril 12, 2017 0

Quadratic optimization in SAS

At SAS Global Forum last week, I saw a poster that used SAS/IML to optimized a quadratic objective function that arises in financial portfolio management (Xia, Eberhardt, and Kastin, 2017). The authors used the Newton-Raphson optimizer (NLPNRA routine) in SAS/IML to optimize a hypothetical portfolio of assets. The Newton-Raphson algorithm

Read More

English

Data Visualization | Programming Tips

Robert AllisonApril 11, 2017 0

Your mapping toolkit Tip #2 - projecting your map

Have you ever seen a map that just didn't look right to you? Perhaps the map area seemed squished or stretched? Perhaps this was because they used a different map projection than you were accustomed to. Or maybe the map coordinates weren't projected at all. In this blog post I

Read More

English

Data Visualization | Programming Tips

Robert AllisonApril 10, 2017 0

Your mapping toolkit Tip #1 - reducing border complexity

With the advent of things like car GPS & Google Maps, and a steady supply of nice maps from certain news sources (such as the New York Times), people have finally embraced the idea that mapping data can be very useful. And if you are into data visualization, you have

Read More

English