Exam (elaborations)
SAS PROGRAMMING CERTIFICATION TEST QUESTIONS
- Course
- Institution
SAS PROGRAMMING CERTIFICATION TEST QUESTIONS
[Show more]
Content preview
SAS PROGRAMMING CERTIFICATION TESTQUESTIONS
13.2 What is an advantage of storing dates and times as SAS numeric date and time
values?
a. They can easily be edited.
b. They can easily be read and understood.
c. They can be used in text strings like other character values.
d. They can be used in calculations like other numeric values. - Answers -Correct
answer: d
In addition to tracking time intervals, SAS date and time values can be used in
calculations like other numeric values
2.2 How many program steps are executed when the program below is processed?
data user.tables;
set work.jobs;
run;
proc sort data=user.tables;
by name;
run;
proc print data=user.tables;
run;
A. 3
B. 4
C. 5
D. 6 - Answers -Correct answer: a
When it encounters a DATA, PROC, or RUN statement, SAS stops reading statements
and executes the previous step in the program. This program contains one DATA step
and two PROC steps, for a total of three program step
2.5 With the system option VALIDVARNAME=ANY, which of the following variable
names is valid?
a. 4BirthDate
b. $Cost
c. _Items_
d. Tax-Rate
e. All of the above - Answers -Correct answer: e
If you use VALIDVARNAME=ANY, the name can begin with or contain any characters,
including blanks, national characters, special characters, and multi-byte characters. The
name can be up to 32 bytes long. The name must contain at least one character, and
the variable name can contain mixed-case letters
3.1 How long do librefs remain in effect?
a. until the LIBNAME statement is changed
,b. until the LIBNAME statement is canceled
c. until the SAS session ends
d. All of the above - Answers -Correct answer: d
Librefs remain in effect until the LIBNAME statement is changed, canceled, or until the
SAS session ends
3.2 Which of the following statements are true?
a. When using the default engine, you do not have to specify the libref in the LIBNAME
statement.
b. When using the default engine, you do not have to specify the engine name in the
LIBNAME statement.
c. When using the default engine, you do not have to specify the SAS library in the
LIBNAME statement.
d. When using the default engine, you have to specify the libref, engine name, and the
SAS library in the LIBNAME statement. - Answers -Correct answer: b
When you are using the default engine, you do not have to specify the engine name in
the LIBNAME statement. However, you do have to specify the libref and the SAS data
library name.
3.3 When you specify an engine for a library, what are you specifying?
a. the file format for files that are stored in the library
b. the version of SAS that you are using
c. access to other software vendors' files
d. instructions for creating temporary SAS files - Answers -Correct answer: a
A SAS engine is a set of internal instructions that SAS uses for writing to and reading
from files in a SAS library. Each engine specifies the file format for files that are stored
in the library, which in turn enables SAS to access files with a particular format. Some
engines access SAS files, and other engines support access to other vendors' file
3.4 Which statement prints a summary of all the files stored in the library named
Area51?
a. proc contents data=area51._all_ nods;
b. proc contents data=area51 _all_ nods;
c. proc contents data=area51 _all_ noobs;
d. proc contents data=area51 _all_.nods; - Answers -Correct answer: a
To print a summary of library contents with the CONTENTS procedure, use a period to
append the _ALL_ option to the libref. Adding the NODS option suppresses detailed
information about the files
3.5 Which of the following programs correctly references a SAS data set named
SalesAnalysis that is stored in a permanent SAS library?
a. data saleslibrary.salesanalysis;
set mydata.quarter1sales;
if sales>100000;
run;
b. data mysales.totals;
, set sales_2017.salesanalysis;
if totalsales>50000;
run;
c. proc print data=salesanalysis.quarter1;
var sales salesrep month;
run;
d. proc freq data=2017data.salesanalysis;
tables quarter*sales;
run; - Answers -Correct answer: b
Librefs must be 1 to 8 characters long, must begin with a letter or underscore, and can
contain only numbers, letters, or underscores. After you assign a libref, you specify it as
the first level in the two-level name for a SAS file
3.6 What type of information does the CONTENTS procedure create?
a. the contents of a library
b. descriptor information for an individual SAS data set
c. both A and B
d. none of the above - Answers -Correct answer: c
The CONTENTS procedure creates a report that contains the contents of a library or
the descriptor information for an individual SAS data set.
3.7 Assuming you are using SAS code, which one of the following statements is false?
a. LIBNAME statements can be stored with a SAS program to reference the SAS library
automatically when you submit the program.
b. When you delete a libref, SAS no longer has access to the files in the library.
However, the contents of the library still exist on your operating system.
c. Librefs can last from one SAS session to another.
d. You can access files that were created with other vendors' software by submitting a
LIBNAME statement. - Answers -Correct answer: c
The LIBNAME statement is global, which means that librefs stay in effect until changed
or canceled, or until the SAS session ends
2.6 Which of the following files is a permanent SAS file?
a. Work.PrdSale
b. Cert.MySales
c. Certxl.Quarter1
d. only b and c above
e. all of the above - Answers -Correct answer: d
To store a file permanently in a SAS data library, you assign it a libref. For example, by
assigning the libref Cert to a SAS data library, you specify that files within the library are
to be stored until you delete them. Therefore, SAS files in the Cert and Certxl libraries
are permanent files
2.7 In a DATA step, how can you reference a temporary SAS data set named Forecast?
a. Forecast
b. Work.Forecast
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)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now