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 opening 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