SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Gerry NelsonAugust 17, 2017 6

SAS Viya sharing credentials for database access

SAS Viya deployments use credentials for accessing databases and other third-party products that require authentication. In this blog post, I will look at how this sharing of credentials is implemented in SAS Environment Manager. In SAS Viya, domains are used to store the: Credentials required to access external data sources. Identities

English

Learn SAS | Programming Tips

Leonid BatkhanAugust 2, 2017 71

CALL EXECUTE made easy for SAS data-driven programming

In my prior posts (Data-driven SAS macro loops, Modifying variable attributes in all datasets of a SAS library, Automating the loading of multiple database tables into SAS tables), I presented various data-driven applications using SAS macro loops. However, macro loops are not the only tools available in SAS for developing

English

Data Visualization | Programming Tips

Teri PatsilarasJuly 26, 2017 4

SAS Visual Analytics 8.1: Configuring prompts with different source data

In a previous blog, I describe how there are a few new features related to report and page prompts in SAS Visual Analytics 8.1; namely the ability to configure cascading prompts in VA 8.1: Cascading Prompts as Report and Page Prompts. In this blog, I will cover how to configure prompts, either

English

Learn SAS | Programming Tips

Larry LaRussoJuly 25, 2017 26

Programming tips from experienced SAS users

Trivial Pursuit, Justin Bieber and Timbits. Some pretty great things have come from Canada, eh? Well, you can go ahead and add expert SAS programmers to that impressive list. In this video, six Canadian SAS programmers, with more than 115 years of SAS programming experience between them, share some of their favorite, little-known SAS programming tips. You're sure to discover a new trick or

English

Programming Tips

Kathryn McLawhornJuly 21, 2017 0

Selecting the top n% and bottom n% of observations from a data set

SAS® offers several ways that you can find the top n% and bottom n% of data values based on a numeric variable. The RANK procedure with the GROUPS= option is one method. Another method is The UNIVARIATE procedure with the PCTLPTS= option. Because there are several ways to perform this

English

Programming Tips

Russ TyndallJune 16, 2017 2

Using parameters within the macro facility

Have you ever written a macro and wondered if there was an easy way to pass values to the macro? You can by using macro parameters. Macro parameters enable you to pass values into the macro at macro invocation, and set default values for macro variables within the macro definition.

English

Learn SAS | Programming Tips

Leonid BatkhanJune 6, 2017 13

Combine and conquer with SAS

The ancient political maxim “divide and conquer” (Lat. “dīvide et īmpera”) has been used for millennia in politics, sociology, and psychology, mainly to manipulate people. In the last two centuries, however, this principle has also been adopted by computer science. It is widely used in computer programming, primarily in computer

English

Data Visualization | Programming Tips

Bobbie WagonerJune 5, 2017 0

The new Data Pane in SAS Visual Analytics - It's painless!

Refining your data for effective reports is even easier in the 8.1 release of SAS Visual Analytics. In this blog post, I’ll take a look at the data pane, how it displays data from your active data source, and a few tasks that you might want to perform, such as

English

Data Visualization | Programming Tips

Teri PatsilarasJune 1, 2017 0

Cascading Prompts as Report and Page Prompts in SAS Visual Analytics

There are several exciting new features available in SAS Visual Analytics 8.1 that I know will excite you; this blog will show you how you can now configure cascading prompts for the Report Prompt and Page Prompt areas! Prior to SAS Visual Analytics 8.1 there was a way to use parameters to configure cascading prompts for

English

Programming Tips

Warren F. KuhfeldMay 30, 2017 0

The BEST D formats that you have ever seen!

The Dw.p format displays numeric values, in a field w positions wide, possibly with a great range of values, lining up decimals for values of similar magnitude. The BESTDw.pformat combines the BESTw. format for integers and the Dw.p format for nonintegers. Specifying BESTDw.p (where p = w - 1) is better than specifying BESTw. for columns, since decimals do not shift when the last digit is 0.

English

Blogs

Blogs

Programming Tips