Fellow SAS users,

I'm looking for suggestions on how to best deal with some quarterly data we use. The problem is this: Every quarter we have survey data come from one of our agencies. We do quarterly analyses but becasue of the way the data trickles in from the collecting agency we may get data for a year's worth of surveys at one time. We then break these into quarters to produce quarterly reports. Then in a few more months we may get more data which includes additional data for the quarters we have already analyzed. So we now have to add this data to the other quarter's data and rerun the analyses to produce new reports. Essentially we may have to add data and rerun analyses for 3 or 4 previous quarters depending on how much new information we get.

Right now I am adding the new data to the old data manually by quarter. For example, I seperate the new file into quarters, combine the data with the relevant old quarterly data and rerun the analyses. I would like to automate this process but I'm not sure if it's best to automate it to break into seperate datafiles then have the analyses run indivdually by quarter or start adding all of the data to one master file and then break the file apart during the analyses. Any suggestions from people who deal with data that come in like this?

Thanks in advance, Bryan

_________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement