As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Tip of the Day:April 4"

From sasCommunity
Jump to: navigation, search
m (scheduled Calculating Ages)
(Scheduled Highlighting report cells with no data)
 
Line 5: Line 5:
 
sasCommunity Tip of the Day
 
sasCommunity Tip of the Day
 
</h1><div style="padding:10px;">
 
</h1><div style="padding:10px;">
{{Tips:Calculating Ages}}
+
{{Tips:Highlighting report cells with no data}}
 
<div style="width:100%"><hr></div>
 
<div style="width:100%"><hr></div>
Feel free to [[Tips Talk:Calculating Ages|comment]] on this tip.
+
Feel free to [[Tips Talk:Highlighting report cells with no data|comment]] on this tip.
 
</div>
 
</div>
 
</td></tr>
 
</td></tr>

Latest revision as of 21:11, 29 March 2011

sasCommunity Tip of the Day

Have you ever produced a report and needed to highlight cells with no data to make sure that they don't get lost/missed?

If so, you can take advantage of the fact that you can use formats to specify the style attributes for a cell. Typically this is done to provide traffic highlighting of values (e.g., show different ranges in different colors).

In the example shown at right a format is created to map missing values to yellow and all other values to white. The format is then used to provide the background color for the cell. This results in cells with no data being highlighted in yellow.

proc format;
    value highlite . = 'yellow'
               other = 'white';
run;
 
proc report data = sashelp.class nowd;
    columns age sex,(height weight);
    define age / group;
    define sex / group across;
    define height / sum style=[background=highlite.];
    define weight / sum style=[background=highlite.];
run;

Checkout the read more link for more examples of proc report techniques.

Submitted By Don Henderson



Feel free to comment on this tip.


Prior tip - Next tip - Random Tip

Submit a Tip