Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Leonid BatkhanDecember 15, 2016 0

Truncating decimal numbers in SAS without rounding

Imagine making $50K a day out of thin air. Did you know that NASDAQ routinely processes around 10,000,000 trades a day? What if instead of rounding cents for each transaction, market makers truncated fractions of cents in the amount they owe you? Under the assumption that each transaction, on average,

Read More

Programming Tips

Edoardo RivaDecember 12, 2016 0

SAS Studio Webwork library demystified

In a previous blog about SAS Studio I’ve briefly introduced the concept of using the Webwork library instead of the default Work. I also suggested, in SAS Global Forum 2016 paper, Deep Dive with SAS Studio into SAS Grid Manager 9.4, to save intermediate results in the Webwork library, because

Read More

Learn SAS | Programming Tips

Art CarpenterDecember 7, 2016 0

Using the SAS Macro Language to Create Portable Programs

As technology expands, we have a similarly increasing need to create programs that can be handed off – to clients, to regulatory agencies, to parent companies, or to other projects – and handed off with little or no modification needed by the recipient. Minimizing modification by the recipient often requires

Read More

Data Management | Programming Tips

Chris Hemedinger

Chris HemedingerDecember 2, 2016 0

Reading data with the SAS JSON libname engine

JSON is the new XML. The number of SAS users who need to access JSON data has skyrocketed, thanks mainly to the proliferation of REST-based APIs and web services. Because JSON is structured data in text format, we've been able to offer simple parsing techniques that use DATA step and

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerNovember 30, 2016 0

Using the DATA step debugger in SAS Enterprise Guide

In my earlier post about WHERE and IF statements, I announced that the DATA step debugger has finally arrived in SAS Enterprise Guide. (I admit that I might have buried the lead in that post.) Let's use this post to talk about the new debugger and how it works. First,

Read More

Data Management | Programming Tips

Mary Kathryn QueenNovember 30, 2016 0

Securing sensitive data using SAS Federation Server at the data source level

Data virtualization is an agile way to provide virtual views of data from multiple sources without moving the data. Think of data virtualization as an another arrow in your quiver in terms of how you approach combining data from different sources to augment your existing Extract, Transform and Load ETL batch

Read More

Learn SAS | Programming Tips

Chris Hemedinger

Chris HemedingerNovember 27, 2016 0

Debugging the difference between WHERE and IF in SAS

In the DATA step, the WHERE statement and the IF statement (a.k.a. the "subsetting IF") have similar functions. In many scenarios, they produce identical results. But new SAS programmers are taught early on that these two statements work very differently, and in important ways. To understand the differences, it helps

Read More

Data Management | Learn SAS | Programming Tips

SAS toolbox: macro functions

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

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

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

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

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

Programming Tips

Chris Hemedinger

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

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

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

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

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

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

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

Programming Tips

Chris Hemedinger

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

Programming Tips

Chris Hemedinger

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

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

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

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

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

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

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

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

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

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

Previous 1 … 46 47 48 49 50 … 65 Next