Blogs

Blogs

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Learn SAS | Programming Tips

Ron CodyJune 6, 2017 0

Using regular expressions to verify the pattern of character data

Wait! Don't close this window. I understand that regular expressions can be very complicated (yes, there are many books on the subject), but some basic expressions to test patterns such as zip codes or telephone numbers are not that difficult. In addition, you can sometimes use Google to search for

Read More

Data Visualization | Learn SAS | Programming Tips

Robert AllisonJune 5, 2017 0

A medical dashboard for the Star Trek fans

As a kid who grew up in the 60s & 70s, I was a big fan of the original Star Trek TV series. And in the years since, I have seen lots of the Star Trek “technology” become a reality: cellphones, portable tablet computers, talking computers (Alexa/Siri), etc. But I

Read More

Health Care | Life Sciences

Learn SAS | Programming Tips

How to generate random numbers in SAS

Rick WicklinJune 1, 2017 0

How to choose a seed for generating random numbers in SAS

Last week I was asked a simple question: "How do I choose a seed for the random number functions in SAS?" The answer might surprise you: use any seed you like. Each seed of a well-designed random number generator is likely to give rise to a stream of random numbers,

Read More

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

Data Visualization | Learn SAS

Robert AllisonMay 26, 2017 0

Where to SCUBA dive in North Carolina

North Carolina is a very diverse state - especially when it comes to outdoor recreation opportunities. This weekend you could go hiking or kayaking in the mountains, watch a hot air balloon festival near Raleigh, and go wind surfing or fishing at the coast. And if you've got your SCUBA

Read More

Sports & Entertainment | Travel

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

Analytics | Learn SAS

Jeanne (Hyunjin) ByunMay 25, 2017 0

'SAS Viya'의 강력한 분석 환경을 소개합니다

오늘은 SAS에서 오랫동안 근무해온 프로그래머이자 데이터 사이언티스트의 SAS Viya 사용 후기를 공유해 드리려고 합니다. 새롭게 출시된 ‘SAS Viya(SAS 바이야)’ 환경을 사용해 본지는 이제 6개월이 지났는데, 벌써 푹 빠졌다고 합니다! SAS9 환경에서 사용했던 많은 통계 기법을 SAS Viya 환경에 동일하게 적용했을 때 그 속도와 더 높은 정확성에 감격했답니다. 그렇다면 데이터 사이언티스트가

Read More

Analytics | Data Visualization | Learn SAS

Robert AllisonMay 23, 2017 0

Foreigners in Germany - let's map it!

These days, more and more people move to where the work is. And for many people in Europe, that 'where' is Germany. I recently saw a map of Germany, that showed which country had the most foreigners living in each area. It was an interesting map, but I thought I might

Read More

Government | Travel

Analytics | Learn SAS

Visualization of percentile definitions in SAS

Rick WicklinMay 22, 2017 0

Quantile definitions in SAS

In last week's article about the Flint water crisis, I computed the 90th percentile of a small data set. Although I didn't mention it, the value that I reported is different from the the 90th percentile that is reported in Significance magazine. That is not unusual. The data only had

Read More

Analytics | Data Visualization | Learn SAS

Robert AllisonMay 19, 2017 0

Using a peekaboo map to align your solar panels

In recent years, solar panels have become much more economical, and therefore more popular. But because of the curvature of the Earth, the angle at which you need to install the panels varies, depending on where you live. In this example, I demonstrate how to visualize this kind of data

Read More

Energy & Utilities

Analytics | Data Visualization | Learn SAS

Robert AllisonMay 15, 2017 0

What happened to the dinosaurs? (not the coding dinosaurs - the real ones!)

I guess a coding dinosaur is someone who uses an old/legacy computer language, or at least a language that isn't en vogue these days. Coding dinosaurs are still around (and probably will be for a while), whereas the real dinosaurs that lived millions of years ago are extinct. What caused

Read More

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

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

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

Education | Travel

Analytics | Learn SAS

Jeff ZeanahMay 10, 2017 0

Explaining analytics: On craftsmanship

In the Tuscan hilltop village of Montepulciano, a tourist can visit the shop of Coppersmith Cesare Mazzetti. But Mazzetti is not just running his family’s traditional business, he’s demonstrating all the qualities of a historic craftsman. The visitor may see him work and have him show you photographs of some of

Read More

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

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

Data for Good | Data Visualization | Learn SAS

Robert AllisonMay 4, 2017 0

Creating maps with a zoomed inset, in SAS

While attending SAS Global Forum, a user asked me about creating a map with a zoomed inset map. This is a topic many users might be interested in, so I decided to create an example and share it. But first, I had to decide which map to use. I thought

Read More

Government | Travel

Learn SAS

Matt ScicchitanoMay 2, 2017 0

Do SAS Big Data credentials equal big professional value?

When I first wrote this blog post in early May 2017, it was to ask SAS users holding SAS “Big Data” certifications to participate in the CertMag Salary Survey Plus Big Data Edition. The response was overwhelming and thanks to all of you that participated. Now that the results are in, I wanted

Read More

Learn SAS

Dr. Sunil BhardwajApril 30, 2017 0

Cracking SAS Data Scientist Certification Code

The SAS Data Scientist Credential SAS Data Science Academy brings in a complete set of certifications which enables somebody to be qualified as “Data Scientist”. There is full training support , blended mode of learning , case studies, projects and practice exams by the academy. By successfully passing certification exams,

Read More

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

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

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

Analytics | Data Visualization | Learn SAS

SAS KoreaApril 20, 2017 0

‘SAS Visual Analytics’로 화산 활동 현황 인포그래픽 디자인하기

지구는 여전히 많은 화산이 활동중인 ‘폭발적인 행성’입니다. 미국 워싱턴 D.C. 기반의 학술 협회 ‘스미소니언 인스티튜션(Smithsonian Institution)’은 전 세계의 화산 활동을 추적하고 데이터화하고 있는데요. 글로벌 화산 활동 프로그램(GVP; Global Volcanism Program) 데이터는 지난 10,000년 동안의 화산 및 분화 역사를 보관하고 있으며, GVP 데이터베이스는 1,500개가 넘는 화산의 명칭, 위치, 유형, 특징을 상세하게 기록하고 있습니다. 오늘은

Read More

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

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

Learn SAS | SAS Events

Larry LaRussoApril 18, 2017 0

Nurturing the #lifelearner in all of us

In addition to his day job as Chief Technology Officer at SAS, Oliver Schabenberger is a committed lifelong learner. During his opening remarks for the SAS Technology Connection at SAS Global Forum 2017, Schabenberger confessed to having a persistent nervous curiosity, and insisted that he’s “learning every day.” And, he

Read More

Data Visualization | Learn SAS | Programming Tips

SAS KoreaApril 18, 2017 0

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

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

Read More

Learn SAS

Dr. Jürgen KaselowskyApril 18, 2017 0

Wegweiser Data Science Studium, 1. Ausfahrt: Albstadt-Sigmaringen

Wie versprochen beginnt heute eine kleine Blog-Reihe, in der ich ganz konkret Studiengänge zum Thema Data Science vorstellen möchte. Meine Quellen sind dabei nicht nur die reine Web-Recherche, sondern auch persönliche Gespräche mit Dozenten oder Studenten der jeweiligen Hochschulen. Ich erhebe keinerlei Anspruch auf Vollständigkeit, im Gegenteil, jeder Hinweis, Kommentar

Read More

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

Previous 1 … 25 26 27 28 29 … 40 Next