title: Getting average price across stores and across months
body: <p>I am trying to use the proc tabulate procedure to arrive at the average price of some configurable items, across stores and across months. Below is the sample data set, which I need to process</p>
  
  <pre><code>Configuration|Store_Postcode|Retail Price|month
  163|SE1 2BN|455|1
  320|SW12 9HD|545|1
  23|E2 0RY|515|1
  </code></pre>
  
  <p>The below code is displaying the month wise average price for each configuration. </p>
  
  <pre><code>proc tabulate data=cs2.pos_data_raw;
      class configuration store_postcode month;
      var retail_price;
      table configuration,month*MEAN*retail_price;
  run;
  </code></pre>
  
  <p>But can I get this grouped one more level - at the Store Post code level? I modified the code to read as shown below, but executing this is crashing the system!</p>
  
  <pre><code>proc tabulate data=cs2.pos_data_raw;
      class configuration store_postcode month;
      var retail_price;
      table configuration,store_postcode*month*MEAN*retail_price;
  run;
  </code></pre>
  
  <p>Please advice if my approach is incorrect, or what am I doing wrong in proc tabulate so much so that it crashes the system.</p>