The Policy and Services Research Data Center (PSRDC) in the Department of Mental Health Law & Policy at The Louis de la Parte Florida Mental Health Institute performs research with a variety of secondary mental health datasets. The data format is often manipulated to accommodate our research objectives. One example of this manipulation is “span coding” using SAS . This code is specifically designed to transform overlapping inpatient hospital stays into one unique record by means of the admission and discharge dates. The techniques in this paper apply to health care agencies and the pharmaceutical industry but may easily be applied to other disciplines. Obtaining a unique record for inpatient hospital stays using multiple admission and discharge dates can be easily accomplished by using IF..THEN..ELSE..DO statements with retain statements. It is a simple and swift method to manipulate secondary data to a desirable format for answering research questions.
Scholar Commons Citation
Mehra, Shabnam; Spittle, Robyn; Larsen, Rebecca; Haynes, Diane; and Dailey, Kathleen, "SPAN SPAN AWAY! Creating one unique record for overlapping admissions and discharges from multiple inpatient hospital stays" (2002). Mental Health Law & Policy Faculty Publications. 510.