My quiz
PROC
Which of the following steps is typically used to generate reports and graphs?
newgpa=round(gpa, .01)
A typical value for GPA is 3.26541 Which statement correctly rounds to the hundredth position?
....... then substr(phone,1,3)='920'; run;
Due to growth within the 919 area code, the telephone exchange...
... fullname=trim(firstname) {{' '}} trim(lastname); run;
Suppose you need to create the variable FullName by concatenating the values...
State=scan(address2,2):
The variable Adress2 contains values such as Piscataway, NK. How do you assign the two letter...
Gender=substr(IDCode,4,1);
The variable ID code contains values such as 123FA...
HNL:96701
What is the new value of Code?
MDY(1,3,2020)
Which MDY function creates the date vaule for January 3, 2020?
catx(",", City, Country)
Which expression creates CityCountry?
round(Sales, .01)
Which expression rounds each value of sales to the nearest hundredth (or two decimal places)?
mean(of Week1-Week4)
Which function calculates the average of the columns Week1....
mean(of Var1-Var4)
Which function calculates the average of the variables?
COMPRESS
Which function could be used to remove the non-numeric symbols in Phone?
FLOOR
Which function returns the greatest integer less than or equal to the argument?
scan(type,2)
Which of the following SCAn functions would return "Cheese" from "nacho Cheese"
put(Level, 3.)
Which of the following functions can convert the values of the numeric variable Level to character values?
input(Base, comma10.2)
Which of the following functions converts the character values of Base to numeric values?
SAS converts the values of PayRate to numeric values. A message is written to the log.
Within the data set Hrd.Temp, PayRate is a character variable...
... if find(finish,'walnut',"I")>0; run;
Within the data set furn.bookcase, the variable Finish contains values such as....
Teacher=tranwrd(Teacher, 'Mrs.', 'Ms.'); Teacher=tranwrd(Teacher, 'Miss', 'Ms.');
You have the following list of teachers and need to replace the "Miss" ....