You cannot in SQL.  I would however question the benefitof splitting the data in the first place.  First off you are multiplying the size of the size as you have each of the header blocks in addition, so this method takes more space.  It is also harder to program with as you need to know the datasets, and program for each of them.  A simpler methodology is to apply the grouping in the data, and then use that grouping.  Say you want to print each of those groups to a diffrent page: DATA lt_15k lt_20k lt_30k lt_40k gt_40k; set sas1.cars; if price le 15 then Output lt_15k; if (15<price<=20) then Output lt_20k; if (20<price<=30) then Output lt_30k; if (30<price<=40) then Output lt_40k; if (price>40) then output gt_40k; run; title "Group1 "; Proc print data=lt_15k_20k; run; title "Group2"; proc print data=... Or, and this should look simpler: data want; set sas1.cars; if price le 15 then group="lt_15k"; if (15<price<=20) then group="t_20k"; if (20<price<=30) then group="lt_30k"; if (30<price<=40) then group="lt_40k"; if (price>40) then group="gt_40k"; run; proc print data=want; by group; title "Group: #byval1"; run; ... View more

The sample data you're using illustrates why you shouldn't code "else do; flag = 'last week' ; end;" but should calculate "last week" and then eventually have an other case like "else flag='earlier weeks'  " Below a code sample based on your code but using a format instead. data fmt_source;   format start date9.;   length label $20.;   retain fmtname 'WeekGroup';   retain type 'N';   do start=intnx('year',today(),-1) to today();     week=intck('week',start,today());     select(week);       when(0)   label='This Week';       when(1)   label='Last Week';       otherwise label=catx(' ',week,'weeks ago');     end;     output;   end; run; proc format cntlin=fmt_source; run; data src_rec;   input name $ sex $ school $ dt date9. score;   datalines; AAA F Law 9-sep-14 10 BBB F IT 10-Aug-14 20 CCC M Law 19-Sep-14 30 DDD F Art 10-Dec-14 25 EEE F Law 9-sep-14 40 FFF M Biz 10-Aug-14 45 GGG F Law 9-Dec-14 55 HHH M IT  6-Dec-14 50 III M Law 19-Nov-14 45 JJJ M Art 10-Aug-14 20 kkk F Law 9-Dec-14 25 lll F Biz 8-Dec-14 20 ; run; proc tabulate data = src_rec order=unformatted;   class school sex dt;   var score;   format dt WeekGroup.;   table (school*sex ),dt='No of student Registered'*n=''(dt='Sum of score'*score=''*sum='')(dt='Avg of score'*score=''*mean=''); run; ... View more