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 -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.
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
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;
d. infile jobs obs=20;
e. input jobs obs=20;
a - Answers -What is not created in the compilation phase of the DATA step?
a. the first observations
b. the automatic variables _N_ and _ERROR_
c. the data set descriptor
d. the program data vector
d - Answers -Which of the following statements will process only the records above
where Driver is SS?
a. a or c
b.if driver=SS
c.if driver is SS
d.if driver='SS'
b - Answers -During the compilation phase, SAS checks each statement looking for
syntax errors. Which of the following is not a syntax error?
a. missing or invalid punctuation
b. improper formats and incorrect values
c. missing or misspelled keywords.
d. invalid options or variable names
c - Answers -How would you create a list report of an Excel sheet?
a.data work.new; infile xldat.'Sheet1$'; input var1 var2 var3; run; proc print
data=work.new; run;
b.proc print data=xldat; sheet = 'Sheet1'; run;
c.proc print data=xldat.'Sheet1$'n; run;
d.proc print data=xldat.'Sheet1$'; run;
d - Answers -When you run a SAS program to read in biographical information, an error
occurs from the 3rd to the 20th records due to a change of format in the DoB column.
What is the value of _ERROR_ after the 17th record is read in?
a. 0
b. 14
c. 3
d. 1
b - Answers -The DATA step will execute
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 SUMMER2022. 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)
81989 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now