Select the best answer
for each question. Check your answers using the answer key in the
appendix.
-
Which function calculates
the average of the variables Var1, Var2, Var3, and Var4?
-
Within the data set
Hrd.Temp, PayRate is a character variable and Hours is a numeric variable.
What happens when the following program is run?
data work.temp;
set hrd.temp;
Salary=payrate*hours;
run;
-
SAS converts the values
of PayRate to numeric values. No message is written to the log.
-
SAS converts the values
of PayRate to numeric values. A message is written to the log.
-
SAS converts the values
of Hours to character values. No message is written to the log.
-
SAS converts the values
of Hours to character values. A message is written to the log.
-
A typical value for
the character variable Target is 123,456
.
Which statement correctly converts the values of Target to numeric
values when creating the variable TargetNo?
-
TargetNo=input(target,comma6.);
-
TargetNo=input(target,comma7.);
-
TargetNo=put(target,comma6.);
-
TargetNo=put(target,comma7.)
-
A typical value for
the numeric variable SiteNum is 12.3. Which statement correctly converts
the values of SiteNum to character values when creating the variable
Location?
-
Location=dept||'/'||input(sitenum,3.1);
-
Location=dept||'/'||input(sitenum,4.1);
-
Location=dept||'/'||put(sitenum,3.1);
-
Location=dept||'/'||put(sitenum,4.1);
-
Suppose the YEARCUTOFF=
system option is set to 1920. Which MDY function creates the date
value for January 3, 2020?
-
The variable Address2
contains values such as Piscataway, NJ
.
How do you assign the two-letter state abbreviations to a new variable
named State?
-
-
State=scan(address2,13,2);
-
State=substr(address2,2);
-
State=substr(address2,13,2);
-
The variable IDCode
contains values such as 123FA
and 321MB
.
The fourth character identifies sex. How do you assign these character
codes to a new variable named Sex?
-
Because of the growth
within the 919 area code, the telephone exchange 555 is being reassigned
to the 920 area code. The data set Clients.Piedmont includes the variable
Phone, which contains telephone numbers in the form 919-555-1234
.
Which of the following programs correctly changes the values of Phone?
-
data work.piedmont(drop=areacode exchange);
set clients.piedmont;
Areacode=substr(phone,1,3);
Exchange=substr(phone,5,3);
if areacode='919' and exchange='555'
then scan(phone,1,3)='920';
run;
-
data work.piedmont(drop=areacode exchange);
set clients.piedmont;
Areacode=substr(phone,1,3);
Exchange=substr(phone,5,3);
if areacode='919' and exchange='555'
then phone=scan('920',1,3);
run;
-
data work.piedmont(drop=areacode exchange);
set clients.piedmont;
Areacode=substr(phone,1,3);
Exchange=substr(phone,5,3);
if areacode='919' and exchange='555'
then substr(phone,1,3)='920';
run;
-
data work.piedmont(drop=areacode exchange);
set clients.piedmont;
Areacode=substr(phone,1,3);
Exchange=substr(phone,5,3);
if areacode='919' and exchange='555'
then phone=substr('920',1,3);
run;
-
Suppose you need to
create the variable FullName by concatenating the values of FirstName,
which contains first names, and LastName, which contains last names.
What is the best way to remove extra blanks between first names and
last names?
-
data work.maillist;
set retail.maillist;
length FullName $ 40;
fullname=trim firstname||' '||lastname;
run;
-
data work.maillist;
set retail.maillist;
length FullName $ 40;
fullname=trim(firstname)||' '||lastname;
run;
-
data work.maillist;
set retail.maillist;
length FullName $ 40;
fullname=trim(firstname)||' '||trim(lastname);
run;
-
data work.maillist;
set retail.maillist;
length FullName $ 40;
fullname=trim(firstname||' '||lastname);
run;
-
Within the data set
Furnitur.Bookcase, the variable Finish contains values such as ash,
cherry, teak, matte-black
. Which of the following
creates a subset of the data in which the values of Finish contain
the string walnut
? Make the search
for the string case-insensitive.
-
data work.bookcase;
set furnitur.bookcase;
if index(finish,walnut) = 0;
run;
-
data work.bookcase;
set furnitur.bookcase;
if index(finish,'walnut') > 0;
run;
-
data work.bookcase;
set furnitur.bookcase;
if index(lowcase(finish),walnut) = 0;
run;
-
data work.bookcase;
set furnitur.bookcase;
if index(lowcase(finish),'walnut') > 0;
run;