Document Type

Article

Publication Date

4-14-2002

Abstract

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.

Comments

Orlando, Florida - April 14-17, 2002. Conference Chair, Cyndie Gareleck.

Share

COinS