Data Management | Programming Tips

Mary Kathryn QueenJuly 21, 2016 0

Using an alternate Quality Knowledge Base (QKB) in a DataFlux Data Management Studio data job

In DataFlux Data Management Studio, the predominate component of the SAS Data Quality bundle, the data quality nodes in a data job use definitions from something called the SAS Quality Knowledge Base (QKB). The QKB supports over 25 languages and provides a set of pre-built rules, definitions and reference data

Read More

English

Programming Tips

Bari LawhornJuly 15, 2016 0

Build your PROC TEMPLATE muscles: Using the COMPUTE AS and TRANSLATE INTO statements

When you work out, you probably have a routine set of exercises that you do. But if you read health-and-fitness websites or talk to a personal trainer, you know that for optimal fitness, you should vary your workout routine. Not only does adding variety to your fitness regime help you

Read More

English

Programming Tips

Chris HemedingerJuly 12, 2016 0

How to read the contents of a file into a SAS macro variable

I've been working on a SAS program that can add content to the SAS Support Communities (more on that in a future post). Despite my 20+ years of SAS experience, there are a lot of SAS programming tricks that I don't know. Or that I use so infrequently that I

Read More

English

Programming Tips

Rob CollumJuly 7, 2016 0

About LASR Load Balancing

The Distributed SAS 9.4 LASR Analytic Server provides a massively parallel processing solution for working very quickly with huge volumes of data. LASR was built from its earliest invocations to provide for incredible scalability and growth. One of the primary criteria which drives the considerations of scalability is load management.

Read More

English

Programming Tips | SAS Events

Chris HemedingerJune 27, 2016 0

Video: Demonstrating the new features in SAS Enterprise Guide 7.1

