PROC SQL is a very powerful way to create macro variables but as far as I can only create LOCAL variables unless I %GLOBAL the names before running SQL. It would be nice to add a GLOBAL option to the INTO statement so that macro variables are created as GLOBAL.