SAS Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

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

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

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

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

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

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

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

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).

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

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

English

Data Visualization | Learn SAS | Programming Tips

SAS KoreaApril 18, 2017 0

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

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

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!

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

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,

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

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

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

English

Analytics | Programming Tips

Optimal value of quadratic function of two variables

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

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

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

English

Programming Tips

Rick WicklinApril 10, 2017 0

A simple trick to construct symmetric intervals

Many intervals in statistics have the form p ± δ, where p is a point estimate and δ is the radius (or half-width) of the interval. (For example, many two-sided confidence intervals have this form, where δ is proportional to the standard error.) Many years ago I wrote an article

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

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

English

Travel

Programming Tips

Rick WicklinApril 5, 2017 0

Piecewise regression models and spline effects

Most regression models try to model a response variable by using a smooth function of the explanatory variables. However, if the data are generated from some nonsmooth process, then it makes sense to use a regression function that is not smooth. A simple way to model a discontinuous process in

English

Data Visualization | Programming Tips

Warren F. KuhfeldApril 4, 2017 0

Consistent Ordering of All Graph Components

This post shows you how to make a bar chart and an X-axis table; ensure consistency in the order of the legend, bar subgroups, and axis table rows; coordinate the colors for each of those components; and drive all the color choices from an attribute map.

English

Programming Tips

Rick WicklinApril 3, 2017 0

Print tables in SAS/IML

One of the advantages of the new mixed-type tables in SAS/IML 14.2 (released with SAS 9.4m4) is the greatly enhanced printing functionality. You can control which rows and columns are printed, specify formats for individual columns, and even use templates to completely customize how tables are printed. Printing a table

English

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:

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

English

Learn SAS | Programming Tips

Jeanne (Hyunjin) ByunMarch 31, 2017 0

비즈니스를 위한 오픈소스

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

Korean

Previous 1 … 43 44 45 46 47 … 65 Next