https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60846#M7246 Hello all; <BR /> I have two groups that are color coded based on certain parameters. The call define statement works just fine if I do not use the order parameter. However based on the code below it properly colors the first observation in each group.<BR /> However I need the order statement to separate the two groups. <BR /> <BR /> The code follows below. _NAME_ is actually the category but was renamed in the proc transpose statement... <BR /> <BR /> Any suggestions helpful... Thanks... <BR /> <BR /> proc report nowd; <BR /> COLUMNS _NAME_ UNIT _1 _200807 _200808 _200809 _200810 _2; <BR /> DEFINE _NAME_ /order " " style={background=lavender}; <BR /> DEFINE _1/"FY08";<BR /> DEFINE _2/"FYTD";<BR /> <BR /> <BR /> compute _2;<BR /> if _NAME_='VAP RATE (per 1000 device days)' THEN DO;<BR /> IF substr(_2,1,3)&gt;1.3 then do;<BR /> call define (_col_, 'style','style={background=light red}'); <BR /> end;<BR /> end;<BR /> if _NAME_='VAP RATE (per 1000 device days)' THEN DO;<BR /> IF substr(_2,1,3)&lt;1.3 then do;<BR /> call define (_col_, 'style','style={background=light green}');<BR /> end;<BR /> end;<BR /> endcomp; Wed, 12 Nov 2008 17:09:26 GMT _LB 2008-11-12T17:09:26Z https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60846#M7246 Hello all; <BR /> I have two groups that are color coded based on certain parameters. The call define statement works just fine if I do not use the order parameter. However based on the code below it properly colors the first observation in each group.<BR /> However I need the order statement to separate the two groups. <BR /> <BR /> The code follows below. _NAME_ is actually the category but was renamed in the proc transpose statement... <BR /> <BR /> Any suggestions helpful... Thanks... <BR /> <BR /> proc report nowd; <BR /> COLUMNS _NAME_ UNIT _1 _200807 _200808 _200809 _200810 _2; <BR /> DEFINE _NAME_ /order " " style={background=lavender}; <BR /> DEFINE _1/"FY08";<BR /> DEFINE _2/"FYTD";<BR /> <BR /> <BR /> compute _2;<BR /> if _NAME_='VAP RATE (per 1000 device days)' THEN DO;<BR /> IF substr(_2,1,3)&gt;1.3 then do;<BR /> call define (_col_, 'style','style={background=light red}'); <BR /> end;<BR /> end;<BR /> if _NAME_='VAP RATE (per 1000 device days)' THEN DO;<BR /> IF substr(_2,1,3)&lt;1.3 then do;<BR /> call define (_col_, 'style','style={background=light green}');<BR /> end;<BR /> end;<BR /> endcomp; Wed, 12 Nov 2008 17:09:26 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60846#M7246 _LB 2008-11-12T17:09:26Z https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60847#M7247 If I add a category I can get it to work properly, <BR /> but then if I format the the order by variable to names it will order them alphabetically-how do I stop this-<BR /> <BR /> And how I suppress or leavea column intentially blank...<BR /> Thanks.. <BR /> <BR /> Lawrence Wed, 12 Nov 2008 17:28:10 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60847#M7247 _LB 2008-11-12T17:28:10Z https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60848#M7248 Nevermind I got it... Wed, 12 Nov 2008 17:59:12 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/PROC-REPORT-order-statement-compute/m-p/60848#M7248 _LB 2008-11-12T17:59:12Z