Would you like to see the latest features of SAS Enterprise Guide in action? Of course you would! That's why it's well worth the 12 minutes of your time to watch this video from SAS Global Forum 2016. In the video, Casey Smith (SAS' R&D manager of the SAS Enterprise

Read More

English

Programming Tips

Chris HemedingerJune 24, 2016 0

Assign a SAS library to a different path depending on your OS

One thing that we have a lot of at SAS: installations of SAS software that we can run. I have SAS for Windows on my laptop, and I have access to many centralized instances of SAS that run on Linux and Windows servers. (I also have access to mainframe SAS,

Read More

English

Programming Tips

Chevell ParkerJune 24, 2016 0

Tips for reading XML files into SAS® software

XML has become one of the major standards for moving data across the Internet. Some of XML’s strengths are the abilities to better describe data and to be more extensible than any of its predecessors such as CSV. Due to the increased popularity of XML for moving data, I provide

Read More

English

Programming Tips

Bobbie WagonerJune 21, 2016 0

Need an aggregation of an aggregation? Use Visual Data Builder to pre-aggregate your data

Report designers often discover after aggregating data by groups in the Visual Analytics Designer that it would also be nice to see additional aggregations of the data, for example, a maximum or minimum of that sum across groups. This means creating an ‘aggregation of an aggregation.’ If you plan your report objectives in

Read More

English

Programming Tips | SAS Administrators

Dave NadenJune 13, 2016 0

Auditing using the SAS Environment Manager Report Center– tips and tricks

As an addendum to my previous two blogs on using the SAS Environment Manager Report Center, this blog illustrates further tips and tricks you can use to help make the creation of your custom reports easier. The Ad-Hoc Reporting section of the Report Center is specifically designed to provide a

Read More

English

Programming Tips

SAS JediJune 6, 2016 0

Jedi SAS Tricks: Writing to Text Files from DS2

A reader posed a question in the comments to an earlier Jedi SAS Trick, asking how to write the results of a DS2 DATA _NULL_ program to a text file. It's an interesting question, as DS2 currently has no text file handling statements or capabilities. Take, for example, this traditional

Read More

English

Data Management | Programming Tips

Mary Kathryn QueenJune 3, 2016 0

Using Multiple Quality Knowledge Base Locales in a DataFlux Data Management Studio Data Job

In DataFlux Data Management Studio, the data quality nodes (e.g., Parsing, Standardization, and Match Codes) in a data job use definitions from the SAS Quality Knowledge Base (QKB).  These definitions are based on a locale (Language and Country combination).  Sometimes you would like to work with multi-locale data within the

Read More

English

Programming Tips | SAS Events

Edoardo RivaMay 26, 2016 0

Seven of my favorite big data presentations from SAS Global Forum 2016

Nowadays, nearly every organization analyzes data to some degree, and most are working with “Big Data.”  At SAS Global Forum 2016 in Las Vegas, a vast number of papers were presented to share new and interesting ways our customers are using data to IMAGINE. CREATE. INNOVATE., as this year’s conference tagline

Read More

English

Programming Tips

Teri PatsilarasMay 25, 2016 0

Use a stack container to pick your category in SAS Visual Analytics Reports

Pick your category? If this title seems familiar, that’s because in my last blog, Use parameters to pick your metric in VA Reports, I covered how to use parameters to allow your users to pick which metric they want to view in their visualizations. This is a great technique that

Read More

English

Learn SAS | Programming Tips

Leonid BatkhanMay 23, 2016 0

Are you solving the wrong problem?

  Being a SAS consultant is about solving problems. In our day-to-day work we solve myriads of all sorts of problems – technical problems, data problems, programming problems, optimization problems – you name it. And in the grand scheme of things we solve business problems. But without a well-defined business

Read More

English

Programming Tips

Kathryn McLawhornMay 20, 2016 0

Seeing the FREQ procedure's one-way tables in a new light

PROC FREQ is often the first choice when you want to generate basic frequency counts, but it is the last choice when it is compared to other statistical reporting procedures. People sometimes consider PROC FREQ last because they think they have little or no control over the appearance of the

Read More

English

Programming Tips | SAS Administrators

Dave NadenMay 18, 2016 0

Creating custom reports from the Data Mart

My previous blog discussed the SAS Environment Manager Report Center, and talked about its organization, and how to start using some of the prompts to get the reports you want. The next step is to learn to use some of the example reports provided to help you design your own, production-level

Read More

English

Programming Tips

Chris HemedingerMay 15, 2016 0

Ad-hoc reporting with SAS: Tips for the e-mail jockey

What's the most common data reporting mechanism? Is it web-based reporting? PDFs? How about spreadsheets? Maybe, but in my experience many reports are delivered using a less-scalable and transient mechanism: e-mail. I'm a data steward at SAS. Specifically, I look after the operational data around our blogging program and our

Read More

English

Data Management | Programming Tips

Mary Kathryn QueenMay 13, 2016 0

Improving matching results in DataFlux Data Management Studio with cluster comparison

Trusted data is key to driving accurate reporting and analysis, and ultimately, making the right decision. SAS Data Quality and SAS Data Management are two offerings that help create a trusted, blended view of your data. Both contain DataFlux Data Management Studio, a key component in profiling, enriching monitoring, governing

Read More

English

Programming Tips | SAS Administrators

Edoardo RivaMay 4, 2016 0

Is your new grid behaving oddly?

New default parameter values for Platform Suite for SAS Sometimes, when your kids grow older, they change their habits and you don’t recognize their behaviors any more. “We play this game every year at the beach. Don’t you like it anymore?” you ask. “Dad, I’m not seven years old any

Read More

English

Programming Tips

SAS JediMay 1, 2016 0

Jedi SAS Tricks - Make This a Button in Base SAS

A recent post, Jedi SAS Tricks: The DATA to DATA Step Macro, engendered a lot of response on Twitter. One of the re-tweets included a call to action - make this a button in Base SAS!

Read More

English

Programming Tips

Bobbie WagonerApril 29, 2016 0

Dealing with Dates in SAS Visual Analytics Designer

In a previous blog, I discussed SAS date and time values, and how date and time formats can be used to your advantage in SAS Visual Analytics. That blog addressed some of the features provided for handling date information, like date formats, date hierarchies, and calculated data items based on time

Read More

English

Data Visualization | Programming Tips

Teri PatsilarasApril 27, 2016 0

Use parameters to pick your metric in Visual Analytics Reports

Look at the report below. Imagine being asked to allow your users to select which Measure, highlighted in yellow, they are looking at: Income, Expense or Profit. This is a frequent report requirement and I’m going to outline just one of the ways you can design your report to satisfy

Read More

English

Learn SAS | Programming Tips

Charu ShankarApril 22, 2016 0

SAS training leads to certification success

Teaching SAS coding is fun. The best part of teaching is hearing success stories from candidates who earn a SAS certification after taking SAS training. Suiru Jiang is an MBA candidate who successfully passed her SAS certification exam. She took my five-day SAS programming fast track course at Goodman School

Read More

English

Programming Tips

Russ TyndallApril 22, 2016 0

Solutions for missing DATA step features within DS2

The DS2 programming language gives you the following powerful capabilities: The precision that results from using the new supported data types Access to the new expressions, write methods, and packages available in the DS2 syntax Ability to execute SAS Federated Query Language (FedSQL) from within the DS2 program Ability to

Read More

English

Programming Tips | SAS Administrators

Uttam KumarApril 19, 2016 0

Accessing SPD Engine Data using Hive

With the release of SAS® 9.4 M3, you can now access SAS Scalable Performance Data Engine (SPD Engine) data using Hive. SAS provides a custom Hive SerDe for reading SAS SPD Engine data stored on HDFS, enabling users to access the SPD Engine table from other applications. The SPD Engine

Read More

English

Learn SAS | Programming Tips | Risk Management

Leonid BatkhanApril 13, 2016 0

Automatic data suppression in SAS reports

Have you ever used SAS to produce reports for publishing? Have you ever thought of or been told about suppressing data in such reports? Why do we need to suppress (in the sense of withholding, concealing, obscuring or hiding) data in published reports? The reason is simple - in order

Read More

English

Programming Tips | SAS Administrators

Tricia JenkinsApril 12, 2016 0

Let me help you with that! A technical SAS resource guide

On the search for some SAS notes, workarounds or sample code? What you may not know is that there are a ton of SAS resources out there providing examples, tips and tricks that are great to have in your tool belt! Many of these resources provide sufficient insight and resolutions

Read More

English

Programming Tips

Chris HemedingerApril 6, 2016 0

Boaty McBoatface is on the run

I know what you're thinking: two "Boaty McBoatface" articles within two weeks? And we're past April Fool's Day? But since I posted my original analysis about the "Name our ship" phenomenon that's happening in the UK right now, a new contender has appeared: Poppy-Mai. The cause of Poppy-Mai, a critically

Read More

English

Programming Tips

Edoardo RivaApril 6, 2016 0

SAS Studio Parallel Process Flows

One of the hidden gems of SAS Studio is the ability to run process flows in parallel. This feature really shines when used in a grid environment. Let’s discuss this one step at a time. First, what is a process flow? When working in the Visual Programmer perspective, you have

Read More

English

Programming Tips | SAS Administrators

Scott McCauleyApril 4, 2016 0

SAS Visual Analytics autoload configuration made easy

In the past, configuring a new autoload library for SAS Visual Analytics was a manual process involving steps to create very specific folder structures and to copy and edit scripts and SAS programs. No more! Updates to the SAS Deployment Manager have added a new task that creates and configures new autoload libraries

Read More

English