Define statement options
Column-header – Defines the column header for the report item. Enclose each header in single or double quotation marks. When you specify multiple column headers, PROC REPORT uses a separate line for each one. The split character also splits a column header over multiple lines.
FORMAT=format – assigns a SAS format or a user-defined format to the report item. This format applies to report-item as PROC REPORT displays it; the format does not alter the format associated with a variable in the data set.
WIDTH=column – width defines the width of the column in which PROC REPORT displays report-item.
SPACING= – Specify the number of blank characters between columns.
Default spacing=2.
ORDER=DATA | FORMATTED | FREQ | INTERNAL – orders the values of a GROUP, ORDER, or ACROSS variable according to the specified order, where
DATA orders values according to their order in the input data set.
FORMATTED orders values by their formatted (external) values. By default, the order is ascending.
FREQ orders values by ascending frequency count.
INTERNAL orders values by their unformatted values, which yields the same order that PROC SORT would yield. This order is operating environment dependent. This sort sequence is particularly useful for displaying dates chronologically.
Applying attributes like Label, Width and Format of variables.
Proc report data= demo nowd ;
Column emp_id emp_name sex age income;
Define emp_id / ‘Emp ID’ order=data spacing=2;
Define emp_name/ ‘Emp Name’ spacing=2;
Define sex/ ‘Gender’ width=6 spacing=2;
Define age/ ‘Emp Age’ spacing=2;
Define income/ ‘Emp Earnings’ format=comma12. spacing=2;
Title ‘Emp Demographic Info ‘;
Title2 ‘Stansys Software Solutions’;
Footnote ‘This is a system generated mail please dont respond to this ‘;
Run;
Applying alignment for variables and data.
Center – Center align for data values
Left – Left align for data values, default character variables values are left aligned.
Right – Right align for data values, default numeric variables values are left aligned.
style(column)={just=center | left | right} – Alignment for data values
style(header)={just=center | left | right} – Alignment for column headers, default is center
Proc report data= demo nowd ;
Column emp_id emp_name sex age income;
Define emp_id / ‘Emp ID’ center ;
Define emp_name/ ‘Emp Name’ right;
Define sex/ ‘Gender’ width=6 right;
Define age/ ‘Emp Age’ left;
Define income/ ‘Emp Earnings’ format=comma12. center;
Title ‘Emp Demographic Info ‘;
Title2 ‘Stansys Software Solutions’;
Footnote ‘This is a system generated mail please dont respond to this ‘;
Run;
Proc report data= demo nowd ;
Column emp_id emp_name sex age income;
Define emp_id / ‘Emp ID’
style(column)={just=center} style(header)={just=right};
Define emp_name/ ‘Emp Name’
style(column)={just=center} style(header)={just=right};
Define sex/ ‘Gender’ width=6
style(column)={just=center} style(header)={just=right};
Define age/ ‘Emp Age’
style(column)={just=center} style(header)={just=right};
Define income/ ‘Emp Earnings’ format=comma12.
style(column)={just=center} style(header)={just=right} ;
Title ‘Emp Demographic Info ‘;
Title2 ‘Stansys Software Solutions’;
Footnote ‘This is a system generated mail please dont respond to this ‘;
Run;
Applying styles(colors) using define statement
Style={background=color} – Applying back ground color for column name and data.
Style={foreground=color} – Applying foreground color for column name and data.
Style={font_weight=bold} – Make font as bold.
Style={font_face=font name} – Change font type
Style={font_size=size of font} – Increase/decrease font_size.
Proc report data= demo nowd ;
Column emp_id emp_name sex age income;
Define emp_id / ‘Emp ID’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=magenta foreground=blue font_weight=bold font_face=calibri font_size=5};
Define emp_name/ ‘Emp Name’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=liolbr};
Define sex/ ‘Gender’ width=6 spacing=2
style(column)={just=center} style(header)={just=right}
style={background=cyan};
Define age/ ‘Emp Age’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=orange};
Define income/ ‘Emp Earnings’ format=comma12. spacing=2
style(column)={just=center} style(header)={just=right}
style={background=bibg};
Title ‘Emp Demographic Info ‘;
Title2 ‘Stansys Software Solutions’;
Footnote ‘This is a system generated mail please dont respond to this ‘;
Run;
Usage options in define statement
DISPLAY – Display data, default for character variables.
ORDER – Sort the rows and prints on each group wise.
GROUP – Consolidate observations into groups and removes if entire observation is duplicates.
ANALYSIS – Calculate a statistics, default for numeric variables.
COMPUTED – Computed by PROC REPORT
ACROSS – Class variables in the column dimension
PCTSUM – Finds individual contribution from overall observations.
DESCENDING – Reverses the order in which PROC REPORT displays rows or values of a
GROUP, ORDER, or ACROSS variable.
Proc report data= demo nowd ;
Column emp_id emp_name sex age income;
Define emp_id / ‘Emp ID’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=magenta foreground=blue font_weight=bold font_face=calibri font_size=5}
display;
Define emp_name/ ‘Emp Name’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=liolbr}
display;
Define sex/ ‘Gender’ width=6 spacing=2
style(column)={just=center} style(header)={just=right}
style={background=cyan}
group;
Define age/ ‘Emp Age’ spacing=2
style(column)={just=center} style(header)={just=right}
style={background=orange}
descending order;
Define income/ ‘Emp Earnings’ format=comma12. spacing=2
style(column)={just=center} style(header)={just=right}
style={background=bibg}
analysis;
Title ‘Emp Demographic Info ‘;
Title2 ‘Stansys Software Solutions’;
Footnote ‘This is a system generated mail please dont respond to this ‘;
Run;