topic Proc Report Call Define in ODS and Base Reporting

Proc Report Call Define

Filipvdr — Thu, 17 Feb 2011 07:47:39 GMT

compute ENT_STATE;
if upcase(ENT_STATE) not in ('UP','') then
call define (_col_,'STYLE','style={background=#CD5916}');
endcomp;

hello, this works quite well, but actually i want to do this:

compute Tool;
if upcase(ENT_STATE) not in ('UP','') then
call define (_col_,'STYLE','style={background=#CD5916}');
endcomp;

so coloring one column depending on the value of an other variable, this doesn't work for me... any tips?

define Tool / display ;
define ExecBy/ display;
define Ent_State / display; Message was edited by: Filipvdr

Re: Proc Report Call Define

deleted_user — Thu, 17 Feb 2011 10:23:14 GMT

Hello,

does the Tool variable is before ENT_STATE variable in your column statement?

Marius

Re: Proc Report Call Define

Filipvdr — Thu, 17 Feb 2011 12:54:54 GMT

Yes

column OperSeq OpersAway Facility Lot_ID Operation PreferredTool OperParValue WaferstobeprocessedNr oCycleTime ExecBy OperOwner dpHold Holdnote ProcessEngineer Holdcode BatchEngineer Route Datim DaysOper Ent_State oper24 oper48;
/* Start Defining Columns */
define OperSeq / display ;
define OpersAway / display ;
define Facility / group;
define Lot_id /group;
define Operation / display width=15 FLOW;
define PreferredTool / display ;
define OperParValue / display ;
define WaferstobeprocessedNr / display ;
define oCycleTime/ display;
define ExecBy/ display noprint;
define OperOwner / display ;
define DpHold / display ;
define HoldNote / noprint ;
define ProcessEngineer / noprint ;
define HoldCode / noprint ;
define BatchEngineer / noprint ;
define Route / noprint ;
define Datim / display noprint ;
define DaysOper / display noprint ;
define Ent_State / display;

Tool = PreferredTool Message was edited by: Filipvdr

Re: Proc Report Call Define

deleted_user — Thu, 17 Feb 2011 13:35:33 GMT

hello,

I don't see your Tool variable on the column statement, but anyway I will give an example based on alises which may help you in solving your issue. the key is to have the values of the variable in the if clause availabe before the vlues of the variable you are trying to "polish":

[pre]
proc report data=sashelp.class nowd ;
column name=name_n age sex name ;

define name_n / noprint;
define sex / width=5 center;

compute sex;
if upcase(name_n) not in ('Alfred','') then
call define (_col_,'STYLE','style={background=#CD5916}');
endcomp;

run;
[/pre]

Marius

Re: Proc Report Call Define

Filipvdr — Thu, 17 Feb 2011 14:05:46 GMT

Ok, thanks, that worked.

Next question:

If the ent_state is not up, then i want PreferredTool (Ent_state) to be displayed

compute PreferredTool;
if upcase(ENT_STATE) not in ('UP','') then
call define (_col_,'STYLE','style={background=#CD5916}');
if upcase(ENT_STATE) not in ('UP','') then
PreferredTool = PreferredTool || "(" || ENT_STATE || ")" || ;
endcomp;

Re: Proc Report Call Define

Filipvdr — Tue, 22 Feb 2011 07:37:52 GMT

solved it by making this field in the dataset which is used Message was edited by: Filipvdr