SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Leonid BatkhanDecember 15, 2016 28

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,

English

Programming Tips

Edoardo RivaDecember 12, 2016 2

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

English

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

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

Blogs

Blogs

Programming Tips