SAS author’s tip: A “most common” macro error

This week’s author tip is from Robert Virgile and his book SAS Macro Language Magic: Discovering Advanced Techniques.  Virgile chose this tip because even good programmer’s make errors. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. Even good programmers make errors.  In […]

Post a Comment

Using ‘options’ in the SAS Enterprise Guide query builder

Tucked in the SAS Enterprise Guide Query Builder there is a text box unhelpfully labelled 'Options'. To find it select Options -> Options for this query -> General, and it is about halfway down the screen. I am going to show you how to use that text box to make your tables smaller, and how […]

Post a Comment

SAS author’s tip: Getting the macro language to perform a %DO loop over a list of values

This week’s author tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”.  Virgile chose this tip because discovering and developing this technique will help you make the most of MACROS. We hope you find this tip useful. You can also read an excerpt from […]

Post a Comment

Five tips from Simulating Data with SAS

Data simulation is a fundamental technique in statistical programming and research. My book Simulating Data with SAS is an accessible how-to book that describes the most useful algorithms and the best programming techniques for efficient data simulation in SAS. Here are five lessons you can learn by reading it: Learn strategies […]

Post a Comment

SAS author's tip: Identifying FIRST.row and LAST.row in by-groups

A popular DATA step programming technique frequently used by SAS users is the ability to identify the beginning and ending observation in by-groups. The way it works is whenever a BY statement is specified with a SET statement, two temporary variables are created in the Program Data Vector (PDV), FIRST.variable […]

Post a Comment

SAS author’s tip: Wrangling specific statistical values from SAS output

This week’s author tip is from Jack Shostak’s new book SAS Programming in the Pharmaceutical Industry, Second Edition. If you're interested in this week's free tip and want to learn more about the topic or book, visit our online catalog. You'll find a free book excerpt, example code and data, and more. General […]

Post a Comment

SAS author's tip: Using the %SYSFUNC and %QSYSFUNC macro functions

This week’s author tip is from Michele Burlew and her new book SAS Macro Programming Made Easy, Third Edition. Burlew chose this tip because she says the %SYSFUNC and %QSYSFUNC functions allow you to use SAS language functions in macro programming. Access to these functions greatly increases macro programming power […]

Post a Comment

SAS author’s tip: What is Clinical Endpoint Committee data?

This week’s author tip is from Jack Shostak’s new book SAS Programming in the Pharmaceutical Industry, Second Edition. Shostak has been using SAS for nearly 30 years. In that time, he’s co-authored two other books, Common Statistical Methods for Clinical Research with SAS Examples, Third Edition, and Implementing CDISC Using […]

Post a Comment

SAS author's tip: Combining macro variables with text

This week’s author tip is from Michele Burlew and her new book SAS Macro Programming Made Easy, Third Edition. Burlew chose this tip because she says it’s important to understand how SAS determines where a macro variable reference starts and stops, and often a delimiter is needed to tell SAS […]

Post a Comment

SAS author’s tip: Getting an accurate picture of claims data

This week’s author tip is from Matthew Gillingham and his new book SAS Programming with Medicare Administrative Data. Gillingham has been programming in SAS for 15 years and has spent 10 of those years specifically dealing with health care use, cost and quality measurement. Here’s Gillingham’s tip for you: To […]

Post a Comment