10-07-2005, 02:15 PM
|
|||
|
|||
Proc report: How to break only on certain values of a variable?
Hi Everyone,
3 questions: 1) How do I break only on certain values of a variable? I have an order variable values 1,2,3,4,5,6,7,8, etc. that I'd like to add a blank line after values 2 and 6. I tried making another variable called comment that would only change value at one place, but can't get it to give me a line just there. 2) Also, how do I get gridlines in proc template? I currently am NOT getting gridlines and would like them. 3) How do I list the whole tagset to see all the options and how they are set? Thanks everyone! My code: proc template; define tagset tagsets.test; parent=tagsets.htmlcss; define event doc; start: put '<html xmlns  ="urn:schemas-microsoft-comfficeffice"' NL;put 'xmlns:x="urn:schemas-microsoft-com ffice:excel">' NL;finish: put "</html>" NL; end; define event doc_head; start: put "<head>" NL; put VALUE NL; put "<style>" NL; put "<!--" NL; trigger alignstyle; put "-->" NL; put "</style>" NL; finish: put "<xml>" NL; put "<o  ocumentProperties>" NL; ;put " <o:Subject>Report</o:Subject>" nl; put " <o:Author>Robert </o:Author>" nl; put " <o:Company>abc</o:Company>" nl; put " </o ocumentProperties>" nl;put "<x:ExcelWorkbook>" NL; put " <x:ExcelWorksheets>" NL; put " <x:ExcelWorksheet>" NL; put " <x:Name>Sheet1</x:Name>" NL; put " <x:WorksheetOptions>" NL; put " <x:FitToPage/>" NL; put " <x isplayPageBreak/>" NL;put " <x:Print>" NL; put " <x:ValidPrinterInfo/>" NL; put " <x:PaperSizeIndex>5</x:PaperSizeIndex>" NL; put " <x:HorizontalResolution>600</x:HorizontalResolution>" NL; put " <x:VerticalResolution>600</x:VerticalResolution>" NL; put " </x:Print>" NL; put " </x:WorksheetOptions>" NL; put " </x:ExcelWorksheet>" NL; put " </x:ExcelWorksheets>" NL; put "</x:ExcelWorkbook>" NL; put "</xml>" NL; put "</head>" NL; end; define event data; put "<td"; put ' width=' cellwidth; trigger preimage; putq " class=" HTMLCLASS; trigger align; trigger style_inline; trigger rowcol; put ">"; put VALUE NL; finish: trigger postimage; put "</td>" NL; end; end; run; proc report data=sasdata.report nowd missing nocenter /*nocompletecols nocompleterows */ style(HEADER)={just=left font_style=roman font_face="courier" font_weight=bold font_size=12pt background=white foreground=black} style(report)=[cellspacing=5 borderwidth=10 /*bordercolor=blue*/]; column (" " order field comment churn_y,churn_m,calc_pct) flag; define order /group noprint ' ' ; define flag /style=[background=white]; define field /group ' ' style={just=left}; define comment /computed noprint ' ' ; define churn_y /across ' ' left order=internal ; define churn_m /across ' ' right order=internal style= [background=LightBlue]; define calc_pct /sum ' ' ; break after flag/style={htmlstyle='Border-Top:10px double blue;Border- Bottom:none'}; compute flag; call define('_c1_','style','style=[background=White ]'); call define('_c2_','style','style=[background=White ]'); call define('_c3_','style','style=[background=White ]'); call define('_c4_','style','style=[background=White ]'); call define('_c5_','style','style=[background=White ]'); call define('_c6_','style','style=[background=White ]'); call define('_c7_','style','style=[background=White ]'); call define('_c8_','style','style=[background=White ]'); call define('_c9_','style','style=[background=White ]'); call define('_c10_','style','style=[background=White ]'); call define('_c11_','style','style=[background=White ]'); call define('_c12_','style','style=[background=White ]'); call define('_c13_','style','style=[background=White ]'); call define('_c14_','style','style=[background=White ]'); call define('_c15_','style','style=[background=White ]'); call define('_c16_','style','style=[background=White ]'); call define('_c17_','style','style=[background=White ]'); call define('_c18_','style','style=[background=White ]'); call define('_c19_','style','style=[background=White ]'); call define('_c20_','style','style=[background=White ]'); call define('_c21_','style','style=[background=White ]'); call define('_c22_','style','style=[background=White ]'); call define('_c23_','style','style=[background=White ]'); call define('_c24_','style','style=[background=White ]'); if order= 3 then do; call define('_c1_','style','style=[background=SkyBlue ]'); call define('_c2_','style','style=[background=SkyBlue ]'); call define('_c3_','style','style=[background=SkyBlue ]'); call define('_c4_','style','style=[background=SkyBlue ]'); call define('_c5_','style','style=[background=SkyBlue ]'); call define('_c6_','style','style=[background=SkyBlue ]'); call define('_c7_','style','style=[background=SkyBlue ]'); call define('_c8_','style','style=[background=SkyBlue ]'); call define('_c9_','style','style=[background=SkyBlue ]'); call define('_c10_','style','style=[background=SkyBlue ]'); call define('_c11_','style','style=[background=SkyBlue ]'); call define('_c12_','style','style=[background=SkyBlue ]'); call define('_c13_','style','style=[background=SkyBlue ]'); call define('_c14_','style','style=[background=SkyBlue ]'); call define('_c15_','style','style=[background=SkyBlue ]'); call define('_c16_','style','style=[background=SkyBlue ]'); call define('_c17_','style','style=[background=SkyBlue ]'); call define('_c18_','style','style=[background=SkyBlue ]'); call define('_c19_','style','style=[background=SkyBlue ]'); call define('_c20_','style','style=[background=SkyBlue ]'); call define('_c21_','style','style=[background=SkyBlue ]'); call define('_c22_','style','style=[background=SkyBlue ]'); call define('_c23_','style','style=[background=SkyBlue ]'); call define('_c24_','style','style=[background=SkyBlue ]'); end; endcomp; compute comment /char length=10; if order<=3 then do; comment='ARGH'; end; endcomp; ods proclabel=" "; run; ods markup close; run; 
|
|
Today
|
||||
|
||||
Sponsored Links
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Re: NEED SAS examples on Conjoint Analysis and MDS | Wu Consulting | Newsgroup comp.soft-sys.sas | 0 | 10-23-2006 01:29 PM |
| PROC REPORT & BREAK line & outputting report using ODS | kat j | Newsgroup comp.soft-sys.sas | 0 | 06-21-2006 05:56 PM |
| Re: proc report: Changing missing values to show as zeros | B C | Newsgroup comp.soft-sys.sas | 0 | 09-30-2005 05:44 PM |
| Re: Count unique numbers in Proc Report | Jack Hamilton | Newsgroup comp.soft-sys.sas | 0 | 04-22-2005 05:51 PM |
| Re: Number of Records | Pardee, Roy | Newsgroup comp.soft-sys.sas | 0 | 10-29-2004 08:31 PM |
Linear Mode
