Thanks Sam, As I understand, you propose for each customer to create all records in between START and END dates... Imagine just 100,000 customers having debt with average age of one year. Creating a record for each day for each customer would create 36.5 million records It is not that large of a database but it's much more rows without any new information at all Now imagine that debt history contains 1.5 million customers. Now we're talking about dealing with half of billion rows instead of just 1.5 million. Microsoft has a very elegant solution for this using Measures and a Disconnected Time Dimension in their Tabular SQL Server Technology It would be so useful to have a similar feature in SAS VA I am sure that lots of Data Analysts will find it useful in many fields such as Debts, Inventory, etc. Whom can I talk to in SAS R&D to explain the need and the solution in detail? Thanks, Michael
... View more