Exam (elaborations)
SAS BASE CERTIFICATION QUESTIONS & ANSWERS
- Course
- Institution
SAS BASE CERTIFICATION QUESTIONS & ANSWERS
[Show more]
Content preview
SAS BASE CERTIFICATION QUESTIONS & ANSWERSc - Answers -Which of the following will select from a data set only those observations
for which the value of the variable Genre is SciFi, Western, or Classic?
a.where genre='SciFi' or 'Western' or 'Classic';
b.where genre is SciFi Western Classic;
c.where genre in ('SciFi', 'Western', 'Classic');
d.where genre in (SciFi, Western, Classic);
b - Answers -What happens when the following program is run?
proc sort data=black.book;
run;
proc print data=black.book;
var name age number;
where status='Single';
run;
a. The PROC PRINT step is successful, providing list in sorted order.
b. The PROC SORT generates an error in the log, the PROC PRINT step runs.
c. The PROC SORT step permanently sorts the data set.
d. The PROC SORT runs successfully, PROC PRINT generates errors
d - Answers -What usually happens when a syntax error is detected?
a. SAS continues to process the step, and the SAS log displays messages about the
error.
b. SAS continues to process the step.
c. SAS stops processing the step in which the error occurred, and the Output window
displays messages about the error.
d. SAS stops processing the step in which the error occurred, and the SAS log displays
messages about the error
a - Answers -What is the default length of the variable BALANCE?
Name Balance
Andrews 123.21
Smithy 92.31
Keeley 2812.23
Cist 981.99
a. 8
b. 32
c. 0
d. 16
,c - Answers -Which time span is used to interpret two-digit values if the YEARCUTOFF=
option is set to 1969?
a. 1969-2000
b. 1969-2069
c. 1969-2068
d. 1870-1969
e. 1970-2069
b - Answers -What does the NOOBS option do in the PROC PRINT step?
a. Relentlessly mocks you for being new to SAS.
b. Removes the default Obs column from the output
c. Prints only the the column titles with no data.
d. Prints the data with no column titles.
c - Answers -Which statement correctly accesses an Excel file?
a.libname xldat 'C:\Excel\example.xlsx.Sheet1';
b.filename xldat 'C:\Excel\example.xlsx';
c.libname xldat 'C:\Excel\example.xlsx';
d.filename xldat 'C:\Excel\example.xlsx\Sheet1$';
j - Answers -The following format substitutes full names for initials. Identify the error(s).
proc format lib=soil;
value drvfmt;
SS=Sam Smithie Smith
JR=Jim Rollins
ER=Elmer Richards
run;
a. the strings on the right of the equal sign need to have quotes.
b. the strings on the left of the equal sign need to have quotes.
c. the format needs to have a $ in front of the name
d. semicolons should be after each line
e. there should be no semicolon after the word drvfmt
f. there should be a semicolon after the final format entry
g. (a) and (b)
h. (c) and (d)
i. (e) and (f)
j. (a), (b), (c), (e), and (f)
k. all of the above
l. none of the above
, d - Answers -In the DATA step, how can you reference the temporary SAS data set
named Dating
a. Dating
b. Work.Dating
c. Pool.Dating (after assigning the libref Pool)
d. a and b
a - Answers -Which of the following is a valid variable name?
a. _Units_
b. 2Cool
c. Total$
d. Days-To-Ship
d - Answers -Which of the following contains a syntax error?
a. None of these
b.proc print data=sales.location;
label loc='Franchise Location';
run;
c.proc sort data=work.sales;
by month;
run;
d.dat homework.test;
set homework.quiz;
run;
c - Answers -A syntax error occurs when
a. the form of the elements of the SAS statement are correct but their usage is not.
b. none of these.
c. programming statements that do not conform to the rules of the SAS language.
d. some data values are not appropriate for the SAS statements.
a - Answers -If SAS cannot interpret a syntax error, then
a. the DATA step compiles but does not execute.
b. the DATA step does not compile.
c. the DATA step compiles and executes.
d. the variables in the data set will all be set to missing values.
d - Answers -Which statement identifies the name of a raw data file to be read with the
fileref Jobs and specifies that the DATA step only read records 1-20?
a. infile jobs obs 20;
b. infile jobs 1-20;
c. input jobs 1-20;
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now