SAS Programming with Medicare Administrative Data

Matthew Gillingham

Description

SAS Programming with Medicare Administrative Data is the most comprehensive resource available for using Medicare data with SAS. This book teaches you how to access Medicare data and, more importantly, how to apply this data to your research.
Knowing how to use Medicare data to answer common research and business questions is a critical skill for many SAS users. Due to its complexity, Medicare data requires specific programming knowledge in order to be applied accurately. Programmers need to understand the Medicare program in order to interpret and utilize its data.
With this book, you'll learn the entire process of programming with Medicare data—from obtaining access to data; to measuring cost, utilization, and quality; to overcoming common challenges. Each chapter includes exercises that challenge you to apply concepts to real-world programming tasks.
SAS Programming with Medicare Administrative Data offers beginners a programming project template to follow from beginning to end. It also includes more complex questions and discussions that are appropriate for advanced users. Matthew Gillingham has created a book that is both a foundation for programmers new to Medicare data and a comprehensive reference for experienced programmers.
This book is part of the SAS Press program.

Sujets

• COMPUTERS
• Enterprise software
• General officer
• Mathematics
• General

Informations

• Publié par: SAS Institute
• Date de parution: 01 mai 2014
• Nombre de lectures: 0
• EAN13: 9781629591537
• Langue: English
• Poids de l'ouvrage: 3 Mo

Extrait

SAS Programming
with Medicare Administrative Data
Matthew Gillingham

