Sharpening Your Advanced SAS Skills

Chapter 5

Answers to Chapter Review Questions

Chapter 1: Accessing Data Using SQL—Answers

1. 1. Creating a nonmissing variable from multiple datasets? Use COALESCE() function.
2. 2. Creating character string macro variables without any blanks? Use !! and TRIM() function.
3. 3. Creating an empty dataset with minimum code and no uninitialized notes? Use PROC SQL; CREATE TABLE SHELL (NAME CHAR, AGE NUM); QUIT;
4. 4. What technique is useful for identifying and adding baseline lab values in clinical trials? Generally, the baseline visit is defined as the last visit before the first dose date. PROC SQL; CREATE TABLE _BRES AS SELECT LBTESTID, SUBJID, RESULT AS BRESSAFE FROM QC_ALAB_RAW2 WHERE RESULT >. AND VISITDTF < FDOSEDTF GROUP BY SUBJID, LBTESTID HAVING ...