文档文库

手机版

投诉建议

首页 > SAS Base Programming for SAS 9

SAS Base Programming for SAS 9

发布时间：2010-10-14 14:27:29 来源：文档文库

小中大

字号：

手机查看

Item 1

The following program is submitted.

data test;

input name $ age;

cards;

John +35

;

run;

Which values are stored in the output data set?

A. name age

---------------------

John 35

B. name age

---------------------

John (missing value)

C. name age

---------------------

(missing value) (missing value)

D. The DATA step fails execution due to data errors.

correct_answer = "A"

Item 2

The following observation is stored in a SAS data set named EMPLOYEES:

LNAME FNAME JOBCODE

---------------------------------

Whitley Sam na1

If the DATA step below is executed, what will be the value of the variable JOBDESC in the output SAS data set when this observation is processed:

data navigate;

set employees;

if jobcode = 'NA1' then jobdesc = 'Navigator';

run;

A. navigator

B. Navigator

C. NAVIGATOR

D. a missing value

correct_answer = "D"

Item 3

The following SAS program is submitted:

proc format;

value score 1 - 50 = 'Fail'

51 - 100 = 'Pass';

run;

Which one of the following PRINT procedure steps correctly applies the format?

A. proc print data = sasuser.class;

var test;

format test score;

run;

B. proc print data = sasuser.class;

var test;

format test score.;

run;

C. proc print data = sasuser.class format = score;

var test;

run;

D. proc print data = sasuser.class format = score.;

var test;

run;

correct_answer = "B"

Item 4

Given the following DATA step:

data loop;

x = 0;

do index = 1 to 5 by 2;

x = index ;

end;

run;

Upon completion of execution, what are the values of the variables X and INDEX in the SAS data set named LOOP?

A. x = 3, index = 3

B. x = 3, index = 4

C. x = 5, index = 5

D. x = 5, index = 6

E. x = 5, index = 7

correct_answer = "E"

Item 5

Given that the data set named ONE contains 10 observations and the data set named TWO contains 10 observations, how many observations will be contained in the data set named COMBINE that is created in the following DATA step?

data combine;

set one two;

run;

A. 10

B. 20

C. 0, the DATA step will fail due to syntax errors

D. 10 to 20, depending on how many observations match

correct_answer = "B"

SAS Advanced Programming for SAS 9

Item 1

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted:

proc sql;

select one.*, sales

from one right join two

on one.year = two.year;

quit;

Which one of the following reports is generated?

A.

B.

C.

D.

correct_answer = "D"

Item 2

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted creating the output table THREE:

data three;

merge one (in = in1) two (in = in2);

by num;

run;

Which one of the following SQL programs creates an equivalent SAS data set THREE?

A. proc sql;

create table three as

select *

from one full join two

where one.num = two.num;

quit;

B. proc sql;

create table three as

select coalesce(one.num, two.num)

as NUM, char1, char2

from one full join two

where one.num = two.num;

quit;

C. proc sql;

create table three as

select one.num, char1, char2

from one full join two

on one.num = two.num;

quit;

D. proc sql;

create table three as

select coalesce(one.num, two.num)

as NUM, char1, char2

from one full join two

on one.num = two.num;

quit;

correct_answer = "D"

Item 3

The following SAS program is submitted:

%let type = RANCH;

proc sql;

create view houses as

select *

from sasuser.houses

where style = "&type";

quit;

%let type = CONDO;

proc print data = houses;

run;

The report that is produced displays observations whose value of STYLE are all equal to RANCH.

Which one of the following functions on the WHERE clause resolves the current value of the macro variable TYPE?

A. GET

B. SYMGET

C. %SYMGET

D. &RETRIEVE

correct_answer = "B"

Item 4

The SAS data set SASDATA.SALES has a simple index on the variable DATE and a variable named REVENUE with no index.

In which one of the following SAS programs is the DATE index considered for use?

A. proc print data = sasdata.sales;

by date;

run;

B. proc print data = sasdata.sales;

where month(date) = 3;

run;

C. data march;

set sasdata.sales;

if '01mar2002'd < date < '31mar2002'd;

run;

D. data march;

set sasdata.sales;

where date < '31mar2002'd or revenue > 50000;

run;

correct_answer = "A"

SAS Warehouse Architect Concepts

Item 1

A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements.

According to "The Data Warehouse Lifecycle Toolkit" by Ralph Kimball, which of the following should be included on the agenda?

A. number of users

B. routine reporting

C. database design

D. corporate objectives

correct_answer = "B"

Item 2

According to the SAS Rapid Warehouse Methodology, which of the following occurs during the Final Test phase?

