Write a SAS DATA step to create a SAS dataset

Assignment Help Applied Statistics
Reference no: EM132235152

Statistical Software and Data Analysis Assignment -

1. A consumer magazine wants to create an index of cars based on the data in the file cars.dat. This index is a function of the car size, gas mileage (mileage), and reliability (reliable). The variable size has values SMALL, COMPACT, and MID-SIZED. The cars.dat data file description is as follows.

Variable

Description

Starting Column

Length

Type

SIZE

Car Size

1

9

Char

MANUFACT

Manufacturer

11

9

Char

MODEL

Model

22

9

Char

MILEAGE

Gas Mileage

38

2

Numeric

RELIABLE

Reliability

50

1

Numeric

Write a SAS DATA step to create a SAS dataset called car_inx that contains all the variables described in the cars.dat file plus the index variable. Be sure to set index to a missing value if either a mileage or reliability value is missing. The rules are as follows:

For SMALL cars:

Mileage

Reliability

Index

0 TO 20

1 TO 3

1

0 TO 20

4 TO 5

2

21 TO 50

1 TO 3

3

21 TO 50

4 TO 5

4

For COMPACT cars:

Mileage

Reliability

Index

0  TO 15

1 TO 3

1

0 TO 15

4 TO 5

2

16 TO 50

1 TO 3

3

16 TO 50

4 TO 5

4

For MID-SIZED cars:

Mileage

Reliability

Index

0 TO 12

1 TO 3

1

0 TO 12

4 TO 5

2

13 TO 50

1 TO 3

3

13 TO 50

4 TO 5

4

2. An Excel file named 'students' of the scores from the last semester for a statistics course is given. The following is a guideline for the overall final grade and the final exam score is out of 150 points, which means it should be recalculated to out of 100 points first. For example, if a student got 120 points on final exam, the actual score should be (120/150)*100=80 points.

Exam #1 (out of 100 points)

20%

Exam #2 (out of 100 points)

20%

Final Exam (out of 150 points)

30%

Quiz #1- Quiz #5 (out of 10, respectively)

15%

HW #1 - HW #2 (out of 50, respectively)

15%

Total

100%

Note that the final grade is assigned as follows: A for 90-100%; B for 80-89%; C for 70-79%; D for 60-69%; F for 59% or under.

(1) Report the average of homework and quiz scores (unit: percent) for each student.

(2) Report the total exam scores (= exam_1+exam_2+Final) for each student.

(3) Calculate the overall final score for each student.

(4) Create a new data set called 'grade_A' and print out the overall final score for A-Grade students only.

(5) Print the student identification number, the overall final score, and the final grade only.

3. Write a SAS program to give PDF (probability density function) and CDF (cumulative distribution function) of a binomial distribution with n = 10 and p = 0.1.

4. Write a SAS program to create a SAS dataset BIG which has 100 observations of X=INT(RANUNI(0)*100 +1). Print X values only from the dataset BIG.

Attachment:- Assignment Files.rar

Reference no: EM132235152

The ldl cholesterol levels in a certain population

The LDL cholesterol levels in a certain population has the distribution N(5.9, 0.8). 1.      What is the cholesterol level of the 'healthiest' (i.e. lowest!) 20%?

The learning of 6th graders on a math lesson

Consider Mary's study of whether the learning of 6th graders on a math lesson is affected by background noise level. Describe the pros and cons of Mary using a repeated me

What is the outcome of the multivariate tests

Examine the skewness and kurtosis values for each dependent variable, examining the histograms and examine the Shapiro-Wilks' results and What is the outcome of the multivaria

Basic business statistics

1. In the past, of all the students enrolled in "Basic Business Statistics" 10% earned A's 30% earned B's, 25% earned C's, 25% earned D's and the rest either failed or wit

Find an article in the newspaper illustrating frequencies

1. Find an article in the newspaper illustrating frequencies.  Include a short summary of the article. Indicate the name of the newspaper, date, and name of the article. 2. Fi

Create a bar graph with gender

Determine the statistics for each gender as follows: Frequency, Counts, Mean, standard deviation, minimum, and Maximum. Graphing and Descriptive Stats in SPSS: Create a bar gr

Develop a process map about the prescription filling process

Develop a process map about the prescription filling process for HMO's pharmacy, in which you specify the key problems that the HMO's pharmacy might be experiencing. Next, use

What is the total sample size?

What is the total sample size? What is the mean income and mean number of hours worked? What is the correlation coefficient between the outcome and predictor variables? Is it

Reviews

len2235152

2/15/2019 2:53:57 AM

Note: You should turn in both SAS program and SAS output for the whole credit. Dataset that you may need is in the Canvas. When you use the provided dataset, do not change anything of the dataset file. Use the file as is. Note: May use IF-THEN/ELSE statement or SELECT/END statement and logical AND (&), OR (|) operators.

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd