Thursday, November 10, 2011

somethings intersting about proc report

Here are the few interesting questions about the proc report.Please add and post if you find couple of more interesting questions about proc report...... 

#What is the default usage and statistic for numerical variable
Numerical variable is analysis and default statistics is sum

#How to wrap lines of text when you have long values;
FLOW option in define statement
note:split option is must;
#Why SPLIT option is required
To tell the program that you want to split the comments between words(blanks)
otherwise it will use other characters as slashes in dates as possible line break;

#How to right align and left align column
RIGHT option

#How the change the order of rows according to some variable
ORDER option in DEFINE statement

#How to create a multipanel report
with PANELS option in proc report statement;

#What are the options used in break statement
ol summarize skip supress

# Can you compute new variable in proc report ?
yes COMPUTE statement
don't forget ENDCOMPUTE statement before run statement

#What about new character variable
Use CHARACTER keyword in compute statement

#How to create a line after heading
healine option in proc report

No comments:

Post a Comment