Macro variable in PROC SQL

There are two ways to store values of column in PROC SQL.
1. mv with separator, which store values of the rows into one mv
2. mv range, which store value of one row per mv

* Sample code;
proc sql;
   select distinct sex, name 
   into:sex seperated by ' ', :name1-:name100
   from sashelp.class;

   %let num = &sqlobs;
quit;

%put Number: &sqlobs;
%put _global_;