Prev: SAS 9.2 CHAR to NUM
Next: Concordance logistic regression SAS
From: Arthur Tabachneck on 20 Feb 2010 13:00
While investigating one of this morning's posts, I was playing around with
proc sql's feedback option. The original question was whether one could
use a variable list in sql.

Thus given data like:

data have;
input qtr Col1 Col2 Col15676 Col15677 Col15678 Col15679
Col15680 Col15681 Col15683 ColX;
cards;
1 1 2 3 4 5 6 7 8 9 0
2 9 8 7 6 5 4 3 2 1 0
;

one could easily write something like the following to keep everything but
ColX:

%let qtr=1;
proc sql feedback;
select *
from have (keep=Col1 Col2 Col15676-Col15681 Col15683)
where qtr=&qtr.
;
quit;

SAS will put the full variable list into the log. Other than capturing
and parsing the log, is there a direct way to access the variable names
that SAS is obviously storing somewhere? The goal, in this case, would be
to include those names in an into: statement.

Art
 | 
Pages: 1
Prev: SAS 9.2 CHAR to NUM
Next: Concordance logistic regression SAS