adhoc reports

[keen_sas]

Hi

What do you mean by Pooled datasets and Adhoc reports?
How they are related to clinical trials and how they are created in clinical reports?

[Doc_Duke]

Ad hoc means just what the dictionary defines it to be
http://en.wikipedia.org/wiki/Ad_hoc .
Specific, one time, not generalizable.

Pooled datasets are created when the data from multiple related trials are "joined" into one larger dataset for analysis. Because the contributing trials often have different data specifications, pooling involves a lot of data manipulation to get common variable definitions.

[keen_sas]

Thank you very much Doc.I got cleared one doubt regarding pooled datasets.

I got the meaning of adhoc ,but how this is related to sas reporting in clinical trials.
Thanks .

[Cynthia_sas]

Hi:
It means that somebody needs a one-time report. It could be anything:

How many patients does doctor XYZ have?
If doctor XYZ dropped out of the trial, what's the age distribution of the patients who are left?
Who are the patients that had batch 12345 of the drug?
If this hurricane hits Florida, how many doctors and patients are affected?

These are not questions that you can program in advance, but a general knowledge of SAS procedures will help you satisfy these kinds of requests. I'm sure there are many other examples -- the thing is that these requests are not really predictable -- it could be anything -- that's why they're called "ad-hoc".

cynthia