Hi everyone, I am new to SAS and doing some research. For my research, I need to make a 12-month window of my data and output it to a new dataset so that I can use this new dataset to carry on the rest of the processing. I have attached an Excel sheet with four columns: ID, YEAR, MONTH, and RET. The basic algorithm of what I need to achieve is as follows: 1. Take the first window of 12 months from the original dataset (e.g., here, it would be January 1994 to December 1994) 2. output it to a new dataset, say, temp. 3. sort temp as per RET. 4. append temp to an already existing dataset (this dataset is calculated independently and has 12 rows and 6 columns of predefined values) 5. perform the calculations necessary. (here after the calculations, it gives output as a single value.) 6. append that output to the original dataset in the row of Demeber 1994 (basically the last row of every window) 7. check whether the next row ID in the original dataset is same as the previous, if not take availabe values for the window. 8. slide the window by one month in the original dataset. (so, now, it will be from February 1994 to January 1995.) 9. Go to step 2. This is a basic algo of what I want to do. Here the code should also check if the ID is changing or not, so that there is no overlap of different IDs in a window. Any help and guidance is appreciated. Thank you so much !!
... View more