The Juletip of today is simple but useful. When using PROC SQL it is often handy to export the number of observations of the resulting table into a macro variable. The good thing is that SAS does this automatically. The name of this macro variable is “sqlobs”:
Look at this small sample code:
proc sql noprint;
create table extract as
select
*
from
sashelp.class
where sex='M'
;
quit;
%put NOTE: No. of males in sashelp.class: &sqlobs;
The resulting log:
1
2 proc sql noprint;
3 create table extract as
4 select
5 *
6 from
7 sashelp.class
8 where sex='M'
9 ;
NOTE: Table WORK.EXTRACT created, with 10 rows and 5 columns.
10 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds
11
12 %put NOTE: No. of males in sashelp.class: &sqlobs;
NOTE: No. of males in sashelp.class: 10
Merry Christmas and a Happy New Year!
Niels-Kenneth Nielsen
... View more