I have a testpack for every macro on my web site that I consider might run
in a production environment. The test packs test out most of the options in
the macros. I compare the output with what I am expecting the macro to do.
HOWEVER, the process of "validation" must be done by the users themselves
according to FDA rules. So all these testpacks have been disabled using a
endsas; statement in the first line. This stops users just assuming they
have been validated. The testpacks need a tester id added and date and need
the endsas; line removed and it is then up to the tester to add or change
that test code until they themselves conclude the macro is functioning
correctly. I could spend an absolute age testing those macros and write vast
amounts of code to test them but that would not make them validated as the
USER has to validate them. Those are the rules. I think my test packs
provide a useful start but it is no more than a start in the process of
validation. But having said that, I don't think it would take very long at
all for a user to put them through this process of validation. Maybe as
little as a week if working on it full time. Maybe two. Only a few of the
114 macros there (or whatever - I've lost count) are large and need
extensive testing. And if a new department or a CRO start-up used that code
then those two weeks validating them would repay itself many times over. But
bottom line is - the USER has to validate them. The rules say so.
"TAXQA" <firstname.lastname@example.org> wrote in message
> Hi Roland,
> Could you describe how do you validate your macros?
> A SAS user.
> "Roland" <email@example.com> wrote in message
> > Is your company a CRO start-up? Are you thinking of putting in place
> > code for standard safety reporting? Some sort of sophisticated system
> > titles and footnotes handling? But this will cost BIG money, you think,
> > will take a long time and maybe more than one attempt to get it right?
> > Well, if you answered "yes" to those questions then I have come to your
> > rescue. I have such a system on my web site plus much more. And it is
> > FREE. Nearly 6 man-months work is there. 110 sas macros plus a number of
> > unix/linux utilities. There is maybe in excess of $50,000 worth of code
> > there and I am giving it away. My friends think I am mad to do this and
> > think they are right. You could become a CRO start-up millionaire and
> > give me a penny (cent) of it. You don't even have to tell me you are
> > it, let alone pay for any of it. I have donated it all to the public
> > so it is now yours as much as mine. So point your technical person at my
> > site and save yourselves a fortune.
> > http://www.datasavantconsulting.com/roland/