Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Bringing Data into a Project > 2.7 Importing Microsoft Excel Spreads...

2.7 Importing Microsoft Excel Spreadsheets

When you open or import a Microsoft Excel spreadsheet, SAS Enterprise Guide converts it to a SAS data set.

Input data

This example uses a Microsoft Excel spreadsheet named Bookings.xls, which contains six columns: the office that booked the tour, the customer identification number, the tour identification number, the number of travelers, the money deposited, and the date the deposit was made. Notice that the first row contains the column names.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint