Area File in Microsoft Excel Erin Mann, ResDAC Technical Advisor - - PowerPoint PPT Presentation

Opening the Hospital Service Area File in Microsoft Excel

Erin Mann, ResDAC Technical Advisor

Opening the HSAF – Background

• See also: ResDAC’s knowledgebase article on
• pening the Hospital Service Area File:

http://www.resdac.org/resconnect

2

Opening the HSAF – Background

• The Hospital Service Area File is one of the few

CMS Public Use Files that can be opened in Microsoft Excel.

• Many will still choose to use other programs:

˗ Microsoft Access ˗ Microsoft SQL or Oracle ˗ SAS and other statistical software programs

3

Contents of HSAF Disc

• HSAF record layout
• HSAF data file (a .txt file)

4

Overview of the Process

• Load the disc
• Copy the contents of the disc to your computer
• Import the file into Excel using the Text Import

Wizard

5