SAS Support Communities

I am currently building a solution in Excel that will allow users to enter information on a template and have SAS import the template for calculations. The template will include start and end dates for a given condition. In this case, the condition refers to the department that employees work within. Since employees change departments, we want to track data based on which department they completed the work for. Currently, I am looking at this in two different ways (see charts below). Table one has the employees enter changes by including new rows of data. Table two has the employees enter changes by including new columns of data. Does anyone have experience with which of these data structures works best for longevity and flexibility? I want the best long term solution. Thanks for your time! Kyle Employee Department Start date End date John Finance 1/1/2015 3/31/2015 John Marketing 3/31/2015 12/31/2015 Mary Operations 1/1/2015 12/31/2015 Vertical Susan Sales 1/1/2015 12/31/2015 Employee Department Start date End date Team Start date End date John Finance 1/1/2015 3/31/2015 Marketing 3/31/2015 12/31/2015 Mary Operations 1/1/2015 12/31/2015 Horizontal Susan Sales 1/1/2015 12/31/2015 ... View more