Ray Pass, Mr. PROC REPORT, has written a number of pieces on using PROC REPORT. I cannot say if you have an idea different from his, but certainly there have been some treatments of some of these issues. Look for Ray's papers, and you might be able to decide if you have a new notion.

Paul A. Thompson, Ph.D. Division of Biostatistics, Washington University School of Medicine 660 S. Euclid, St. Louis, MO 63110-1093 314-747-3793 paul@wubios.wustl.edu

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jack Hamilton Sent: Tuesday, March 18, 2008 11:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Programming with PROC REPORT: would this be an interesting paper?

I don't recall seeing a paper on this, but I don't see everything.

If you need to create a report and also run some SAS code based on the values in the report (dynamically created code), you have at least three options:

- Create a reporting data set containing the data you need. Run that data set through a reporting procedure, and also through a step step to create your dynamic code.

- Create your report using PROC REPORT, and also create an output data set. Run that data set through a data step to create your code.

- Create your report using PROC REPORT, and also use COMPUTE blocks to create your dynamic code (probably using CALL EXECUTE, but there may be other ways).

Has anyone done a paper on that last possibility? Would anyone be interested in seeing such a paper? It's time to submit proposals to regional user groups.

-- Jack Hamilton Sacramento, California jfh@alumni.stanford.org