Reference no: EM133147756 , Length: word count:800

ITECH3101 Business Analytics and Decision Support - Federation University

Exercise - Manipulating your data and creating a report

Project 1: Importing data from Excel file

The purpose of this project is to import your own data from Excel workbooks for creating SAS data set.

1. Download data Grades.xls from Week 2 in Moodle and save it under the folder SASUniversityEdition/myfolders.

2. Open up Tasks tab in the navigation pane in SAS Studio. The following screen will appear.
3. Click small triangle on the left of Utilities

Import Data task is used to import data from many of common data formats such as Excel, CSV and other files.

4. Double-click Import Data task, you can see that two ways to import data are displayed on work area:

(1) Click on the Select File button,

(2) Click on Server Files and Folders tab in navigation pane on the left of screen, find the file, and drag it to the drag and drop area.

5. Click on Select File to open a window where you can see that Grades.xls is under the My Folders, and then select Grades.xls and click on Open.

6. Create your own data set. You may create your SAS data set by importing original data set(Grades.xls) and name your data set. Click Change button.

After clicking Change button, it will show a list of SAS libraries. Now name your data set as myGrades. Your data set myGrades will be saved in WORK library that is a temporary SAS data set.

After click Save button, data set has been named as myGrades.

7. Click Run icon, and data set has been imported to work area.

8. Look at your data set. Select My Libraries tab on the navigation pane and open up WORK library.

9. Double click on myGrades, and you will see the grade data set

10. Create a data report. Click on Task tab of navigation pane, select Data and then select List Data. Double click on List data and select myGrades data set in Work library. Finally click on Run icon.

Project 2: Creating a data listing

In this project, you will learn how to produce a data listing from a given data set.

1. Open SAS Studio as following. On the left of screen, you can see the navigation pane and the work area is on the right of screen.

2. Using List Data task to create a simple listing. Click Tasks and Utilities and then click small triangle on the left side of Tasks to expand the Tasks tab.

3. Double-click on List Data to open a window. In this window, you would find a data set called Fish stored in SASHELP library.

4. Click on the icon at the top-right part of above screen to select data set Fish. Then click Ok button.

5. Select variables in data set Fish and include the variables in your listing. Click on
plus sign(+) to select variables.

6. Hold the Ctrl key down and select variables Species, Weight, Height, and Width.
Then click Ok.

7. Using OPTIONS tab to customize the listing. For example, in this example, you may want to just display the first seven rows in data set Fish. Click on OPTIONS tab to customize the listing.

8. Click on Run icon to create the following listing.

Project 3: Creating reports

In this project, you will learn how to produce a report such as PDF file or RTF (rich text format) file. Basically you can complete this task by using two methods: using built-in Tasks provided by SAS Studio and writing a SAS program. In this project, you would use built-in tasks to create a report. You will implement this project based on the results of the Project 2.

1. Click on More Application Options
2. Click on Preferences, then Results
3. Download results as a PDF file

Project 4. Answering questions (Please do this at your home by using your own computer)

1. Download data set employee.xls from Week2 in Moodle and import the data set to SAS Studio and create a report.
2. A major characteristic of a DSS and many BI tools (notably those of business analytics) is the inclusion of at least one model. How does the text describe a model?

Project 5. Creating a Professional Report

Summarize the above experiments procedure, results, answering for questions and screenshots (project 1, 2, 3, 4) into one report. Your report is the assignment that is required to be submitted for evaluation on week 9. Create a report by following the steps.

You can add a chapter called Chapter 2 in your previous report.

1. Open your last week's report and find the end of last week's report.

2. Copy this week's related experimental results, your findings and Screenshots, and paste them at the end of last week's report.

3. Delete original Table of Content you created.

4. Select all content , align all text to both left and right margin

5. Use shortcut key approach, generate Chapter 2: Manipulating your data and creating a report

6. Then use shortcut key approach to generate proper sub-chapters for this week's lab work.

7. Insert Table of Contents to your report.

Attachment:- Manipulating your data and creating a report.rar