{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab14 - Statistics 440 Lab Exercises 14 Before you begin...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Statistics 440: Lab Exercises 14 1 Before you begin: Login to Illinois Compass (compass.uiuc.edu) and download the SAS and Excel data files from the Data\Lab 14 folder. Save them in ‘ D:\netid ’. Create the libref ‘ st ’ which points to ‘ D:\netid (or folder of your choice). When you reference the SAS data sets, use the library ‘ st ’. Part I: Reading External Data Files with the Import Wizard Use the Import Wizard to import the file inventory.xls into SAS. This is an Excel file that contains information on products in stock. Name the resulting data set work.inventory . 1. Select File bright Import Data… . 2. From the list box, select Microsoft Excel 97/2000/2002/2003 Workbook . 3. Select Next > . The Connect to MS Excel window opens.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Statistics 440: Lab Exercises 14 2 Select Browse… to specify a workbook file to import from the Open window. After you select the pathname, select Open to complete your selections and return to the Connect to MS Excel window. 4. Select OK . The Import Wizard – Select Table window opens:
Image of page 2
Statistics 440: Lab Exercises 14 3 5. Select Sheet_1 , the name of the worksheet (or named range) to be imported. pencil You can select Options… to change default import settings through the SAS Import: Spreadsheet Options window. 6. Select Next > to open the Import Wizard – Select library and member window, where you specify the storage location for the imported file. 7. In the Library box on the left, leave the library as WORK . In the Member box on the right, type inventory . You can also select the down arrow in the Library box and select a different library. You can select the down arrow in the Member box to select an existing data set. If you select an existing data set, you will be asked later to verify that you want to replace it.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Statistics 440: Lab Exercises 14 4 8. Select Next > to move to the next window or Finish to create the SAS data set from the Excel spreadsheet. If you select Finish and you select the name of an existing SAS data set for the name of your new SAS data set (in the Import Wizard – Select library and member window), you are prompted to determine whether or not you want to replace the existing data set. Select OK or Cancel . If you select Next > , you are taken to the Import Wizard – Create SAS Statements window. 9. Select Browse… to specify a location from the Save As window. After you select the pathname, select Save to complete your selections and return to the Import Wizard – Create SAS Statements window.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern