Data Management | Learn SAS | Programming Tips

Leonid BatkhanNovember 25, 2016 0

Modifying variable attributes in all datasets of a SAS library

Using the DATASETS procedure, we can easily modify SAS variable attributes such as name, format, informat and label: proc datasets library=libref; modify table_name; format var_name date9.; informat var_name mmddyy10.; label var_name = 'New label'; rename var_name = var_new_name; quit; We cannot, however, modify fixed variable attributes such as variable type

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldNovember 23, 2016 0

Advanced ODS Graphics: Remove ODS Subtitles

In my previous post, I showed you how to change the titles in graphs produced by analytical procedures; today I will show you how to remove subtitles that procedures display on some output pages. The following step creates output that contains a SAS title ('Illustrate the CIF Plot'), a PROCTITLE

Read More

English

Programming Tips

Ron CodyNovember 23, 2016 0

Editing the SAS Code Generated by the One-Way Frequencies Statistics Task

Suppose you are using SAS Studio and the statistical task you need to perform is not a supported option or feature in SAS.  I know that sounds almost impossible because the statistical tasks in SAS Studio are so awesome.  But, just in case you need to tweak a program or

Read More

English

Programming Tips

BrennaNovember 21, 2016 0

SAS Jedi and DS2 Guru: Mark Jordan

Maybe programming isn’t quite as dangerous as a lightsaber battle, but if you think using SAS to turn data into action feels a little bit like magic, you should know that nobody is better at harnessing “the Force” of DS2 than SAS Jedi Mark Jordan. Mark has a resume that

Read More

English

Data Visualization | Programming Tips

Teri PatsilarasNovember 15, 2016 0

Use images in SAS Visual Analytics to enhance your report link

If your SAS Visual Analytics report requirements include linking out to separate reports without the need to pass values, you may want to consider using images to enhance the appearance of your base report. Here are three style examples using images that you can use depending on your report design

Read More

English

Programming Tips

Chris HemedingerNovember 14, 2016 0

The Copy Files task is going legit (and moving)

I've supplied dozens of custom tasks for SAS Enterprise Guide, but the Copy Files task is easily the most popular. The Copy Files task allows you to capture "file transfer" steps inside your process flow, so that you can automate any file upload and download operations between your PC and

Read More

English

Learn SAS | Programming Tips

Charu ShankarNovember 3, 2016 0

The difference between the Subsetting IF and the IF—THEN—ELSE—IF statement

My river walk last week turned into a spectacular fall show. But if it rains this week in San Antonio, like the weatherman predicts, what will I do? In the coming days, I’ll be presenting at two user groups,  one in eastern Canada in Halifax, and the other all the

Read More

English

Learn SAS | Programming Tips | Students & Educators

Charu ShankarOctober 26, 2016 0

What comes shipped free with Base SAS 9.4?

Like unexpectedly seeing this beautiful bird in nature, SAS has tons of free goodies you might be surprised to encounter as you explore your software. A user asked me how to find products licensed at their workplace and that's how this informative blog got started. While individual organizations may have

Read More

English

Learn SAS | Programming Tips

Stacey SyphusOctober 25, 2016 0

New features in SAS Enterprise Guide 7.1

SAS Enterprise Guide has come a long way since version 1.0 was released in 1999! Are any of you original users that remember the Help characters, Clippy, Peedy or Merlin?  I was working as a statistician for another company that year, and I attended a SAS user group meeting where

Read More

English

Programming Tips

Teri PatsilarasOctober 24, 2016 0

Use Rank in SAS Visual Analytics to display the last date, month or rolling window

Requirements that are the most easily described can often be the most difficult to implement. I’m referring to requests like: Display a gauge with the most recently collected metric. Plot a 18 month rolling window of profit. Display last month’s products percent of total metrics for visual comparison. Okay, so

Read More

English

Programming Tips

Russ TyndallOctober 21, 2016 0

Macro variables that provide information about your SAS® environment

Have you ever needed to run code based on the client application that you are using? Or have you needed to know the version of SAS® software that you are running and the operating system that you are running it on? This blog post describes a few automatic macro variables

Read More

English

Data Management | Programming Tips

Mary Kathryn QueenOctober 19, 2016 0

Using multiple SAS Quality Knowledge Base locales in a SAS Event Stream Processing compute window

In a previous blog post, I demonstrated combining the power of SAS Event Stream Processing (ESP) and the SAS Quality Knowledge Base (QKB), a key component of our SAS Data Quality offerings. In this post, I will expand on the topic and show how you can work with data from

Read More

English

Programming Tips

Chris HemedingerOctober 18, 2016 0

Tip: How to close all data sets in SAS Enterprise Guide

Have you seen this error when running a program in SAS Enterprise Guide? ERROR: You cannot open WORK.YOURDATA.DATA for output access with member-level control because WORK.YOURDATA.DATA is in use by you in resource environment IOM ROOT COMP ENV. Or maybe: ERROR: A lock is not available for LIB.YOURDATA.DATA. NOTE: The

Read More

English

Programming Tips

Chris HemedingerOctober 16, 2016 0

List the contents of your ZIP files using SAS

SAS programmers often resort to using the X command to list the contents of file directories and to process the contents of ZIP files. In centralized SAS environments, the X command is unavailable to most programmers. NOXCMD is the default setting for these environments (disallowing shell commands), and SAS admins

Read More

English

Programming Tips

Andrew ChristianOctober 12, 2016 0

The Monty Hall Paradox - SAS vs. Python

Recently, one of sons came to me and asked about something called “The Monty Hall Paradox.” They had discussed it in school and he was having a hard time understanding it (as you often do with paradoxes). For those of you who may not be familiar with the Monty Hall

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldOctober 11, 2016 0

