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

area file in microsoft excel
SMART_READER_LITE
LIVE PREVIEW

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: ResDACs knowledgebase article on opening the Hospital Service Area File:


slide-1
SLIDE 1

Opening the Hospital Service Area File in Microsoft Excel

Erin Mann, ResDAC Technical Advisor

slide-2
SLIDE 2

Opening the HSAF – Background

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

http://www.resdac.org/resconnect

2

slide-3
SLIDE 3

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

slide-4
SLIDE 4

Contents of HSAF Disc

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

4

slide-5
SLIDE 5

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