Analytics | Programming Tips

Rick WicklinMay 11, 2020 0

Cubic spline interpolation in SAS

I recently showed how to use linear interpolation in SAS. Linear interpolation is a common way to interpolate between a set of planar points, but the interpolating function (the interpolant) is not smooth. If you want a smoother interpolant, you can use cubic spline interpolation. This article describes how to

Read More

English

Data Visualization | Programming Tips

Debpriya SarkarMay 8, 2020 0

Visualizing COVID-19 data using SGPLOT and SGPANEL

As we continue to process and understand the ongoing effects of the novel coronavirus, many of us have grown used to viewing COVID-19 dashboards and visualizations, including this popular coronavirus dashboard from SAS. If you are more accustomed to building graphs and visualizations using the SGPLOT and SGPANEL procedures, this

Read More

English

Learn SAS | Programming Tips

Kathryn McLawhornMay 5, 2020 0

Using STYLE/MERGE and STYLE/REPLACE in PROC REPORT

In this edition of Problem Solvers, SAS Technical Support's Kathryn McLawhorn walks you through two PROC REPORT techniques.

Read More

English

Analytics | Programming Tips

Rick WicklinMay 4, 2020 0

Linear interpolation in SAS

SAS programmers sometimes ask about ways to perform one-dimensional linear interpolation in SAS. This article shows three ways to perform linear interpolation in SAS: PROC IML (in SAS/IML software), PROC EXPAND (in SAS/ETS software), and PROC TRANSREG (in SAS/STAT software). Of these, PROC IML Is the simplest to use and

Read More

English

Advanced Analytics | Data Visualization | Programming Tips

Xavier BizouxApril 28, 2020 0

Continuous Integration/Continuous Delivery – Using Python and REST APIs for SAS Visual Analytics reports

With increasing interest in Continuous Integration/Continuous Delivery (CI/CD), many SAS Users want to know what can be done for Visual Analytics reports. In this article, I will explain how to use Python and SAS Viya REST APIs to extract a report from a SAS Viya environment and import it into another environment.

Read More

English

Analytics | Programming Tips

Rick WicklinApril 27, 2020 0

The circular law for eigenvalues

I've previously written about how to generate points that are uniformly distributed in the unit disk. A seemingly unrelated topic is the distribution of eigenvalues (in the complex plane) of various kinds of random matrices. However, I recently learned that these topics are somewhat related! A mathematical result called the

Read More

English

Advanced Analytics | Analytics | Machine Learning | Programming Tips | Students & Educators

Cristiane RodriguesApril 23, 2020 0

9 passos para uma modelagem preditiva eficaz

Modelos de machine learning estão cada dia mais em alta no mercado de trabalho. Mas o que são esses modelos? Por que eles ganharam tanto destaque? Por que todos querem usar? Gosto de dizer que modelos de machine learning são modelos estatísticos acrescidos de poder computacional, e que as empresas

Read More

Brazilian Portuguese

Learn SAS | Programming Tips

Leonid BatkhanApril 22, 2020 0

How to create and use SAS macro functions

SAS' Leonid Batkhan differentiates between SAS macro and programming languages, defines two types of SAS macros and much more.

Read More

English

Programming Tips

Peter StyliadisApril 15, 2020 0

Getting Started with Python Integration to SAS® Viya® - Part 1 - Making a Connection

Welcome to the first post for the Getting Started with Python Integration to SAS Viya series! With the popularity of the Python programming language for data analysis and SAS Viya's ability to integrate with Python, I thought, why not create tutorials for users integrating the two? To begin the series

Read More

English

Programming Tips

Joe FurbeeApril 13, 2020 0

Storage in the Cloud – SAS and Azure

Editor’s note: This is the third article in a series by Conor Hogan, a Solutions Architect at SAS, on SAS and database and storage options on cloud technologies. This article covers the SAS offerings available to connect to and interact with the various storage options available in Microsoft Azure. Access

Read More

English

Analytics | Learn SAS | Programming Tips

Lucas de PaulaApril 2, 2020 0

Extending Excel with Python and SAS

Whether you like it or not, Microsoft Excel is still a big hit in the data analysis world. From small to big customers, we still see fit for daily routines such as filtering, generating plots, calculating items on ad-hoc analysis or even running statistical models. Whenever I talk to customers,

Read More

English

Learn SAS | Programming Tips

Charu ShankarApril 1, 2020 0

How to land a job as a SAS professional

SAS' Charu Shankar shares six tips for landing a job as a SAS user.

Read More

English

Data Visualization | Programming Tips

Robert AllisonMarch 30, 2020 0

Tracking Coronavirus Disease 2019 (COVID-19) in the US at the state/county level

Now that COVID-19 is spreading in the US, I thought it might be helpful to view the data at a more granular level. Follow along as I plot the county data on a map and discuss how the color-binning can influence people's perception of the data. Maps like this can

Read More

English

Health Care

Programming Tips

Chris HemedingerMarch 23, 2020 0

Tricks for importing text files in SAS Enterprise Guide

I'm a big fan of the Import Data task in SAS Enterprise Guide, especially for its support of text-based files (CSV, tab delimited, fixed width, and more). There's no faster method for generating SAS code that reads your data exactly the way you need it. I use the tool so

Read More

English

Programming Tips

Martin MinceyMarch 20, 2020 0

How to debug 5 common SAS® software font issues

Martin Mincey of SAS Technical Support shows you how to debug when listing registered SAS fonts, registering new fonts, getting SAS SG procedures to use a new font and more.

