SAS Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Data Visualization | Learn SAS | Programming Tips

Kelly MillsNovember 29, 2018 0

PROC SGMAP Series Plot – Importing Shapefiles and using PROC GPROJECT

In August 2018, Hurricane Florence came on shore in North Carolina. Much of the damage was from flooding because the storm moved slowly over North and South Carolina. Parts of North Carolina had over 30 inches of rain from the storm, and this caused many of North Carolina’s rivers to

English

Learn SAS | Programming Tips | Students & Educators

Marcia SurrattNovember 28, 2018 0

Making great graphs even better with ODS Graphics

This blog post shows a few samples of graphs and explains how you can use new functionality in ODS Graphics to make your old graphs look new again. ODS Graphics is part of Base SAS.

English

Programming Tips

Rick WicklinNovember 28, 2018 0

Singular parameterizations, generalized inverses, and regression estimates

I remember the first time I used PROC GLM in SAS to include a classification effect in a regression model. I thought I had done something wrong because the parameter estimates table was followed by a scary-looking note: Note: The X'X matrix has been found to be singular, and a

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 26, 2018 0

The SGPIE Procedure

The 6th maintenance release of SAS 9.4 is now available for users. Along with it comes a new SG procedure - the SGPIE procedure (pre-production). The primary audience for the SG procedures has been the analytical user, for creating effective displays of analytical data. However, the rich feature set of these

English

Data Visualization | Programming Tips

Robert AllisonNovember 26, 2018 0

Creating a 'Matrix-like' movie scroll animation, from a text file

Do you remember The Matrix movies, that started coming out in 1999? Hopefully this movie franchise didn't give you a fear of virtual reality and AI. The thing I remember most from the movie was the really cool slow-motion video effects (from multiple angles) in the fight scenes. And the

English

Sports & Entertainment

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 21, 2018 0

Finding a cut-your-own Christmas tree in North Carolina

This week I noticed that they've started building the lot where they sell Christmas trees near SAS (at the intersection of Maynard & Reedy Creek Rd). They put up a nice rustic wooden fence, and lights, and maybe even a fire pit to keep their workers warm. They sell some

English

Sports & Entertainment | Travel

Data Visualization | Learn SAS | Programming Tips

Kelly MillsNovember 20, 2018 0

PROC SGMAP, Base SAS Procedures and MAPSSAS Data Sets

Starting with SAS 9.4M6, procedures that used to be provided with a SAS/GRAPH installation are now available with Base SAS. Using these procedures along with PROC SGMAP can help you create some very nice maps. This blog builds on previous posts and highlights the: MAPSSAS Data Sets GREMOVE procedure %CENTROID

English

Learn SAS | Programming Tips

Rick WicklinNovember 19, 2018 0

Select ODS tables by using wildcards and regular expressions in SAS

You might know that you can use the ODS SELECT statement to display only some of the tables and graphs that are created by a SAS procedure. But did you know that you can use a WHERE clause on the ODS SELECT statement to display tables that match a pattern?

English

Programming Tips

Joe FurbeeNovember 16, 2018 0

Using SAS Cloud Analytics Service REST APIs to run CAS Actions

Disclaimer: this article does not cover or promote any political views. It’s all about data and REST APIs. I am relieved, thankful, elated, glad, thrilled, joyful (I could go on with more synonyms from my thesaurus.com search for 'happy') November 6, 2018 has come and gone. Election day is over.

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 16, 2018 0

Waterfall Graph with more data for subject - Part 2

A few days back I published an article on including more subject data in a Waterfall graph. This was motivated by the desire from many users to view more data in the same graph, thus avoiding the need to refer to different graphs for the relevant information. In this case,

English

Health Care | Life Sciences

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 15, 2018 0

Where do provisional ballots come from?

There has been a lot of controversy surrounding this year's midterm election, when it comes to counting the ballots ... and I kept hearing the term provisional ballots in the news. But I'm embarrassed to say that I didn't really know much about provisional ballots. I decided to do a

English

Government

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 14, 2018 0

Building a better election map

The US 'midterm' elections have finally started to wind down, and we finally have some (mostly) finalized results to study. But what's the best way to visualize who won the US congressional seats in each of the 435 districts? Let's dive into this topic!... Preparation For starters, I couldn't find

English

Government

Programming Tips

Chris HemedingerNovember 14, 2018 0

Create newline-delimited JSON (or JSONL) with SAS

JSON is a popular format for data exchange between APIs and some modern databases. It's also used as a way to archive audit logs in many systems. Because JSON can represent hierarchical relationships of data fields, many people consider it to be superior to the CSV format -- although it's

English

Programming Tips

Steven SoberNovember 14, 2018 0

How to achieve repeatable results with distributed DATA Step BY Groups

Prior to distributed DATA Step, DATA Step programmers never had to think about achieving repeatable results because DATA Step ran single-threaded and the source SAS7BDAT dataset was stored on disk. But if you need to obtain repeatable results in DATA Step code that runs distributed in CAS, this post provides a workaround that you'll want to keep handy.

English

Analytics | Data Visualization | Programming Tips

Rick WicklinNovember 14, 2018 0

Create and compare ROC curves for any predictive model

An ROC curve graphically summarizes the tradeoff between true positives and true negatives for a rule or model that predicts a binary response variable. An ROC curve is a parametric curve that is constructed by varying the cutpoint value at which estimated probabilities are considered to predict the binary event.

English

Programming Tips

Brian KinnebrewNovember 13, 2018 0

