Exercises for Learning SAS Programming

Our new book, Exercises and Projects for The Little SAS® Book Fifth Edition, includes a variety of exercises to help people learn SAS programming. Rebecca Ottesen, Lora Delwiche and I designed this book so that it can be used either in a classroom setting or by individual readers working alone. [...]

Post a Comment

Macros Tip: %INCLUDE vs. Macro Language

This SAS author tip is from Robert Virgile, author of “SAS Macro Language Magic: Discovering Advanced Techniques”.  It actually came about when a reader posted a comment on one of Virgile’s blogs. Thank you to that reader for their comment! Technically, %INCLUDE is not part of macro language.  Yes, it [...]

Post a Comment

Macro Myth: The closest non-empty symbol table

This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. When CALL SYMPUT creates a new macro variable, it places that variable in “the closest non-empty symbol [...]

Post a Comment

What to do when all your boss wants is a spreadsheet

Most SAS programmers have been here. Someone just wants a handful of numbers that they can add to a graph or power point presentation that is due tomorrow. You have the data files, you have a job to summarize it, and you have a dilemma. How do I get my [...]

Post a Comment

SAS author’s tip: Macro language timing is everything

This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. In macro language, as in life, timing is everything.  Macro language students need to learn the timing [...]

Post a Comment

SAS author’s tip: Bayesian analysis of item response theory models

This SAS tip comes from Clement A. Stone and Xiaowen Zhu, authors of Bayesian Analysis of Item Response Theory Models using SAS. Item response theory (IRT) models are the models of choice for analyzing item responses from assessments in the educational, psychological, health, social, and behavioral sciences. SAS PROC MCMC [...]

Post a Comment

Raiders of the lost spreadsheet

Have you ever peered intently into an unfamiliar data delivery directory, realized what was in it, rolled over onto your side, stared blankly into the distance, and dejectedly uttered something akin to: "Spreadsheets! Why did it have to be spreadsheets?" If so, then we are definitely on the same page. [...]

Post a Comment

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