Advanced ODS Graphics: Title change macro

Have you ever wanted to modify a graph title that is produced by an analytical procedure? You can make a wide variety of changes by modifying the graph template. Modifying the graph template is straight forward. You specify ODS TRACE ON, run the procedure, find the template name, display the

Read More

English

Programming Tips | SAS Administrators

Dave NadenOctober 6, 2016 0

Auditing SAS server availability from 30,000 feet

One very useful type of auditing for a SAS administrator is to have summary data about the availability and performance of various resources (platforms, servers, services) from the 30,000-foot view. $1000 loan guaranteed.  Using SAS Environment Manager, it's easy to go in and look at the availability of any one resource over

Read More

English

Programming Tips | SAS Administrators

Gerry NelsonSeptember 29, 2016 0

How to protect your audit trail in a SAS environment

In a number of my previous blogs I have discussed auditing within a SAS environment and how to identity who has accessed data or changed reports. For many companies keeping an audit trail is very important. If you’re an administrator in your environment and auditing is important at your organization,

Read More

English

Learn SAS | Programming Tips

Michael A. RaithelSeptember 28, 2016 0

SAS & bugs & rock & roll

SAS Programming Professionals, SAS & bugs & rock & roll? But, of course! SAS Because of its amazing versatility, SAS is indisputably the greatest software package currently in use anywhere within the Milky Way Galaxy.  Can SAS input every type of flat file imaginable?  Yes!  Can SAS read and write

Read More

English

Programming Tips

Larry OrimoloyeSeptember 27, 2016 0

Operationalising Open Source Models Using SAS

With my first open source software (OSS) experience over a decade ago, I was ecstatic. It was amazing to learn how easy it was to download the latest version on my personal computer, with no initial license fee. I was quickly able to analyse datasets using various statistical methods. Organisations

Read More

English

Learn SAS | Programming Tips

Aubrey BarfieldSeptember 26, 2016 0

Free training course: SAS Programming for R Users

Are you ready to expand your programming skills and become a more versatile programmer? Then this new (and free!) course might be for you. SAS Programming for R Users is a free course aimed at helping R programmers who want to learn SAS. The goal is for you to be comfortable accomplishing

Read More

English

Programming Tips | SAS Events

Kirk Paul LaflerSeptember 26, 2016 0

SAS performance tuning - A little bit goes a long way

Over the past 37 years I've had the good fortune to be able to attend and present at hundreds of in-house, local, regional, special-interest and international SAS events. I am a conference junkie. I've not only attended thousands of presentations, Hands-On Workshops, tutorials, breakout sessions, quick tips, posters, breakfasts, luncheons,

Read More

English

Learn SAS | Programming Tips

Aaron HillSeptember 23, 2016 0

The evolution of support.sas.com

Every day, more than one hundred thousand SAS users visit our website looking for SAS information and resources. Given its importance to our user base, we’re constantly looking for ways to evolve the site.  Over the next few months, you’ll notice changes to the support website, changes we believe will

Read More

English

Learn SAS | Programming Tips

Charu ShankarSeptember 21, 2016 0

Learn not one, not two, but four languages in SAS

I started young. Since I was 9 years old, I’ve always loved cooking delicious, tasty and healthy food, and feeding friends and family. My aunt still remembers the delicious chocolate soufflé that trembled and shook but would never collapse that I made for them when I was 18! Word spread.

Read More

English

Programming Tips | SAS Administrators

Edoardo RivaSeptember 21, 2016 0

SAS Studio tips for SAS Grid Manager Administrators: Where are my preferences?

In a previous blog post I explained how end users should code and use shared locations for SAS artifacts, to avoid issues in a SAS Grid Manager environment. Still, they could still fall in some sharing issues, which could have very obscure manifestations. For example, users opening SAS studio might notice

Read More

English

Programming Tips

Martin MinceySeptember 16, 2016 0

Do you need multiple graphs on a page? We have got you covered!

If you use SAS® software to create a report that contains multiple graphs, you know that each graph appears on a separate page by default. But now you want to really impress your audience by putting multiple graphs on a page. Keep reading because this blog post describes how to

Read More

English

Programming Tips

Mary Kathryn QueenSeptember 15, 2016 0

Using SAS Quality Knowledge Base Definitions in a SAS Event Stream Processing Compute Window

The SAS Quality Knowledge Base (QKB) is a collection of files which store data and logic that define data cleansing operations such as parsing, standardization, and generating match codes to facilitate fuzzy matching. Various SAS software products reference the QKB when performing data quality operations on your data. One of

Read More

English

Data Visualization | Programming Tips

Warren F. KuhfeldSeptember 13, 2016 0

Legend order and group attributes

In this post, I will show you how to control the order of the entries in a legend and explicitly control the correspondence between groups and style elements in PROC SGPLOT. In many cases, the colors that are used to differentiate groups do not matter--the graph simply needs to display

Read More

English

Programming Tips | SAS Events

Larry LaRussoSeptember 9, 2016 0

Analytics in the Cloud gets a whole lot easier with SAS Analytics for Containers

If you’re doing data processing in the cloud or using container-enabled infrastructures to deploy your software, you’ll want to learn more about SAS Analytics for Containers. This new solution puts SAS into your existing container-enabled environment – think Docker or Kubernetes – giving data scientists and analysts the ability to

Read More

English

Programming Tips

Bobbie WagonerSeptember 7, 2016 0

Calculate a moving average using periodic operators in SAS Visual Analytics Designer

Analysts often use a simple moving average to get an idea of the trends in data. This is simply an average of a subset of time periods, and the size of the subset can differ depending on the application. The technique can be used with data based on time periods,

Read More

English