SAS Users

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

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

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

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 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

Learn SAS | SAS Events

Larry LaRussoApril 18, 2017 2

Nurturing the #lifelearner in all of us

In addition to his day job as Chief Technology Officer at SAS, Oliver Schabenberger is a committed lifelong learner. During his opening remarks for the SAS Technology Connection at SAS Global Forum 2017, Schabenberger confessed to having a persistent nervous curiosity, and insisted that he’s “learning every day.” And, he

English

Learn SAS | Programming Tips

Leonid BatkhanApril 13, 2017 39

One deadly sin SAS programmers should stop committing

Even if you are a traditional SAS programmer and have nothing to do with cybersecurity, you still probably have to deal with this issue in your day-to-day work. The world has changed, and what you do as a SAS programmer is not just between you and your computer anymore. However,

English

Learn SAS | Programming Tips

Leonid BatkhanApril 1, 2017 26

SAS code to prove Fermat's Last Theorem

The full text of Fermat's statement, written in Latin, reads "Cubum autem in duos cubos, aut quadrato-quadratum in duos quadrato-quadratos, et generaliter nullam in infinitum ultra quadratum potestatem in duos eiusdem nominis fas est dividere cuius rei demonstrationem mirabilem sane detexi. Hanc marginis exiguitas non caperet." The English translation is:

English

Data Management | Learn SAS | Programming Tips

Leonid BatkhanMarch 28, 2017 12

Changing variable type and variable length in SAS datasets

There is a well-known Russian saying that goes “Если нельзя, но очень хочется, то можно.” The English translation of it can span anywhere from “If you can’t, but want it badly, then you can” to “If you shouldn’t, but want it badly, then you should” to “If you may not,

English

Learn SAS | Programming Tips

Leonid BatkhanFebruary 10, 2017 6

Truncating vs rounding SAS time values

Small matters matter. Imagine saving (or spending wisely) just 1 second of your time every hour. One measly second! During your lifespan you would save or spend wisely (1 sec-an-hour * 24 hours-a-day * 365 days-a-year * 100 years) / (3600 seconds-an-hour * 24 hours-a-day) = 10 days, a whole

English

Learn SAS | Programming Tips

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

Blogs

Blogs

Learn SAS