摘要：Objectives: This paper evaluates the usefulness of a set of PROMs data collected prospectively, in a relational database, over several years. The data were collected as part of routine practice, to audit patients undergoing shoulder surgery. Methods: Data, rendered anonymous, which included all upper limb surgical procedures and all outcome questionnaires (including Oxford Shoulder Score, OSS) data, were downloaded, prepared and analysed to produce the shoulder surgery study population. Details of procedures and questionnaires were merged by shoulder and analysed for completeness and accuracy. Pre- and post-operative OSS scores, with repeated observations from individual patients, were analysed using maximum likelihood mixed effects linear regression models. Results: Data preparation and cleaning was intensive. The final dataset contained 2110 questionnaires representing 815 surgical procedures and 755 patients. In relation to procedures, only 538 (66%) had a pre- and post-operative OSS score: 78 (9.5%) a pre-operative OSS only, 199 (24.4%) a post-operative OSS only, and 31 (3.8%) no OSS completed. OSS questionnaires had been completed in varying numbers and at varying times per procedure. There was a considerable amount of 'missing' data that was not missing completely at random. Missing data had a significant influence on OSS scores. Conclusions: In the absence of a research question (eg. exploratory research, descriptive audits, registers), a reason for collecting PROMs data should be stipulated and methods of data collection and storage standardised. Poor data cannot be 'fixed' in statistical analysis; statistical advice should be sought during the planning stages.
