on 12-14-2016 01:42 AM
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!