I'm currently working on SAS enterprise to create some predicting datasets where the dates overlap but don't want to overwrite the overlapping data for example Header 1 Jan Apr Jul Oct Jan 0 Feb 1 Mar 2 Apr 3 0 May 4 1 Jun 2 Jul 3 0 Aug 4 1 Sept 2 Oct 3 0 Nov 4 1 Dec 2 I want to make a new prediction every quarter with the newest data and compare with the prediction made using the previous data. So the effectivedates will overlap but I don't want the data to be overwrittern each time which happens when using effectivedates. I believe I can do this using do loops but am not completely sure how. Any advice on what code to use would be greatly appreciated!!
... View more