Creating Listings

Patient listings are usually simple clinical trial patient data displays by data type or domain such as demographics and adverse events. For any given trial report, you will likely have listings of the “raw” data, sometimes called case report form tabulations (CRTs), and you will have listings of the analysis data sets used for analysis. You may be asked to help produce another special type of listing, called a “patient profile.” Patient profiles are data listings that are separated not by data domain but by patient. Patient profiles are often used by clinical staff to help them write patient narratives for patients who had serious adverse events. We will not discuss how to create patient profile listings here, as their requirements vary widely from trial to trial.

PROC REPORT, PROC PRINT, and DATA _NULL_ programming are the native SAS methods of producing clinical trial listings. Because the power of PROC REPORT is so much greater than that of its predecessor, PROC PRINT, we focus here on the capabilities of PROC REPORT to create clinical trial listings. If we use the data from Table 5.1 presented at the beginning of this chapter, we can create a simple demographics listing that matches the following specification.