How to calculate average within format ranges

[Armand_B]

Hello everyone

My worry is about having a deep understanding of  FORMAT

So i m trying to calculate the average within  each range that is created within the format

Following is the code

proc format;
value SalesRange 0 - <100000 = 'Lower'
                     100000 - <200000 = 'Middle'
                    200000 - high = 'Upper';
run;

data shoerange;
      set sashelp.shoes;
salesreport = put(sales,SalesRange.);
run;

title" sales report";
proc print data = shoerange;
var sales salesreport;
run;

How do i proceed to calculate the average of first range second range and third range

Thanks for your help

Regards

[sbxkoenk]

proc format;
value SalesRange 0 - <100000 = 'Lower'
            100000 - <200000 = 'Middle'
            200000 - high    = 'Upper';
run;

data shoerange;
      set sashelp.shoes;
salesreport = put(sales,SalesRange.);
run;

PROC MEANS data=shoerange;
 CLASS salesreport;
 var sales;
run;
/* end of program */

[PaigeMiller]

proc format;
    value Salesf 0 - <100000 = 'Lower'
                     100000 - <200000 = 'Middle'
                    200000 - high = 'Upper';
run;

proc summary data=sashelp.shoes nway;
     class sales;
     format sales salesf.;
     var sales;
     output out=want mean=sales_mean/noinherit;
run;

I changed the format name since it has to be 8 characters or less. No need to create a new variable with a PUT statement.

Normally, you would not want to slice the data by a variable (in this case SALES) and then do an analysis (compute the mean) of the same variable (SALES). What is the point? The mean in the Middle group has to be higher than the mean in the lower group, and has to be lower than the mean of the upper group. Normally, the slicing variable is different than the analysis variable.

[andreas_lds]

---

@PaigeMiller wrote:

I changed the format name since it has to be 8 characters or less.

From the docs of proc format:

The name must be a valid SAS name. A numeric format name can be up to 32 characters in length. A character format name can be up to 31 characters in length. If you are creating a character format, then use a dollar sign ($) as the first character.

---

[PaigeMiller]

I must be living in the past. Thanks @andreas_lds 

[FK1]

Hi Andreas,
just to give the exact position:
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1upn25lbfo6mkn1wncu4dyh9q91.htm

[s_lassen]

@PaigeMiller  wrote: "I changed the format name since it has to be 8 characters or less. No need to create a new variable with a PUT statement."

However, this works fine on my computer (running SAS 9.4):

proc format;                                
  value thisislongerthaneight 1='Hello'     
   other='nope';                            
run;                                        
data test;                                  
  do i=1 to 5;                              
    output;                                 
    j=44;                                   
    format i thisislongerthaneight.;        
    end;                                    
run;                                        
                                            
proc summary data=test;                     
  class i;                                  
  var j;                                    
  output out=mean mean=;                    
run;

I think that limitation is a bit outdated.