Programming Tips

Chris HemedingerMarch 12, 2015 0

Project Reviewer task and Copy Files task: refreshed for v7.1

Two popular SAS custom tasks have recently been updated for SAS Enterprise Guide 7.1. Most custom tasks that I've shared will work without modification across releases, but these two required a special rebuild due to some internal product API changes. The Project Reviewer task allows you to see a detail

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonMarch 5, 2015 0

Making a 'fun' zip code map more useful

When I saw Robert Kosoro's cool ZIPScribble map, I knew I had to create a SAS version - and of course I had to add a few enhancements along the way.... I was perusing some of the examples on dadaviz.com, and Kosoro's ZIPScribble map caught my attention. It wasn't a particularly useful

Read More

English

Programming Tips

Gerry NelsonMarch 4, 2015 0

Relationships are easy – for SAS objects!

Somebody once said that relationships are not easy. Well now they are—in SAS 9.4, at least! SAS objects have inherent relationships and dependencies, and a change to one element can often have an impact on one or many related objects. For example, for SAS Visual Analytics reports to work as

Read More

English

Programming Tips

Teri PatsilarasFebruary 27, 2015 0

SAS Visual Analytics: creating a custom sort order

Does your week start on Sunday or Monday? Do you have a promotional product you would like to see at the top of your list? Do you have a particular order in which you like to view your regions? Custom sorting is now possible with SAS Visual Analytics 7.1. The

Read More

English

Programming Tips

Russ TyndallFebruary 13, 2015 0

SAS macro variables: how to determine scope

Have you ever created a SAS macro variable and at resolution time received a warning that it did not exist? Many times this warning is because your program referenced the macro variable outside the scope it was created in. Every macro variable created is stored in one of two symbol

Read More

English

Programming Tips

Teri PatsilarasJanuary 29, 2015 0

Using parameters in SAS Visual Analytics

In the latest release of SAS Visual Analytics Designer, a parameter is a variable whose value can be changed and that can be referenced by other report objects. Why is this an important introduction? This addition means that, not only can you design interactive reports via prompt controls, those controls

Read More

English

Learn SAS | Programming Tips

Chris HemedingerJanuary 26, 2015 0

How to split one data set into many

Back in the day when the prison system forced inmates to perform "hard labor", folks would say (of someone in prison): "He's busy making little ones out of big ones." This evokes the cliché image of inmates who are chained together, forced to swing a chisel to break large rocks

Read More

English

Programming Tips

Stephen FoersterJanuary 23, 2015 0

Need test data? Use SAS to extract it from these surprising sources

Everyone is always looking for test data. Business analysts want it for demos and prototypes. Software developers want it for development and unit testing. Testers want it for system and integration testing. I’ve written many programs to generate test data over the years, as have many other SAS users. Generated

Read More

English

Learn SAS | Programming Tips

Leonid BatkhanJanuary 21, 2015 0

SAS timer - the key to writing efficient SAS code

New Year to me is always a stark reminder of the inexorability of Time. In a day-to-day life, time is measured in small denominations - minutes, hours, days… But come New Year, and this inescapable creature – Time – makes its decisive leap – and in a single instant, we

Read More

English

Programming Tips

Erwan GrangerJanuary 16, 2015 0

Cloud: 4 deployment models

This is the last of my series of posts on the NIST definition of cloud computing. As you can see from this Wikipedia definition, calling anything a “cloud” is likely to be the fuzziest way of describing it. In meteorology, a cloud is a visible mass of liquid droplets or frozen

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonJanuary 15, 2015 0

Using SAS analytics to monitor blog posts

As a blogger, I often wonder whether my blog posts are 'successful' - and being a graph guy, I like to visually analyze the data, to try to answer that question. The most common measure of a blog post is probably the number of times it was viewed, so I guess

Read More

English

Analytics | Data Visualization | Programming Tips

Robert AllisonJanuary 14, 2015 0

Don't let difficult graph legends get your goat

Is this blog post about techniques to use on difficult graph legends, or is it about goats? The answer is both! But first, to get you into the proper mood, here is a picture my friend, Mark, took of some cute goats. And some links to YouTube videos about goats

Read More

English

Programming Tips

Erwan GrangerDecember 5, 2014 0

Goldilocks and the three cloud service models

In a recent post, I talked about the 5 essential characteristics of cloud computing. In today’s post, I will cover the three service models available in the cloud as they are defined by the National Institute of Standards and Technology, or NIST. Like the story of Goldilocks, when it comes

Read More

English

Learn SAS | Programming Tips

Jim SimonDecember 4, 2014 0

How to eliminate data error notes from the SAS log

