Itech 3 101-Lab Projects-Week-1 PDF

Preview

Summary

this Itech 3 101-Lab Projects-Week-1 Itech 3 101-Lab Projects-Week-1...

Description

ITECH3101 –Business Analytics and Decision Support week 1 Lab Exercise – Introduction to SAS ID:

Name: __________

Project 1: Installation of SAS ((Copy and write down your findings in a word documents) In this course, you would use software SAS University Edition to practice SAS programming and to do different kinds of experiments. SAS University Edition is available for free and it includes all features that enable you to learn Base SAS. As SAS University Edition works as a virtual machine, it requires you to run it in a virtual environment. You need to install a virtualization software on your PC before you run the SAS software. 1. Go to website: https://www.sas.com/en_us/software/university-edition/download-software.html

1

2. Click on the "Get the Software" button at the top right and select your operating system.

3. Make sure that your Windows computer meets the minimum system requirements

There are four steps to install the software:

2

4. Step 1: Set Up. Download VirtualBox and create the "myfolders" Folder on your computer

3

Click "Download VirtualBox for Windows" to download VirtualBox and select Windows hosts in VirtualBox 6.0.4 platform packages. And then save VirtualBox-6.0.4128413-Win.exe in your computer.

4

After downloading VirtualBox, click VirtualBox-6.0.4-128413-Win.exe to install the virtualization software by following the instructions.

When you are waiting for the virtualization software to install, create a folder for your SAS file.

5

(1) Create a folder named SASUniversityEdition (no spaces) on your local computer. (2) Then create a subfolder within the SASUniversityEdition folder called myfolders (no spaces). This is where you'll save all your SAS University Edition files.

5. Step 2: Download SAS university Edition After downloading VirtualBox and creating your folder, you are ready to download the SAS University Edition virtual application and store it in your download directory.

6

Click "Get SAS University Edition".

Then you are required to sign in. For a new user, click Create profile button. After clicking "Create profile," you will receive a verification email with instructions for setting your password and activating your profile.

7

A verification email has been sent to the address you provided. To verify your email address and activate your profile, click the link in the email (subject: Please activate your SAS Profile). You will then be prompted to set a password. Once creating your password, your profile is active. You can now sign in using your new SAS Profile credentials to download SAS University Edition.

The name of your download file would be similar to: ‘unvbasicvapp_9411015_ova_en_sp0_1.ova’.

6. Step 3. Configure VirtualBox and set up the Shared Folder This step will import SAS University Edition into VirtualBox. (1) Open VirtualBox

8

Then select File > Import Appliance

9

(2) In the Import Virtual Appliance window, click the folder icon to the right of the field

(3) In this case, you will find the folder SASUniversityEdition\myfolders where you select SAS University Edition.ova file, and click Open (4) Click Next and then click Import in the Appliance Settings windows. Now SAS University Edition has been imported to VirtualBox

10

In the previous step, you create a folder called SASUniversityEdition\myfolders on your computer. Now you need to set up VirtualBox so it can access to this folder. Please follow the following steps to share you myfolders with VirtualBox,

11

12

7. Step 4: Power On The Virtual Machine Clicking the Powered Off in the SAS University Edition on the left pane.

13

This will start the virtual machine. The following screen should appear.

14

15

After that, you can run the virtual machine. You will get a prompt to connect your SAS University Edition software. Please note that you should not close above window when you use SAS Studio.

8. Step 5: Starting SAS Studio (1) In a web browser on your local computer, enter http://localhost:10080. The following screen should appear.

16

(2) Starting SAS Studio From the SAS University Edition: Information Center, click Start SAS Studio and the following screen should appear. Now you can enter your code in SAS studio and run your program.

17

9. Running your first SAS program In SAS Studio, enter the following codes that create a SAS data set called distances and convert miles to kilometres.

18

19

20

Project 2: Knowing interfaces in SAS Studio (Copy and write down your findings in a word documents) 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. Exploring the built-in data set SAS stores SAS data sets in SAS libraries. In libraries in SAS Studio, SAS Studio provides a number of data sets that you can play with. However, you can also create your own SAS data sets from different data sources and store them in a library of your own. You will learn these skills from the following projects. Click on Libraries and then click on My Libraries tab, you can see something like this:

21

Sashelp library is place where SAS has stored all of the demonstration data sets. Click on the small triangle to the left of Sashelp to see a list of SAS data sets.

22

Double-clicking on a data set can display a list of variables. Double-Click on the BASEBALL data set and you can see the following:

23

3. Exploring work area On the work area, you can see a number of rows (called observations) and columns (called variables ) in the data set.

24

4. Sorting data When you place the cursor on a column heading, a small hand icon appears. Leftclick the column heading nAtBat and you will see that values are sorted from low to high.

25

5. Switching between column names and column labels Clicking on the View tab, you can make changes between variable names and variable labels.

26

6. Adding a filter Filters allow you to subset rows of the table by specifying criteria, such as displaying only rows where the number of home runs was 30 or more. Place the cursor to column name nHome, and then right-click nHome. Click on Add Filter.

27

In the drop-down menu, select greater than logical operator and input 30.

After clicking on Filter button, you can see that all rows in Baseball data set where players hit more than 30 home runs are displayed.

28

Project 3. Answering questions (Please do this at your home by using your own computer) 1. Install SAS University Edition in your computer. 2. Exploring one or two the built-in data set provided by SAS libraries. 3. Managers usually make decisions by following a four-step process. What are the steps?

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

29

1. Open Word document, copy your experiments procedure, results, answering questions and screenshots (project 1, 2, 3) into a word document. 2. Select all content , align all text to both left and right margin. 3. On the Home tab, in the Styles group, right-click Heading 1 in the Quick Style gallery. Click Modify style , click Format , click Font , then select Font color to Black, select Font style to Bold, select Font size to 18 , then click Ok 4. Create a shortcut key for Chapter. Click Format , click Shortcut key , in text box Press new shortcut key, type Ctrl + A, click Close, click OK 5. Select a style for sub-Chapter. On the Home tab, in the Styles group, rightclick Heading 2 in the Quick Style gallery. Click Modify style , click Format , click Font , then select Font color to Black, select Font style to Italic, select Font size to 14 , then click Ok 6. Create a shortcut key for sub-Chapter. click Format , click Shortcut key , in text box Press new shortcut key, type Ctrl + B, click Close, click OK 7. Insert a page number to your document 8. You may call the summary of Week 1 lab work as Chapter 1 and the summary of Week 2 lab work as Chapter 2, ..., etc. 9. Format your Chapter 1. At the beginning in your report, Press shortcut key Ctrl + A , then type Chapter 1: Introduction to SAS. 10. Format your sub-Chapter. At proper position within Chapter 1, Press shortcut key Ctrl + B , then type 1.1 Project 1: Installation of SAS. 11. Repeat step 10 and format sub-Chapter for Project 2 and Project 3 12. Insert a table of contents for your report. At the beginning of your report, Click where you want to insert the table of contents 13. On the References tab, in the Table of Contents group, click insert Table of Contents, then select Formal , click OK 14. Insert a cover page. On the Insert tab, in the cover page group, select Conservative, then add your name and ID number.

30...