Perfect, thank you very much! It's a longer solution than what I expected but this is exactly what I wanted. Thank you very much! ... View more

Thank you so much! It worked perfectly! ... View more

@commitsudoku wrote: Thanks to all the bits you gave, I think I have found the solution, without using the BY statemen. So here is the code that worked for me. I thank you all very much for your help!    data data; set sashelp.cars;run; data classes; input id_reg reg_name $ ; cards; 1 Asia 2 Europe 3 USA run; %macro comp; %local i ; %do i=1 %to 3; proc sql ; select reg_name into :reg_name from classes where id_reg = &i.; quit; PROC TABULATE DATA = data(where=(Origin="&reg_name")) out=tabulate_&i; CLASS Make DriveTrain ; TABLE (Make), (DriveTrain) / nocellmerge ; run; %end; %mend comp; %comp I still think that @PeterClemmensen's suggestion of using a PAGE expression makes sense. If the purpose of the exercise is to create a data set the information for which page the table is from is in the output data set in the _page_ variable (which doesn't appear in the set if a page dimension is not used). ... View more