Customize your CASL code with built-in and user-defined functions

This blog post outlines how to create your own CAS functions using the CAS Language. It also includes a partial list of both CASL built-in and common functions for reference.

English

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 12, 2018 0

Waterfall Graph with more data for subject

Previously, I have written articles on how we could display more subject response data along with the traditional WaterFall graph showing the best "Change from Baseline". This is in response to the desire to see data like treatment duration for each subject in the same graph. Otherwise, investigators have to

English

Health Care

Analytics | Data Visualization | Programming Tips

Robert AllisonNovember 8, 2018 0

Enhancing a congressional district map - one layer at a time

With the recent midterm elections here in the US, I frequently saw congressional district maps popping up in the news. And being a GraphGuy, I wanted to fully understand these maps, to see if I might could improve them. If you're interested in congressional district maps, follow along as I

English

Government

Programming Tips

Rick WicklinNovember 7, 2018 0

Visualize the feasible region for a constrained optimization

When solving optimization problems, it is harder to specify a constrained optimization than an unconstrained one. A constrained optimization requires that you specify multiple constraints. One little typo or a missing minus sign can result in an infeasible problem or a solution that is unrelated to the true problem. This

English

Data Visualization | Programming Tips

Robert AllisonNovember 6, 2018 0

Creating a custom 'I Voted' sticker

With today being an election day here in the US, I see a lot of people wearing the 'I Voted' sticker. This got me wondering if I could create my own sticker ... using SAS software and simple graphics primitives. :-) So I started by using Proc Gslide to create

English

Government

Data Visualization | Internet of Things | Programming Tips

Chris HemedingerNovember 6, 2018 0

Reporting on accelerometer data with SAS Visual Analytics

I've collected accelerometer data with a third-party app. I've used some SAS tricks to import all of my data readings in a single step. Now I'm ready to create a report of these data in SAS Visual Analytics.

English

Advanced Analytics | Programming Tips

Kevin D. SmithNovember 6, 2018 0

Great tip for dynamic data selection using SAS Viya and Python

You can communicate with various clients (SAS, Python, Lua, Java, and REST) in the same place using SAS® Cloud Base Analytics Services (CAS) in SAS Viya. But before you can do any analysis in CAS you need some data to work with, and a way to get to it. Check out this dynamic data selection tip using SAS Viya and Python.

English

Programming Tips

Kevin D. SmithNovember 2, 2018 0

How to use SAS® Viya® and R for dynamic data selection

In their new book, SAS Viya: the R Perspective, Kevin Smith and Xiangxiang Meng provide an overview of using R with the SAS Viya platform. Read on to see how R programmers can use CAS.

English

Data Management | Data Visualization | Programming Tips

Robert AllisonNovember 2, 2018 0

Visualizing cities as constellations in the night sky

Who says technical people can't have fun!?! Similar to Throwback Thursday / #TBT (when people post one of their old/nostalgic photos on social media), I like the tradition of Fun Friday when I use a fun data topic to test our software - a test can be just as rigorous using

English

Education | Travel

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeNovember 1, 2018 0

Text plot can do that

The TEXT plot was introduced with SAS 9.4M2 to facilitate placement of text strings in a graph. This replaces the MARKERCHAR feature of the SCATTER plot statement, which is still available, but it is better to use TEXT plot in most cases. The syntax is: text x=column y=column text=column </

English

Learn SAS | Programming Tips

Adam BullockNovember 1, 2018 0

How to automate a data download with PROC HTTP

SAS Technical Support has had several requests from customers who want to use SAS® software to help download their files from a website when there is no application programming interface (API) to do it. This post shows how to automate downloads using PROC HTTP and DATA step, and how to use the HTTP DEBUG statement.

English

Analytics | Data Visualization | Programming Tips

Robert AllisonOctober 31, 2018 0

Tracking Trump's approval rating

President Donald Trump - people seem to either love him or hate him. Which makes for an interesting data-analysis topic ... tracking Trump's approval rating. Follow along as I explore some data! I'll start with what I consider the 'best' approval-rating graph I've found so far. Here's a screen-capture of

English

Government

Data Visualization | Programming Tips

Joe FurbeeOctober 31, 2018 0

Using SAS Viya REST APIs to access images from SAS Visual Analytics

This article is the first in a series of three publications covering REST APIs and their use in, and with SAS. Today, I want to cover a basic example using SAS Viya REST APIs to download an image from a report in SAS Visual Analytics.

English

Data Visualization | Learn SAS | Programming Tips

Rick WicklinOctober 31, 2018 0

A trick to plot groups in PROC SGPLOT

A useful feature in PROC SGPLOT is the ability to easily visualize subgroups of data. Most statements in the SGPLOT procedure support a GROUP= option that enables you to overlay plots of subgroups. When you use the GROUP= option, observations are assigned attributes (colors, line patterns, symbols, ...) that indicate

English

Analytics | Learn SAS | Programming Tips

Steffen StahlOctober 30, 2018 0

Erstes SAS User Group Meetup: „Am besten gehen die User am nächsten Tag zur Arbeit und legen direkt los“

Vor ein paar Wochen hat das erste deutsche SAS User Group Meetup in Berlin stattgefunden. Dort hatte ich die Gelegenheit, mit Igor Khorlo, Senior Statistical Programmer bei Syneos Health Deutschland und Gründer der SAS User Group Germany (SUGG), über seine Motivation zu sprechen, die Gruppe ins Leben zu rufen –

German

Previous 1 … 27 28 29 30 31 … 64 Next