title: SAS Data Mart files structure suggestions
body: <p>I've been working on a SAS ETL project wherein we first extract data for the last month from teradata warehouse in the beginning of every month and then take it further for processing.</p>
  
  <p>This is done via extraction scripts for each table and then the data is stored into a monthly folder structure (yyyymm). After working this way for several months, we've now begun getting requests to product daily, weekly, etc extracts.
  The current data storage folder structure is :</p>
  
  <p>Library/Data/YYYYMM folder in one library.</p>
  
  <p>I have to change the structure(with minimal impact to the current structure)  to accommodate different timeframe requests like Daily, weekly, Fortnightly, Quarterly, etc.</p>
  
  <p>I thought of two options : In the current structure (monthly folders), add in </p>
  
  <ul>
  <li>Daily, Weekly and Monthly Folders</li>
  <li>Library / YYYYMM / Monthly</li>
  <li>Library / YYYYMM / Daily</li>
  <li>Library / YYYYMM / Weekly</li>
  </ul>
  
  <p>folders.</p>
  
  <p>Option 2:
  Under the Data Library Create folders like </p>
  
  <ul>
  <li>Monthly</li>
  <li>Daily</li>
  <li>Weekly </li>
  <li>fortnightly</li>
  <li>Quarterly </li>
  </ul>
  
  <p>Under each of these exists individual folders with the current date/month/quarter.</p>
  
  <p>Can anyone suggest of any other more practical design approaches?</p>