Learn SAS | Programming Tips

Ron CodyJune 26, 2017 0

Keeping your data set clean: Integrity constraints

When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints.  I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs).  I decided a short discussion on this topic would

Read More

English

Learn SAS

SAS JediJune 23, 2017 0

Jedi SAS Tricks - FedSQL Dictionary Tables

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

Read More

English

Advanced Analytics | Learn SAS | Programming Tips

Rick WicklinJune 21, 2017 0

Jackknife estimates in SAS

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

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonJune 9, 2017 0

Star Trek (the original series) - the infographic!

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

Read More

English

Sports & Entertainment

Learn SAS | Programming Tips

Leonid BatkhanJune 6, 2017 0

Combine and conquer with SAS

The ancient political maxim “divide and conquer” (Lat. “dīvide et īmpera”) has been used for millennia in politics, sociology, and psychology, mainly to manipulate people. In the last two centuries, however, this principle has also been adopted by computer science. It is widely used in computer programming, primarily in computer

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonJune 6, 2017 0

Graphing Ironman race data

This past weekend, I was a volunteer helping with an Ironman 70.3 race. I was really impressed & inspired by the athletes ... I was also excited about the quantity and variety of data generated by this type of race (compared to a regular marathon). And as a 'graph guy' I

Read More

English

Sports & Entertainment

Advanced Analytics | Data Management | Data Visualization | Learn SAS

Michela GuerraJune 6, 2017 0

Digital Learning per una nuova esperienza di apprendimento digitale

La digital transformation spazza come un vento tutti i settori industriali e promette di essere un motore per la competitività, la produttività e l’occupazione. Investire sul miglioramento delle competenze e il rafforzamento dei profili professionali è il punto di partenza per attuare la trasformazione di cui tanto si parla. Partendo

Read More

Italian

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

English

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

English

Health Care | Life Sciences

Learn SAS | Programming Tips

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

English

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

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

English

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

English

Analytics | Learn SAS

Jeanne (Hyunjin) ByunMay 25, 2017 0

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

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

Read More

Korean

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

English

Government | Travel

Analytics | Learn 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

English

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

English

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

English

Life Sciences

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

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

English

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

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

English

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

English

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

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

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