Greetings SAS-L, I am considering creating MDDBs to summarize and store about 2 million records of Birth and Death data summarized on year, county, age, race, sex and other demographic variables. I am also considering storing the same data in SAS data sets as the output from Proc Summary at the same levels I would build the data cubes with Proc MDDB. We will be using the datasets to respond to external requests through a browser (SAS/Intrnet & App Dev Studio applications) and for internal users to access for research purposes.

Does anyone have evidence or opinions on the relative merits of creating MDDBs vs. summary SAS data sets?

Thanks in advance for your responses.

Bruce Butts, Ohio Department of Health