When trying this, keep in mind that your HW should be able to to this in a reasonable manner. Starting up the parallel processes will take time and resources, and when those processes compete for resources (CPU cores, RAM, disk access), they may actually slow each other down so that the final result is worse (slower) than simple processing in succession. A process that runs for 2 minutes and is repeated 10 times takes 20 minutes, but running the 10 processes in parallel may easily take you more than an hour, if your server is not designed for parallel work. ... View more

You could do something like : libname x excel 'c:\temp\x.xls' getnames=no; data _null_; set sashelp.vmember(where=(libname='X')); call execute('data temp;                  set x."'||memname||'"n;                  retain tname "'||memname||'";                  if _n_ in (10 20);run;               proc append base=want data=temp force;run;'); run; Xia Keshan ... View more

Thanks Ballardw, Thanks Cynthia.. Will try some other workarounds.... ... View more

Hi:   I mocked up 3 different possibilities with PROC REPORT. It does NOT have a BOX area like TABULATE. So the 3 screenshots are what your report would look like -- for 1 division -- for example...#1 and #2 show how the Division value can be put on the report and #3 shows the color coding for just the AD values of PERIOD. The #3 approach will work no matter if you choose #1 look or #2 look for DIVISION values. I created the report for 1 DIVISION, using BY TABBLE in the REPORT code.   One difference between REPORT and TABULATE is that REPORT does not show a BOX at the intersection of row & column headers, like TABULATE, because REPORT builds the output report differently from TABULATE. This is closer to what you want than you could get with PROC TEMPLATE. REPORT does require a slightly different structure to your DATA. cynthia ... View more