SAS Base Programming Exam UPDATED Actual Questions and CORRECT Answers
1 view 0 purchase
Course
SAS Base Programming
Institution
SAS Base Programming
SAS Base Programming Exam UPDATED
Actual Questions and CORRECT Answers
b) A SAS library is a collection of one or more SAS files that are referenced as a unit -
CORRECT ANSWER- Which statement about SAS libraries is true?
a) You refer to a SAS library by a logical name called a libname
b) A S...
SAS Base Programming Exam UPDATED
Actual Questions and CORRECT Answers
b) A SAS library is a collection of one or more SAS files that are referenced as a unit -
CORRECT ANSWER✔✔- Which statement about SAS libraries is true?
a) You refer to a SAS library by a logical name called a libname
b) A SAS library is a collection of one or more SAS files that are referenced as a unit
c) A single SAS library must contain files that are stored in different physical locations
d) At the end of each session, SAS deletes the contents of all SAS libraries
b) The data set Sasuser.One is created with 2 variables and 0 observations - CORRECT
ANSWER✔✔- Assume that Sasuser.One does not exist and that the following SAS program
is submitted at the beginning of a new SAS session:
data sasuser.one;
x=1; y=27;
output one;
run;
a) The data set Sasuser.One is created with 2 variables and 3 observations
b) The data set Sasuser.One is created with 2 variables and 0 observations
c) The data set Work.One is created with 2 variables and 1 observation
d) The data set Sasuser.One is created with 2 variables and 1 observation
2 possible solutions:
1) libname myxlsx clear;
2) libname myxlsx (omitting clear is acceptable syntax) - CORRECT ANSWER✔✔- This
question will ask you to provide a line of missing code. The following SAS program is
submitted:
libname myxlsx xlsx 'C:\data\sales.xlsx';
proc print data = myxlsx.qtr1;
run;
,<enter text here>
Write the statement that will remove the library reference MYXLSX from the Excel
Workbooksales.xlsx?
A. The RESULTS
Data Set name Dept age
Tom Engineering 36
Sally HR 42
David engineering 30
Mary 27 - CORRECT ANSWER✔✔- Given the SAS data set WORK.EMPLOYEE:
name Dept age
----- ----------- ---
Tom Engineering 36
Sally HR 42
David engineering 30
and the SAS data set WORK.NEW_EMPS:
name age
---- ---
Mary 27
The following code is submitted:
data WORK.FINAL_EMPS;
set WORK.EMPLOYEE WORK.NEW_EMPS;
run;
proc print data=WORK.FINAL_EMPS;
title 'The RESULTS Data Set';
run;
What is the resulting data set?
,A. The RESULTS
Data Set name Dept age
Tom Engineering 36
Sally HR 42
David engineering 30
Mary 27
B. The RESULTS
Data Set name Dept age
Tom Engineering 36
Sally HR 42
David engineering 30
Mary engineering 27
C. The RESULTS
Data Set name Dept age
Tom Engineering 36
Sally HR 42
David engineering 30
D. The RESULTS
Data Set name Dept age
Mary 27
Tom Engineering 36
Sally HR 42
David engineering 30
c) $CHAR10 - CORRECT ANSWER✔✔- The variable Name in the data set Employee has a
$CHAR10. format. The variable Name in the data set Sales has a $CHAR15. format.The
following SAS program is submitted:
, data both;
merge employee sales;
by name;
run;
What is the format for the variable Namein the data set Both?
a) no format defined
b) $CHAR
c) $CHAR10
d) $CHAR15
c) 2 - CORRECT ANSWER✔✔- Given the following SAS data set WORK.CLASS:
Name Gender Age
Anna F 23
Ben M 25
Bob M 21
Brian M 27
Edward M 26
Emma F 32
Joe M 34
Sam F 32
Tom M 24
The following program is submitted:
data WORK.MALES WORK.FEMALES(drop=age);
set WORK.CLASS;
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 MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
