Description
Problem 1: Fill the blanks in the following SAS code, according to (a)and
(b).
1.1 Data:
Table-1
1.2 SAS code to complete:
Name Score1 Score2 Score3 Score4 Score5 Final
Gamma1 11.25 9.75 10 10 10 90
Delta1 9.5 7.5 8 10 10 95
Epsilon1 11.5 10 9.75 3.5 10 100
Theta1 12.5 10 9.5 9 10 100
options ;
data mydata;
input ;
datalines;
Gamma1 11.25 9.75 10 10 10 90
Delta1 9.5 7.5 8 10 10 95
Epsilon1 11.5 10 9.75 3.5 10 100
Theta1 12.5 10 9.5 9 10 100
;
run;
proc print data=mydata;
;
run;
a) Complete the above code by filling blanks, according to the followings:
1. options : suppress date in your sas output; (hint: google
“Customizing Your SAS Session : OPTIONS Statement” )
2. options: linesize = 78;
3. Print the data for Name, Score3, and Final.
b) Rewrite the program so all the data may be written on only two lines
instead of four lines. Report your output. (Hint: Recall the use of @@ in
the input statement before the semicolon.)
Problem 2: Read and print the following data set. And submit your output
and SAS code.
2.1 Data:
Name from to pounds_million
Benjamin Mendy Monaco Man City 52.0
Alvaro Morata Real Madrid Chelsea 58.0
Romelu Lukaku Everton Man United 75.0
Onsmane Dembele Dortmund Barcelona 97.0
Philippe Coutinho Liverpool Barcelona 105.0
Neymar Barcelona PSG 199.8
For those who are not soccer fans, this is the top most expensive soccer
players in the past year. The first variable Name is soccer players’ names.
The second and third variables from and to correspond respectively to a old
soccer club a player transfer from and a new club to. The last variable is
market value of a player in million pounds.