Read More

English

Learn SAS | Programming Tips

Suzanne MorgenMarch 19, 2020 0

Free e-book: SAS Programming for R Users

At SAS Press, we agree with the saying “The best things in life are free.” And one of the best things in life is knowledge. That’s why we offer free e-books to help you learn SAS or improve your skills. In this blog post, we will introduce you to one

Read More

English

Learn SAS | Programming Tips

Rick WicklinMarch 18, 2020 0

Print SAS/IML variables with formats

A SAS/IML programmer asked about the best way to print multiple SAS/IML variables when each variable needs a different format. He wanted the output to resemble the "Parameter Estimates" table that is produced by PROC REG and other SAS/STAT procedures. This article shows four ways to print SAS/IML vectors in

Read More

English

Programming Tips

Daria RostovtsevaMarch 16, 2020 0

Challenge accepted: Learning data prep in CASL

As a long-time SAS 9 programmer, I typically accomplish my data preparation tasks through some combination of the DATA Step, Proc SQL, Proc Transpose and some housekeeping procs like Proc Contents and Proc Datasets. With the introduction of SAS Viya, SAS released a new scripting language called CASL – a

Read More

English

Analytics | Programming Tips

Rick WicklinMarch 16, 2020 0

Predict a random integer: The tradeoff between bias and variance

Books about statistics and machine learning often discuss the tradeoff between bias and variance for an estimator. These discussions are often motivated by a sophisticated predictive model such as a regression or a decision tree. But the basic idea can be seen in much simpler situations. This article presents a

Read More

English

Learn SAS | Programming Tips

Leonid BatkhanMarch 10, 2020 0

Automating SAS variable labels creation

SAS' Leonid Batkhan shows you how to automate creation of SAS variable labels so tables and reports are easier to read.

Read More

English

Programming Tips

Susan SlaughterMarch 10, 2020 0

Accessing Excel files using LIBNAME XLSX

If you have been using SAS for long, you have probably noticed that there is generally more than one way to do anything. (For an example, see my co-author Lora Delwiche’s blog about PROC SQL.) The Little SAS Book has long covered reading and writing Microsoft Excel files with the

Read More

English

Advanced Analytics | Data Visualization | Programming Tips

Rick WicklinMarch 9, 2020 0

ROC curves for a binormal sample

In a previous article, I discussed the binormal model for a binary classification problem. This model assumes a set of scores that are normally distributed for each population, and the mean of the scores for the Negative population is less than the mean of scores for the Positive population. I

Read More

English

Advanced Analytics | Learn SAS | Machine Learning | Programming Tips

Suzanne MorgenMarch 5, 2020 0

Learn about new data mining and machine learning procedures in SAS Viya

Have you heard that SAS offers a collection of new, high-performance CAS procedures that are compatible with a multi-threaded approach? The free e-book Exploring SAS® Viya®: Data Mining and Machine Learning is a great resource to learn more about these procedures and the features of SAS® Visual Data Mining and

Read More

English

Learn SAS | Programming Tips

Rick WicklinMarch 4, 2020 0

Store pre-computed matrices in a list

Suppose that a data set contains a set of parameter values. For each row of parameters, you need to perform some computation. A recent discussion on the SAS Support Communities mentions an important point: if there are duplicate rows in the data, a program might repeat the same computation several

Read More

English

Programming Tips

Chris HemedingerFebruary 27, 2020 0

Viewing SAS macro variables in SAS Enterprise Guide

If you use SAS macro variables in your programs (who doesn't?), then the SAS Macro Variable viewer is immensely useful to see current macro var values.

Read More

English

Data Visualization | Programming Tips

Robert AllisonFebruary 26, 2020 0

How long does it take to paddle a canoe 100 miles?

I'm a bit of a boat paddling enthusiast, as you might have guessed from some of my previous paddling blog posts. The amount of exertion in race-paddling is similar to running - the longest race I've paddled in a race so far was 13 miles (half-marathon distance). But in the

Read More

English

Sports & Entertainment

Analytics | Programming Tips

Suzanne MorgenFebruary 26, 2020 0

Propensity Score Estimation with PROC PSMATCH and PROC LOGISTIC

Do you wish you could predict the likelihood that one of your customers will open your marketing email? Or what if you could tell whether a new medical treatment for a patient will have a better outcome than the standard treatment? If you are familiar with propensity modeling, then you

Read More

English

Communications | Education | Health Care | Life Sciences | Retail

Data Visualization | Programming Tips

Debpriya SarkarFebruary 24, 2020 0

Ridgeline Plots using SGPLOT

Ridgeline plots are useful for visualizing changes in the shapes of distribution over multiple groups or time periods. Let us look at an example of how we can create this plot using the SGPLOT procedure that is part of the ODS Graphics Procedures. For this example, we will plot the

Read More

English

Data Management | Programming Tips

Mary Kathryn QueenFebruary 24, 2020 0

How to use Suggestions in SAS® Data Studio

SAS Technical Training Consultant Mary Kathryn Queen introduces you to SAS Data Studio's Suggestions feature.

Read More

English

Programming Tips

Rick WicklinFebruary 24, 2020 0

Visualization of a binary classification analysis

The purpose of this article is to show how to use SAS to create a graph that illustrates a basic idea in a binary classification analysis, such as discriminant analysis and logistic regression. The graph, shown at right, shows two populations. Subjects in the "negative" population do not have some

Read More

English