A student in a SAS class recently asked if there were a way to eliminate data error notes from the SAS log and, instead, write them to a separate file.  Of course there's a way! Here's a simple datastep.  Notice the missing dollar sign to indicate the variable GENDER (M,

Read More

English

Programming Tips

Chris HemedingerDecember 4, 2014 0

Using SAS Enterprise Guide with your local SAS installation

If you have SAS Enterprise Guide and SAS for Windows installed on a machine together, they should Just Work. There is no special setup required. But...what if they don't? I've posted an article in the SAS Enterprise Guide community about this topic. Read the article to learn: How to select

Read More

English

Advanced Analytics | Learn SAS | Programming Tips

Rick WicklinDecember 1, 2014 0

Compute maximum and minimum values for rows and columns in SAS

A common question on SAS discussion forums is how to compute the minimum and maximum values across several variables. It is easy to compute statistics across rows by using the DATA step. This article shows how to compute the minimum and maximum values for each observation (across variables) and, for

Read More

English

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanNovember 28, 2014 0

Drill, baby, drill—using SAS to drill down through Google maps

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

English

Programming Tips

Grace WhiteisNovember 21, 2014 0

SAS arrays—be not afraid!

Arrays are a powerful SAS programming tool. They can be used to simplify coding for repetitive calculations, to transpose data and to evaluate variables in a non-sequential manner. Sometimes users are intimidated by the term array, but in SAS, an array is simply a grouping of variables that lasts for

Read More

English

Programming Tips

Russ TyndallNovember 14, 2014 0

SAS macro errors: the answers you’re looking for

Have you ever received an error or warning in SAS macro and did not know what to do next or even where to look?  Now there is an answer! And debugging your SAS macros just got easier. All macro errors and warnings are now documented in the SAS 9.4 Macro

Read More

English

Programming Tips | SAS Administrators

Erwan GrangerNovember 7, 2014 0

5 characteristics you meet in the cloud

If someone asks you whether SAS runs in the cloud, there are exactly two wrong answers: "yes" and "no". Instead, this question should spark a discussion. It should be a discussion about which of the five characteristics of cloud computing they are interested in. The answers will point you in

Read More

English

Learn SAS | Programming Tips

Rick WicklinNovember 3, 2014 0

Recent additions to the SAS/IML file-sharing community

It has been three months since the introduction of the SAS/IML File Exchange, so I thought I'd give a short update on recent submissions and activity. (Note: The File Exchange was merged into the SAS Community Library in 2022.) Users have submitted eight new articles. The application areas include experimental

Read More

English

Programming Tips

Lelia McConnellOctober 17, 2014 0

Symbols in SAS 9.4 graphs: unlimited possibilities

Beginning with the first maintenance of SAS 9.4, you have the ability to define your own symbol markers using the SYMBOLCHAR and SYMBOLIMAGE statements. With these statements you can select a Unicode value or you can select an image file that exists on the local file system—making the possibilities for

Read More

English

Programming Tips

Chris HemedingerOctober 14, 2014 0

Why your DDE programs don't work anymore

Hello, 1992 called. They want their DDE Excel automation back. Perhaps the title of this article is too pessimistic. Of course your SAS programs that use DDE (dynamic data exchange) can still work perfectly, as long as you situate your SAS software and its DDE "partner" (usually Microsoft Excel) to

Read More

English

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanOctober 13, 2014 0

Circling Google maps with SAS

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

English

Programming Tips

Chris HemedingerOctober 12, 2014 0

New SAS programming features in SAS Enterprise Guide 7.1

SAS Enterprise Guide 7.1 began shipping last week. Of the many new features, some are "biggies" while others are more subtle. My favorite new features are those for SAS programmers, including several items that I've heard customers ask for specifically. I'll describe them briefly here; the SAS Enterprise Guide online

Read More

English

Programming Tips

Teri PatsilarasOctober 3, 2014 0

Use layering to design reports in SAS® Visual Analytics

Report design includes several phases. Granted, these phases aren’t official:  they’re more a reflection of my own thought processes and how my report designs typically unfold: the initial “get the data on the screen to see what we have” phase the addition of filters and prompts to assist with guided

Read More

English

Programming Tips

Bari LawhornSeptember 26, 2014 0

Encoding: helping SAS speak your language

If you live in an English speaking country you are used to a relatively unadorned alphabet. Take a look at the French and Spanish languages, where vowels are decorated with accents like “acción” in Spanish, and the circumflex, or the hat used in “pâte” in French. Look at the gorgeous

Read More

English

Learn SAS | Programming Tips

Charu ShankarSeptember 26, 2014 0

Help! Why does the WHERE clause choke on the INPUT function?

A student brought in this coding problem after her manager was struggling with this issue for a while. They played guessing games, but to no avail. Here’s what happened when they submitted data step and proc sql code using a WHERE clause with an INPUT function? data aileen; length hcn

Read More

English

Programming Tips

Chris HemedingerSeptember 24, 2014 0

Don't panic: maybe your XLSX file is already opened

As you can tell from my recent posts (see here and here), I've been working with SAS and Microsoft Excel files quite a bit. I'm really enjoying the ability to import an XLSX file in my 64-bit SAS for Windows without any additional setup. After one long afternoon of back-and-forth

Read More

English

Learn SAS | Programming Tips

Chris HemedingerSeptember 21, 2014 0

Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports

I recently wrote about my foray into the experimental world of ODS EXCEL. Using this new destination in SAS 9.4, I was able to create multisheet workbooks -- containing reports and graphs -- in the XLSX format. I outlined some of the benefits -- such as being part of Base

Read More

English