Friday, December 31, 2010

SAS 1001 Tips - Tip 3 - reading number of observations from a dataset and storing into a macro variable

/*********************************************/;
proc sql noprint;
create table sqla as
select *
from a;
quit;

%put Number of observatrions=&sqlobs;
/* The number of observations is stored in a macro variable initiated by proc sql *
/*********************************************/;

Question:

1. what are the other built in macro values that can be extracted using proc SQL?

No comments: