Chapter Review Quiz SAS logo

Data Transformations

Select the best answer for each question. When you are finished, click Submit Quiz.

The variable Address2 contains values such as Piscataway, NJ. Select the statement that extracts and assigns the two-letter state abbreviation to a new variable named State.

a. State=scan(Address2,2);

b. State=scan(Address2,13,2);

c. State=substr(Address2,2);

d. State=substr(Address2,13,2);

The variable IDCode contains values such as 123FA and 321MB. The fourth character identifies gender. Select the statement that assigns this character code to a new variable named Gender.

a. Gender=scan(IDCode,4);

b. Gender=scan(IDCode,4,1);

c. Gender=substr(IDCode,4);

d. Gender=substr(IDCode,4,1);

Due to 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 the telephone number in the form 808-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 Phone=substr('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;

Within the data set furn.bookcase, the variable Finish contains values such as ash, cherry, teak, and 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 furn.bookcase;
   if find(Finish,'walnut',I);
run;

data work.bookcase;
   set furn.bookcase;
   if find(Finish,'walnut','I')>0;
run;

What is the new value of Code?
Code="HNL:96701-006"; Code=substr(Code,1,length(Code)-4);
a.  96701-006

b.  HNL:

c.  HNL:96701

d.  1-006

Which function calculates the average of the variables Var1, Var2, Var3, and Var4?

a. mean(Var1,Var4)

b. mean(Var1-Var4)

c. mean(of Var1,Var4)

d. mean(of Var1-Var4)

Which function returns the greatest integer less than or equal to the argument?

a.  CEIL

b.  INT

c.  FLOOR

Which of the following functions can convert the values of the numeric variable Level to character values?

a. put(Level,3.)

b. input(3.,Level)

c. put(3.,Level)

d. input(Level,3.)

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?

a. Location=Dept||'/'||put(SiteNum, $3);

b. Location=Dept||'/'||put(SiteNum,4);

c. Location=Dept||'/'||put(SiteNum,3.1);

d. Location=Dept||'/'||put(SiteNum,4.1);

Which of the following functions converts the character values of Base to numeric values?

a. put(comma10.2,Base)

b. put(Base,comma10.2)

c. input(Base,comma10.2)

d. input(comma10.2, Base)