Proc SQL and the power of select into

This post was kindly contributed by AFHood Group Blog » SAS - go there to comment and to read the full post.

I have referenced this paper many times. Great help in using the power of proc sql with macro variables. Great for building lists of values and dynamic code.

http://www.nesug.org/Proceedings/nesug97/coders/eddlesto.pdf

Syntax:

SELECT object-item <,objectitem>…
<\ INTO macro-variablespecification <, macro-variablespecification> …>
FROM from-list …;

This post was kindly contributed by AFHood Group Blog » SAS - go there to comment and to read the full post.