Using SQL to Create Macro Variables in SAS | Data tutorial | PROC SQL 

In this Green Numbers data tutorial I show you how to use SQL to create macro variables to make your coding more efficient. Because SQL is great for aggregating, it’s a great tool for generating lists. In each example, I show you how to create the macro variable then show you how the variable can be used. I start simple then get progressively more complex.