SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanNovember 25, 2016 16

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

English

Data Visualization | Programming Tips

Teri PatsilarasNovember 15, 2016 3

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

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

English

Programming Tips

Russ TyndallOctober 21, 2016 4

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

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

English

Programming Tips

Andrew ChristianOctober 12, 2016 15

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

English

Programming Tips | SAS Administrators

Dave NadenOctober 6, 2016 4

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

English

Programming Tips | SAS Administrators

Gerry NelsonSeptember 29, 2016 3

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,

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

English

Blogs

Blogs

Programming Tips