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

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

Korean

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

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

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

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

German

Education

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

Analytics | Learn SAS | SAS Events

Sandra HernandezApril 17, 2017 0

SAS Global Forum 2017, los datos no conocen fronteras

Los datos no conocen fronteras. Este concepto enmarcó la edición número 42 del SAS Global Forum, el evento de analítica más grande del mundo que atrajo a más de 30.000 asistentes presenciales y virtuales. Durante cuatro días, profesionales de negocio y amantes de la tecnología, tuvimos la oportunidad de intercambiar

Read More

Spanish

Data Visualization | Learn SAS

Rick WicklinApril 17, 2017 0

Visualize the 68-95-99.7 rule in SAS

A reader commented on last week's article about constructing symmetric intervals. He wanted to know if I created it in SAS. Yes, the graph, which illustrates the so-called 68-95-99.7 rule for the normal distribution, was created by using several statements in the SGPLOT procedure in Base SAS The SERIES statement

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

Advanced Analytics | Learn SAS | Machine Learning | Programming Tips

Chris HemedingerApril 8, 2017 0

Introducing SASPy: Use Python code to access SAS

Thanks to a new open source project from SAS, Python coders can now bring the power of SAS into their Python scripts. The project is SASPy, and it's available on the SAS Software GitHub. It works with SAS 9.4 and higher, and requires Python 3.x. I spoke with Jared Dean

Read More

English

Data Visualization | Learn SAS | Programming Tips

Robert AllisonApril 6, 2017 0

Drawing paths on a map using SGplot

For those of you who don't have SAS/Graph's Proc GMap, I recently showed how to 'fake' a variety of maps using Proc SGplot polygons. So far I've written blogs on creating: pretty maps, gradient shaded choropleth maps, and maps with markers at zip codes. And now (by special request from

Read More

English

Travel

Learn SAS | Students & Educators

Jeanne (Hyunjin) ByunApril 3, 2017 0

SAS 무료 e러닝 사이트를 소개합니다!

여러분, SAS 무료 이러닝 사이트를 알고 계시나요? SAS 소프트웨어를 사용하는 고객들께서는 본사의 영문 e러닝을 무료로 활용할 수 있습니다. 먼저 SAS 홈페이지에서 ID와 PW를 만든 후 https://support.sas.com/edu/viewmyelearn.html 로 접속하여 로그인 해주세요. 그럼  아래와 같은 Product 코드 입력창이 나타나게 됩니다.  2. 가지고 계시는 SAS 라이센스를 클릭 하시면 아래와 같이 setnumid라는 숫자가 있습니다. 3. 위 코드 입력 창에 대문자 G와 setnumid를

Read More

Korean

Learn SAS | Programming Tips

Leonid BatkhanApril 1, 2017 0

SAS code to prove Fermat's Last Theorem

The full text of Fermat's statement, written in Latin, reads "Cubum autem in duos cubos, aut quadrato-quadratum in duos quadrato-quadratos, et generaliter nullam in infinitum ultra quadratum potestatem in duos eiusdem nominis fas est dividere cuius rei demonstrationem mirabilem sane detexi. Hanc marginis exiguitas non caperet." The English translation is:

Read More

English

Learn SAS | Programming Tips

Ron CodyMarch 31, 2017 0

Capturing output from any procedure with an ODS OUTPUT statement

There's an old song that starts out, "You Can Get Anything You Want at Alice's Restaurant."  Well, maybe you are too young to know that song, but if you’re a SAS users, you’ll be glad to know that you can capture anything produced by any SAS procedure (even if the

Read More

English

Analytics | Data Visualization | Learn SAS

Robert AllisonMarch 31, 2017 0

How about a free eBook on data visualization using SAS!

If you're into data visualization, here's something that might interest you - a free eBook showing several ways to use SAS to visually analyze your data. (Did I mention it's FREE?!?!) We've picked juicy chapters from several books and upcoming books (and a few other sources), to show you what

Read More

English

Learn SAS | Programming Tips

Jeanne (Hyunjin) ByunMarch 31, 2017 0

비즈니스를 위한 오픈소스

데이터 사이언스와 데이터 사이언티스트에 대한 설전과 토론이 맹렬한 가운데 여러 기업들이 다수의 데이터 사이언티스트 채용 및 고용에 적극적으로 나서면서 데이터 사이언티스트에 대한 수요가 실제 취업 예정자 공급을 추월하기 시작했습니다. 이로 인해 데이터 사이언티스트의 효과적인 유치 및 유지라는 화두 역시 IT 및 비즈니스 커뮤니티에서 뜨거운 감자로 떠올랐습니다. 이러한 상승세에서 기업은 모두가 탐내는

Read More

Korean

Data Visualization | Learn SAS

Robert AllisonMarch 29, 2017 0

Plotting markers on a map at zip code locations, using GMap or SGplot

Users frequently ask how to plot their data as markers on a map. There are several ways to do this using SAS software. If you're a Visual Analytics user, you can do it using a point-and-click interface. But if you're a coder, you might need a little help... In this

Read More

English

Retail

Data Management | Learn SAS | Programming Tips

Leonid BatkhanMarch 28, 2017 0

Changing variable type and variable length in SAS datasets

There is a well-known Russian saying that goes “Если нельзя, но очень хочется, то можно.” The English translation of it can span anywhere from “If you can’t, but want it badly, then you can” to “If you shouldn’t, but want it badly, then you should” to “If you may not,

Read More

English

Learn SAS | Programming Tips | SAS Events

Kirk Paul LaflerMarch 23, 2017 0

Exploring the content of the DICTIONARIES table and VSVIEW SASHELP view

SAS® users have an easy and convenient way to quickly obtain useful information (referred to as metadata) about their SAS session with a number of read-only SAS DICTIONARY tables or SASHELP views. At any time during a SAS session, information about currently defined system options, libnames, tables, columns and their

Read More

English