Longitudinal Data Techniques纵向数据技术.pptVIP

Longitudinal Data Techniques: Looking Across Observations Ronald Cody, Ed.D., Robert Wood Johnson Medical School A Typical Longitudinal Data Set Common Data Processing Requirements Common Data Processing Requirements Selecting the First (or last) Visit for Each Patient Adding DOB to the Second Through the Last Observation for Each Patient DOB Added to Observations Computing Differences Between Observations (using RETAIN) Computing Differences Between Observations (using RETAIN) Computing Differences Between Observations (using RETAIN) Computing Differences Between the First and Last Visit (using LAG) Computing Differences Between Observations (using the LAG function) Computing Differences Between Observations (using the LAG function) Counting the Number of Observations in Each BY Group Using PROC FREQ to Output a Data Set Containing Counts Creating Summary Data Sets Using PROC MEANS Creating Summary Data Sets Using PROC MEANS (OUTPUT) Selecting All Patients with n Visits (using PROC FREQ) Selecting All Patients with n Visits (OUTPUT) Using PROC SQL and a Macro Variable to Select Observations Selecting All Patients with n Visits (using a Data Step) Looking Ahead Using Multiple SET Statements Looking Ahead Using Multiple SET Statements Looking Ahead Using Multiple SET Statements * * PATNO DATE DOB HR SBP DBP 001 10/21/1997 10/21/1946 48 128 74 001 02/01/1998 44 126 70 001 11/04/1998 52 130 76 001 11/07/1998 54 132 78 003 11/11/1998 09/08/1955 52 140 80 007 04/04/1998 008 03/22/1998 02/08/1980 58 144 72 008 04/21/1998 66 144 74 012 05/06/1998 80 120 80 013 11/11/1998 11/09/1930 100 180 108 013 11/18/1998 90 170 98 123 01/28/1998 01/01/1944 80 180 96 123 05/04/1998 80 178 90 Extract the first or last visit for a subject Copy information from the first visit to subsequent visits Com