SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chevell ParkerJune 24, 2016 8

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

English

Programming Tips

Bobbie WagonerJune 21, 2016 4

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

English

Programming Tips | SAS Administrators

Dave NadenJune 13, 2016 1

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

English

Data Management | Programming Tips

Mary Kathryn QueenJune 3, 2016 1

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

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

English

Programming Tips

Teri PatsilarasMay 25, 2016 1

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

English

Learn SAS | Programming Tips

Leonid BatkhanMay 23, 2016 16

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

English

Programming Tips

Kathryn McLawhornMay 20, 2016 4

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

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

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

English

Blogs

Blogs

Programming Tips