Cynthia How can we do a similar thing inside SAS AddIn for excel ? I need multiple sheets not necessarily using by groups. Here is the code I was using . The file = _webout doesnt seem to work. I get an error message saying "....The SAS report results could not be processed.The 'CSV' satrt tag on line 24 doesnot match endtag of 'Data'. Line 25, position 3." ods tagsets.Myexcelxp file = _webout style= ReportTemplate options(sheet_name='Summary Store Ct' absolute_column_width='15,15,15,15,15,15,15,15,15,15' center_Horizontal='yes' center_vertical='yes' orientation='landscape' frozen_headers='1' fittopage='yes' pages_fitheight='40' pages_fitwidth='1' ); proc report data= Summary_final; **specifying columns; column family POSITION_redzone_conv POSITION_redzone_hme POSITION_redzone_fs POSITION_redzone_back POSITION_1 POSITION_2 POSITION_3 POSITION_4 POSITION_5 POSITION_6; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_redzone_conv / display 'RedZone Front' style(column)={just=center borderbottomwidth=1 bordertopwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_redzone_hme / display 'RedZone Right' style(column)={just=center borderbottomwidth=1 bordertopwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_redzone_fs / display 'RedZone Left' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_redzone_back / display 'RedZone Back' style(column)={just=center borderbottomwidth=1 bordertopwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_1 / nozero 'Window Position 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_2 / nozero 'Window Position 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_3 / nozero 'Window Position 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_4 / nozero 'Window Position 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_5 / nozero 'Window Position 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define POSITION_6 / nozero 'Window Position 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Missing Positions*****************************/ ods tagsets.Myexcelxp options(sheet_name='Missing Positions' absolute_column_width='10,20' center_Horizontal='yes' center_vertical='yes' orientation='landscape' frozen_headers='1' fittopage='yes' pages_fitheight='40' pages_fitwidth='1' ); proc report data=missing_position; **specifying columns; column store OIL_LOCATI; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define OIL_LOCATI / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************RedZone Front*****************************/ ods tagsets.Myexcelxp options(sheet_name='RedZone Front' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Redzone_front_final missing; **specifying columns; column store position family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************RedZone Left*****************************/ ods tagsets.Myexcelxp options(sheet_name='RedZone Left' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Redzone_fs_final missing; **specifying columns; column store position family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************RedZone Left*****************************/ ods tagsets.Myexcelxp options(sheet_name='RedZone Right' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Redzone_hme_final missing; **specifying columns; column store position family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************RedZone Back*****************************/ ods tagsets.Myexcelxp options(sheet_name='RedZone Back' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Redzone_back_final missing; **specifying columns; column store position family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 1*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 1' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_1_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 2*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 2' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_2_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 3*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 3' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_3_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 4*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 4' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_4_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 5*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 5' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_5_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /*************Position 6*****************************/ ods tagsets.Myexcelxp options(sheet_name='Position 6' absolute_column_width='10,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15'); proc report data=Pos_6_final missing; **specifying columns; column store oil_location family rank_1 rank_2 rank_3 rank_4 rank_5 rank_6 rank_7 rank_8 rank_9 rank_10 rank_11 rank_12 rank_13 rank_14 rank_15; define store / display 'Store' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define position / display 'Position' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define family / display 'Family' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_1 / 'Rank 1' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_2 / 'Rank 2' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_3 / 'Rank 3' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_4 / 'Rank 4' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_5 / 'Rank 5' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_6 / 'Rank 6' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_7 / 'Rank 7' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_8 / 'Rank 8' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_9 / 'Rank 9' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_10 / 'Rank 10' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_11 / 'Rank 11' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_12 / 'Rank 12' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_13 / 'Rank 13' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_14 / 'Rank 14' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; define rank_15 / 'Rank 15' style(column)={just=center bordertopwidth=1 borderbottomwidth=1 borderleftwidth=2 borderrightwidth=2 font=("Arial",8pt)} style( header) = {borderleftwidth=2 borderrightwidth=2 borderbottomwidth=2 font=("Arial",8pt,Bold)}; run; /** closing excel file;*/ ods tagsets.Myexcelxp close; ods listing;
... View more