That will work, but defeats my goal to avoid pre-processing the class dataset. Anyway, thanks for your input - I really appreciate it, ... View more

Adding fakevar inside of proc report is fine, but ordvar is added outside of proc report which defeats my goal to avoid pre-processing the class dataset. In some cases you don’t have to prepare your data to produce a report (e.g. proc report can produce a sorted output even if the input dataset is not sorted). Apparently that's not always the case, which my example seems to prove. Anyway, thank you very much for your input – I really appreciate it. ... View more

Thanks for the following up. I’m actually not looking just for any Adverse Event or related papers. The papers you cited address different kinds of reports and don’t seem to be relevant to my issue at all (including examples 1 and 8 of your paper). What I am looking for is a code to produce this simple output (just two variables SEX and NAME) using Proc Report with the sashelp.class dataset as input. The problem is to put values of the same variable NAME coming from different observations of the class dataset on same line of the report e.g. Alice and Alfred. It is indeed similar to what COLUMN= option does, but not quite – the columns would have to have different headers e.g. F and M, respectively. Are you saying you have done this without manipulating and summarizing the data outside of Proc Report? If you can show me how then I can show you how to produce the ICH report using the standard AE dataset as input. ... View more

Yes, the report should look exactly as shown and have sashelp.class as input. Let me explain why I want to generate a report like this. This report is a simplified version of the sample report provided on page 33 of the ICH “Guideline for Industry” (http://www.fda.gov/downloads/regulatoryinformation/guidances/ucm129456.pdf) which lists adverse events of various severity and relatedness to the study drug by body system and visit (along with the summary information). Typically the structure of adverse events datasets is similar to that of sashelp.class. I was thinking of LISTING destination. But are you suggesting that with the COLUMNS= option this can be done in RTF? Can you please clarify (provide code?). Thanks. ... View more