I. system test

II. integration test

III. performance test

IV. change management

A. I and III only

B. I, II, and III only

C. I, III, and IV only

D. I, II, III, and IV

correct_answer = "C"

Item 3

A client has a customer-oriented data mart currently in place. A new data mart is being developed using customer information from the current data mart and a new customer-oriented data source.

There is a requirement to provide rollups across data marts using this customer information.

Which of the following meets this requirement?

A. building a separate customer dimension for each data mart

B. appending both customer sources and adding attributes identifying the

source from where customer information was derived

C. using a surrogate primary key similar to the production systems so that

they may be reused or merged with other system keys

D. building a conformed customer dimension by creating a master table of

customers with a clean customer key and many well-maintained attributes

correct_answer = "A"

Item 4

A warehouse architect has completed the logical design of a dimensional data model and is developing the corresponding physical model.

Which of the following must be considered in the physical design of the dimensional data model?

I. data volume

II. usage patterns

III. source data repository

IV. warehouse data repository

A. I and II only

B. I and IV only

C. I, II, and IV

D. II, III, and IV

correct_answer = "C"

Item 5

A large data warehouse source extract requires table joins from a live relational database management system (RDBMS) transactional system.

Which of the following are possible negative effects of the above action?

I. two phase commit locking

II. blocking transaction commits

III. exhausting temporary table space

IV. degraded OLTP query performance

A. I and II only

B. III and IV only

C. I, II, and III

D. II, III, and IV

correct_answer = "D"

SAS Warehouse Development Specialist

Item 1

Which of the following is most important when deciding on the data structure of a data mart?

A. data access tools to be used

B. XML data exchange standards

C. metadata naming conventions

D. extract, transform, and load (ETL) tool to be used

correct_answer = "A"

Item 2

For a particular project, legal regulations require that only current data for an individual is stored in the CUSTOMER dimension of a data warehouse.

According to The Data Warehouse Toolkit, by Ralph Kimball, which of the following slowly changing dimension techniques is the most appropriate for updating the CUSTOMER dimension?

A. Type I

B. Type II

C. Type III

D. Type IV

correct_answer = "A"

Item 3

Within SAS/Warehouse Administrator, which of the following actions may be enabled by the metadata record such that a data source is visible in a data warehouse environment?

I. Defining the extraction process

II. Registering the location of a DBMS table

III. Registering the location of a SAS table or view

IV. Defining the logical and physical models represented

A. I and II only

B. III and IV only

C. I, II and III only

D. I, II, III and IV

correct_answer = "C"

Item 4

Which of the following enable changed data capture from a source system with no date/time modification stamps?

I. Use a program to read the database log files to detect changed records.

II. Process a complete refresh from the source system into the data

warehouse.

III. Identify an effective date within the source data and utilize it to detect

changes.

IV. Compare the current warehouse data to the full source input and

generate deltas.

A. I and II only

B. II and III only

C. I and IV only

D. III and IV only

correct_answer = "C"

Item 5

Which of the following steps are executed during the system testing process?

I. confirming that all test data loads were successful

II. developing error handling procedures for failed tests

III. ensuring that processes perform together as specified in the test plan

IV. verifying that data quality and performance meet agreed upon

specifications

A. I and III only

B. II and IV only

C. I, II and IV only

D. I, III and IV only

correct_answer = "D"

SAS Warehouse Technology

Item 1

In the SAS Management Console Metadata Manager plug-in, what are the valid values for the type of audit to perform on a metadata repository?

A. Added, Deleted, Modified or All

B. Added, Deleted, Updated or All

C. Inserted, Deleted, Modified or All

D. Inserted, Deleted, Updated or All

correct_answer = "B"

Item 2

When using the Change Management feature of SAS ETL Studio, what type of data may be changed?

A. ETL process source code deployed for scheduling

B. Physical data in the tables of the warehouse

C. Existing transformations in the ETL Process Library

D. Metadata in the SAS metadata repository

correct_answer = "D"

Item 3

Which one of the following scenarios depicts when one must use the explicit SAS SQL Pass-Through Facility instead of the SAS/ACCESS Libname engine in order to get a single RDBMS to do all the processing?

A. retrieving only certain rows from an RDBMS table

B. retrieving only certain columns from an RDBMS table

C. retrieving only certain rows and columns from a join of RDBMS tables in

the same schema

D. retrieving only certain rows and columns from a join of RDBMS tables in

different schemas

correct_answer = "D"

Item 4

What does the ARM acronym represent?

A. Automated Response Management

B. Application Response Management

C. Automated Response Measurement