support.sas.com/bookstore
The correct bibliographic citation for this manual is as follows: Gillingham, Matthew. 2014. SAS Programming with Medicare Administrative Data . Cary, NC: SAS Institute Inc.
SAS Programming with Medicare Administrative Data
Copyright 2014, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-62959-153-7
All rights reserved. Produced in the United States of America.
For a hard-copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc.
For a web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication.
The scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your support of others rights is appreciated.
U.S. Government License Rights; Restricted Rights: The Software and its documentation is commercial computer software developed at private expense and is provided with RESTRICTED RIGHTS to the United States Government. Use, duplication or disclosure of the Software by the United States Government is subject to the license terms of this Agreement pursuant to, as applicable, FAR 12.212, DFAR 227.7202-1(a), DFAR 227.7202-3(a) and DFAR 227.7202-4 and, to the extent required under U.S. federal law, the minimum restricted rights as set out in FAR 52.227-19 (DEC 2007). If FAR 52.227-19 is applicable, this provision serves as notice under clause (c) thereof and no other notice is required to be affixed to the Software or documentation. The Government's rights in Software and documentation shall be only those set forth in this Agreement.
SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513-2414.
April 2014
SAS provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential. For more information about our offerings, visit support.sas.com/bookstore or call 1-800-727-3228.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. indicates USA registration.
Other brand and product names are trademarks of their respective companies.
Contents
About This Book
About The Author
Acknowledgments
Chapter 1: Introduction
Introduction and Purpose of This Book
Framework of This Book
Our Programming Project
Chapter Outline
How to Use This Book
Disclaimer
Chapter Summary
Chapter 2: An Introduction to the Medicare Program
Introduction and Goals of the Chapter
An Introduction to the Medicare Program
What is Medicare?
Medicare Enrollment and Eligibility
What Is Covered by Medicare?
What Is Not Covered by Medicare?
The Mechanics of Medicare
Chapter Summary
Chapter 3: An Introduction to Medicare Data
Introduction and Goals of This Chapter
A Note on the Source and Structure of Our Claims Data
Part B Carrier Claims Data
Durable Medical Equipment (DME) Data
Outpatient Claims Data
Inpatient Claims Data
Skilled Nursing Facility (SNF) Claims Data
Home Health Claims Data
Hospice Claims Data
Commonly Retained Elements in Administrative Claims Data
Master Beneficiary Summary File
Provider Data
Example: Identification of Emergency Department (ED) Utilization
Example: Identification of Surgical Services
Chapter Summary
Chapter 4: Planning the Research Programming Project
Introduction and Goals of This Chapter
Our Project s Plan: The SDLC
Our Project s High-Level Requirements
Our Project s Quality Assurance Plan
Our Project s Flowchart
Our Project s Data Storage and LIBNAMES
Our Research Programming Technical Specifications
Chapter Summary
Chapter 5: Request, Receive, Load, and Transform Data
Introduction
Requesting Medicare Administrative Claims and Enrollment Data
Sources of Medicare Claims and Enrollment Data
Data Available from CMS
Our Project s Data Requirements and Request Specifications
Contacting ResDAC and Completing Paperwork
Receiving, Decrypting, and Loading Medicare Administrative Claims and Enrollment Data
Receiving Our Medicare Administrative Data
Decrypting Our Medicare Administrative Data
Loading Our Medicare Administrative Data into SAS Data Sets
Algorithms: Transforming Base Claim and Line Level Data Sets into Single Claim-Level Files
Transforming Base Claim and Line-Level Carrier Data into a Claim-Level File
Chapter Summary
Chapter 6: Working with Enrollment Data
Introduction and Goals
Review and Approach
Basics of Medicare Enrollment Data
Our Programming Plan
Algorithms: Identifying Continuously Enrolled FFS Beneficiaries
Why Define Continuously Enrolled FFS Beneficiaries?
How to Specify the Programming for Continuous Enrollment in Medicare FFS
Medicare Part A and Part B Enrollment Variables
HMO Coverage Variable
Date of Death Variable
How to Program in SAS to Define Continuous Enrollment in Medicare FFS
Algorithms: Create or Retain Data Elements for Displaying Results by Certain Characteristics
Coverage Characteristics, Month of Death, Sex, and Race
Age Groups
Geographic Characteristics
Algorithms: Create Final Enrollment Data for Remainder of Programming
Chapter Summary
Exercises
Chapter 7: Measuring Utilization of Services
Introduction and Goals
Review and Approach
Review: Basics of Medicare Claims Data
Our Programming Plan
Algorithms: Delimit Claims by Continuously Enrolled Beneficiary Population
Algorithms: Measuring Evaluation and Management (E M) Utilization
Algorithms: Measuring Inpatient Hospital Utilization
Algorithms: Measuring Emergency Department Utilization
Algorithms: Measuring Utilization of Ambulance Services
Algorithms: Measuring Outpatient Visit Information
Algorithms: Measuring Utilization of SNF, Home Health Agency, and Hospice Care
Chapter Summary
Exercises
Chapter 8: Measuring Costs to Medicare
Introduction and Goals
Review and Approach
Review: Basics of Medicare Cost
Our Programming Plan
A Note on Payment Standardization and Risk Adjustment
Algorithms: Measuring Evaluation and Management Payments
Algorithms: Measuring Inpatient Hospital Payments
Algorithms: Measuring Total Part A Payments
Chapter Summary
Exercises
Chapter 9: Programming to Identify Chronic Conditions
Introduction and Goals
Review and Approach
Review: Peculiarities of Medicare Data
Our Programming Plan
A Note on the Chronic Conditions Data Warehouse (CCW)
Algorithms: Identifying Beneficiaries with Diabetes or COPD
Algorithms: Evaluation and Management Visits for Beneficiaries with Diabetes or COPD
Algorithms: Diabetic Eye Exams for Beneficiaries with Diabetes
Algorithms: Hospital Readmissions for Beneficiaries with COPD
Chapter Summary
Exercises
Chapter 10: Presenting Output and Project Disposition
Introduction
Synthesis - Review and Approach
Review: Our Accomplishments
Our Programming Plan
Algorithms: Presenting Selected Measurements of Utilization, Cost to Medicare, and Quality Outcomes
Presenting Ambulance Utilization
Presenting Medicare Payments for Evaluation and Management Services by Provider
Presenting Rates of Diabetes and COPD
Algorithms: Presenting Inpatient Length of Stay Information by State
Algorithms: Presenting Mean Medicare Part A Payments per Beneficiary by State and County
Algorithms: Presenting Rates of Diabetic Eye Exams
Production Execution in Batch
Project Disposition
Archiving Materials for Future Use
Data Destruction
Chapter Summary
Exercises
Index
About This Book

Purpose
This book teaches you how to access Medicare data and, more importantly, how to apply this data to your research. Knowing how to use Medicare data to answer common research and business questions is a critical skill for many SAS users. Due to its complexity, Medicare data requires specific programming knowledge in order to be applied accurately. Programmers need to understand the Medicare program to properly interpret and use its data. With this book, you ll learn the entire process of programming with Medicare data-from obtaining access to data; to measuring cost, utilization, and quality; to overcoming common challenges. Each chapter includes exercises that challenge you to apply learned concepts to real-world programming tasks.

Is This Book for You?
This book is a must for anyone interested in programming with Medicare data in SAS. This includes students, professional researchers, and employees in the federal and state governments. SAS Programming with Medicare Administrative Data offers beginners a programming project template to follow from beginning to end. It also includes more complex questions a