SAS Institute A00-201 Exam Questions & Answers

The SAS data set EMPLOYEE_INFO is listed below:

IDNUMBER Expenses 2542 100.00 3612 133.15

2198 234.34

2198 111.12

The following SAS program is submitted:

proc sort data = employee_info;

run;

Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

A. by descending IDNumber Expenses;

B. by (IDNumber Expenses) descending;

C. by IDNumber descending Expenses descending;

D. by descending IDNumber descending Expenses;

A raw data file is listed below:

1901 2 1905 1 1910 6 1925 . 1941 1

The following SAS program is submitted and references the raw data file above:

data coins; infile `file-specification'; input year quantity; run;

Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?

A. totquantity + quantity;

B. totquantity = sum(totquantity + quantity);

C. totquantity 0; sum totquantity;

D. retain totquantity 0; totquantity = totquantity + quantity;

The following SAS program is submitted:

data work.clients;

calls = 6;

do while (calls le 6);

calls + 1;

end;

run;

Which one of the following is the value of the variable CALLS in the output data set?

A. 4

B. 5

C. 6

D. 7