SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Creating List Reports
Additional Features


When you create list reports, you can use several other features to enhance your procedure output. For example, you can

  • control where text strings split in labels by using the SPLIT= option.
         proc print data=reps split='*';
            var salesrep type unitsold net commission;
            label salesrep='Sales*Representative';
         run;
    
  • create your own formats, which are particularly useful in formatting character values.
         proc format; 
            value $repfmt 
                  'TFB'='Bynum' 
                  'MDC'='Crowley' 
                  'WKK'='King'; 
         proc print data=vcrsales; 
            var salesrep type unitsold; 
            format salesrep $repfmt.; 
         run;
  • control how values are listed and summed. For example, if your data is sorted or indexed, you can group observations by values of a specified variable, and then request subtotals for these groups.
         proc print data=sales;
            var region salesrep unitsold net;
            by region salesrep;
            id region salesrep;
            sum unitsold net;
            sumby salesrep;
         run; 
    

back||next


Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.

Terms of Use & Legal Information | Privacy Statement