Assignment Detail:- 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 Parts 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 Part 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 Parts and Utilities and then click small triangle on the left side of Parts to expand the Parts 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 onplus 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 Parts 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 Options2- Click on Preferences, then Results3- 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
Most Recent Questions