I make a PROC TABULATE giving the number of occurrences per region (REGION), per sector (MACTIV) and per month. So, as seen in the table below, there are 113 occurrences in region 01, in the secondary activities, in april 2009. But, I need the labels per row to be repeated, because, I export this PROC TABULATE to an Excel file using ODS EXCEL FILE and use anoter Excel file takes the needed values with an INDEX-MATCH. This INDEX-MATCH looks up for the month by column (no problem) but also the REGION and the MACTIV per row. So, in order to have the row labels to be repeated, I use the same PROC TABULATE, adding the BY REGION statement. PROC TABULATE DATA = data; option missing=0; BY REGION; CLASS REGION MACTIV DATE / MLF MISSING ; TABLE (MACTIV *REGION), DATE / printmiss nocellmerge ; RUN; This allows me to have one table for each region, and having both REGION and MACTIV labels to be repeated. Therefore, I can use the INDEX-MATCH. But, this time, the problem is that the tables are not same. If, there is a region that has no occurrences for some months or sectors, these rows & columns won’t appear. I didn't have this problem in the first PROC TABULATE, thanks to the PRINTMISS option. But, afer adding BY REGION statement, the tables are not standardized. Below, you can see the tables for region 04 and 06 that are very different : My question is; how can I have standardized tables (same rows and columns, as in regular PROC TABULATE) and also repeated label names (as in the PROB TABULATE with the BY statement)? Thank you very much,
... View more