Hi, I'm trying to suppress blank rows above and below a header created via an across statement in a proc report (SAS 9.2) . I'd like that the header contains the 2 solid lines (one above and one below) as the example below but with the blank rows deleted. Below the example and the corresponding SAS code I used. Many thanks for your help, Ingrid Example : TITLE_1 Region: Pacific ________________________________________________________________________________ TO BE DELETED Kuala Auckland Canberra Jakarta Lumpur Manila Singapore TO BE DELETED ____________________________________________________________________________TO BE DELETED Men's Casual $24,733 $373,908 $106,657 $128,309 $28,761 Men's Dress $4,892 $4,231 $186,631 $55,667 $144,151 $30,619 Slipper $33,000 $44,121 $22,060 $83,212 $171,735 $36,612 Women's Casual $18,189 $15,032 $18,761 $36,110 $131,794 Women's Dress $42,760 $21,486 $4,659 $61,108 $229,372 $40,056 ________________________________________________________________________________________________________ FOOTNOTE_1 SAS code: proc sort data=sashelp.shoes out=shoes; where region in ('Asia', 'Pacific', 'Canada'); by region product; run; data shoes2; set shoes; if product in ( "Boot" "Sandal" "Sport Shoe") then pagen = 1; else pagen = 2; run; proc sort data=shoes2; by region pagen product; run; proc report nowd data=shoes2 center headline spacing=0 split='|' ls=133 ps=48 missing formchar(1)="_" out=test; column( '___' region pagen product Subsidiary ,Sales ) ; define region / noprint '' order order=internal group ; define pagen / noprint '' order order=internal group ; define product / with =20 '' order order=internal group ; define Subsidiary / width=25 '' group order=data across nozero center style(column)=[just=center]; define Sales / width=10 '' group center style(column)=[just=center] ; break after product/ skip; break after pagen/ page; compute before _page_; line @1 "TITLE_1"; line @1 " "; line @1 "Region: " region $20.; endcomp; compute after _page_; line @1 132*"_"; line @1 "FOOTNOTE_1 "; endcomp; run;
... View more