SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

Programming Tips

Jody CarltonMay 19, 2017 1

Demystifying and resolving common transcoding problems

Technical Support regularly receives incoming calls from customers who have encountered the following transcoding warning: WARNING: Some character data was lost during transcoding in the data set xxx.xxx. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding People are not always

English

Analytics | Programming Tips

Lavanya MandavilliMay 4, 2017 1

Linking to target reports and sections in SAS Visual Analytics 7.4

SAS Visual Analytics 7.4 comes chock-full of new features. Report and section linking come with an added benefit. If you set up linking from one section to another section in the same report, or from one report to another report, you have the option to configure linking such that any filter

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanApril 27, 2017 8

Automating the loading of multiple database tables into SAS tables

When developing SAS applications, you can feed database tables into your application by using the libname access engine either by directly referring a database table, or via SAS or database views that themselves refer to one or more of the database tables. More on Automation with SAS: Let SAS write

English

Programming Tips

Martin MinceyApril 21, 2017 19

Use SAS to send an email that embeds a graph in the body of the email

When using the SAS® system to email graphics output, a common request is to use SAS to send an email in which the graphics output is embedded in the body of the email. This functionality is not available until the second maintenance release for SAS® 9.4 (TS1M2). If you are

English

Blogs

Blogs

Programming Tips