### 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

#### 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

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 