Welcome to CertificationDumps.com !

Are u looking to Pass your Certification Exam? Then you have came to the right place here you will find real exam questions of any exam taken from the testing center and aslo links to sites that sell them. So now passing your certification exam has become much easier than before all you have to do is memorize the questions you will see exactly the same questions in the real exam. In today world time is money so by this not only you save time plus you aslo save yourself the hassale of failing

December 08 2009

SAS Institute A00-201 Dumps

sas base programming exam

  • Exam Number/Code : A00-201
  • Exam Name : sas base programming exam
  • Questions and Answers : 140 Q&As

Download Pass4sure SAS Institute A00-201 Dumps from the link below
Download CertifyMe SAS Institute A00-201 Dumps from the link below
Download Testking SAS Institute A00-201 Dumps from the link below


Download SAS Institute A00-201 Dumps


PrepKing.com 3COM 3M0-250 Sample Questions

Exam : SAS-Institute-Systems
A00-201
Title : Sas Base Programming Exam

1. The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile ‘file-specification’ end = eof;
input name $ salary;
totsal + salary;

run;
Which one of the following IF statements writes the last observation to the output data set?
A. if end = 0;
B. if eof = 0;
C. if end = 1;
D. if eof = 1;
Answer: D

2. Which one of the following is true when SAS encounters a data error in a DATA step?
A. The DATA step stops executing at the point of the error, and no SAS data set is created.
B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
Answer: B

3. The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?
A. Add the option MAXDEC = 2 to the MEANS procedure statement.
B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.
Answer: A

4. The following SAS program is submitted:
libname sasdata ‘SAS-data-library’;
data test;
set sasdata.chemists;
if jobcode = ‘chem3′
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
A. chem3
B. Unknown
C. Senior Chemist
D. ‘ ‘ (missing character value)
Answer: B

5. The following SAS program is submitted:
data work.month;
date = put(’13mar2000′d,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
A. numeric, 8 bytes
B. numeric, 10 bytes
C. character, 8 bytes
D. character, 10 bytes
Answer: D

6. The following SAS program is submitted:
data work.retail;
cost = ’20000′;
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?
A. 2000
B. ’2000′
C. . (missing numeric value)
D. ‘ ‘ (missing character value)
Answer: A

7. The following SAS program is submitted:
data work.flights;
destination = ‘CPH’;
select(destination);
when(‘LHR’) city = ‘London’;
when(‘CPH’) city = ‘Copenhagen’;
otherwise;
end;
run;
Which one of the following is the value of the CITY variable?
A. London
B. Copenh
C. Copenhagen
D. ‘ ‘ (missing character value)
Answer: B

8. The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
Which one of the following represents how many observations the WORK.TOTAL data set contains?
A. 5
B. 20
C. 100
D. 500
Answer: A


Download SAS Institute A00-201 Dumps

December 08 2009

SAS Institute A00-212 Dumps

SAS Advanced Programming Exam for SAS 9

  • Exam Number/Code : A00-212
  • Exam Name : SAS Advanced Programming Exam for SAS 9
  • Questions and Answers : 65 Q&As

Download Pass4sure SAS Institute A00-212 Dumps from the link below
Download CertifyMe SAS Institute A00-212 Dumps from the link below
Download Testking SAS Institute A00-212 Dumps from the link below


Download SAS Institute A00-212Dumps



PrepKing.com SAS Institute A00-212 Sample Questions

Exam : SAS A00-212
Title : SAS Advanced Programming Exam for SAS 9

1. Given the SAS data set ONE:
ONE JOBLEVEL SALARY
ACC2 300
SEC1 100
SEC2 200
MGR3 700
ACC1 .
ACC3 .
MGR2 400
The following SAS data set TWO is required:
TWO JOBLEVEL BONUS
ACC2 30
MGR3 70
MGR2 40
Which SQL procedure program creates the data set TWO?
A. proc sql;
create table two as
select job, level, salary * 0.1 as BONUS
from one
where 3 > 20;
quit;
B. proc sql;
create table two as
select job, level, salary * 0.1 as BONUS
from one
where calculated 3 > 20;
quit;
C. proc sql;
create table two as
select job, level, salary * 0.1 as BONUS
from one
where bonus * 0.1 > 20;
quit;
D. proc sql;
create table two as
select job, level, salary * 0.1 as BONUS
from one
where calculated bonus > 20;
quit;
Answer: D

2. Given the SAS data set ONE:
ONENUMVAR
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
A. proc sql;
delete table one;
quit;
B. proc sql;
remove table one;
quit;
C. proc sql;
drop table one;
quit;
D. proc sql;
delete from one;
quit;
Answer: C

3. The following SAS program is submitted:
proc contents data = testdata.one;
run;
Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA. ONE?
A. proc sql;
contents testdata.one;
quit;
B. proc sql;
describe testdata.one;
quit;
C. proc sql;
contents table testdata.one;
quit;
D. proc sql;
describe table testdata.one;
quit;
Answer: D

4. Which of the following is true about the COMPRESS= YES data set option?
A. It uses the Ross Data Compression method to compress numeric data.
B. It is most effective with character data that contains repeated characters.
C. It is most effective with numeric data that represents large numeric values.
D. It is most effective with character data that contains patterns, rather than simple repetitions.
Answer: B

5. The following SAS program is submitted:
%let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = “&lib”;
quit;
Several SAS data sets exist in the SASUSER library.
What is generated as output?
A. a report showing the numeric columns in each table in SASUSER
B. a report showing the number of columns in each table in SASUSER
C. a report showing the names of the columns in each table in SASUSER
D. a report showing the number of numeric columns in each table in SASUSER
Answer: B

6. Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
A. MODIFY
B. FORMAT
C. REGISTRY
D. DATASETS
Answer: D

7. The following SAS program is submitted:
%let test = one;
%let one = two;
%let two = three;
%let three = last;
%put what displays is &&&&&test;
What is written to the SAS log?
A. what displays is one
B. what displays is two
C. what displays is three
D. what displays is last
Answer: B

8. Given the SAS data set ONE:
ONEREP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep;
quit;
The following output is desired:
REP AVERAGE
SMITH 400
Which SQL procedure clause completes the program and generates the desired output?
A. having avg(cost) < (select avg(cost) from one)
B. where avg(cost) > (select avg(cost) from one)
C. having avg(cost) > (select avg(cost) from one)
D. where calculated average > (select avg(cost) from one)
Answer: C


Download SAS Institute A00-212Dumps

December 08 2009

SAS Institute A00-203 Dumps

sas warehouse development specialist concepts exam

  • Exam Number/Code : A00-203
  • Exam Name : sas warehouse development specialist concepts exam
  • Questions and Answers : 65 Q&As

Download Pass4sure SAS Institute A00-203 Dumps from the link below
Download CertifyMe SAS Institute A00-203 Dumps from the link below
Download Testking SAS Institute A00-203 Dumps from the link below


Download SAS Institute A00-203 Dumps


PrepKing.com SAS Institute A00-203 Sample Questions

Exam : SAS A00-203
Title : SAS Warehouse Development Specialist Concepts Exam

1. Which of the following backup scenarios least impacts the data warehouse host?
A. using network filers for storage
B. using directly attached devices
C. running the backup software on a separate host with a high speed NFS connection
D. using a storage area network and running the backup software on a separate host
Answer: D

2. Which of the following helps to reduce the I/O for a procedure that requires every row of a SAS table to be processed?
A. indexing the SAS table
B. using the SQL procedure
C. partitioning the SAS table
D. compressing the SAS data set
Answer: D

3. Click on the Exhibit button to view a diagram that displays a data warehouse environment:
Which of the following describes the optimal method to join a transformed DB2 table with an Oracle table and load the result set to the data warehouse using SAS ETL Server and its components?
A. Generate code with SAS ETL Studio which:
connects to host 2 from host 1,
transforms the DB2 data on host 1,
downloads the Oracle data using the DOWNLOAD procedure to host 1,
joins those result sets on host 1,
downloads the joined data using the DOWNLOAD procedure to host 2,
and populates the target data warehouse table.
B. Generate code with SAS ETL Studio which:
connects to host 2 from host 1,
transforms the DB2 data on host 1,
extracts the Oracle data from host 2 using Remote Library Services,
joins those result sets on host 1,
and loads the target data warehouse table with the joined data using Remote Library Services to host 2.
C. Generate code with SAS ETL Studio which:
connects to host 1 from host 2,
transforms the DB2 data on host1,
downloads the result set using the DOWNLOAD procedure,
extracts the ORACLE data on host 2,
joins those result sets on host 2,
and populates the target data warehouse table.
D. Generate code with SAS ETL Studio which:
connects to host 1 from host 2,
downloads the DB2 data using Remote Library Services,
transforms the downloaded data on host 2,
extracts the ORACLE data on host 2,
joins those result sets on host 2,
and populates the target data warehouse table.
Answer: C

4. Which of the following should be stored in the metadata for a data warehouse?
A. business rules, logical model, and transformation rules
B. business rules, conventions and target table data values
C. derived data values, subject model and transformation rules
D. business rules, target table data values and transformation rules
Answer: A

5. Which of the following must be considered when designing unit tests for the target load process?
I. access capabilities to source data
II. predefined test cases that check transformation rules
III. validity of the data extracted from the operational data store (ODS)
IV. test plan with conditions and results that match the design specification
A. II and IV only
B. I, II, and IV only
C. II, III, and IV only
D. I, II, III, and IV
Answer: A

6. For which of the following should metadata be captured?
A. data exploitation and data storage only
B. extract, transform, and load (ETL) processes only
C. data storage and extract, transform, and load (ETL) processes only
D. data exploitation, data storage, and the extract, transform, and load (ETL) processes
Answer: D

7. According to the SAS Rapid Warehousing Methodology, in which of the following phases must the acceptance test criteria be defined?
A. final test
B. assessment
C. deployment
D. requirements
Answer: D

8. Which of the following describes the dimension tables in a star schema logical design?
A. They are normalized and can join only through the fact table.
B. They are denormalized and can join only through the fact table.
C. They are normalized and can join through the fact table or each other.
D. They are denormalized and can join through the fact table or each other.
Answer: B


Download SAS Institute A00-203 Dumps


December 08 2009

SAS Institute A00-205 Dumps

sas webaf server-side application development

  • Exam Number/Code : A00-205
  • Exam Name : sas webaf server-side application development
  • Questions and Answers : 55 Q&As

Download Pass4sure SAS Institute A00-205 Dumps from the link below
Download CertifyMe SAS Institute A00-205 Dumps from the link below
Download Testking SAS Institute A00-205 Dumps from the link below


Download SAS Institute A00-205 Dumps


PrepKing.com SAS Institute A00-205 Sample Questions

Exam : SAS A00-205
Title : SAS Webaf Server-Side Application Development

1. Which of the following describes viewing the detailed data behind a specific data cell in a SAS MDDB?
A. Expand
B. Subset
C. Drill down
D. Reach-through
Answer: D

2. A SAS program named printProcedure contains a macro variable named numObs.
A JSP file includes:
a form with a choice box control named number that contains numeric values that are used to specify the number of observations printed in the report
a Submit Custom Tag that submits the SAS program named printProcedure.
Which of the following JSP code segments retrieves the value selected in the choice box and assigns it to the macro variable?
I. <sasads:Submit id=”submit1″ connection=”connection1″
display=”LASTOUTPUT” >
%let numObs=<%=request.getParameter(“number”)%>;
%include ‘c:printProcedure.sas’;
</sasads:Submit>
II. <% String selObs=request.getParameter(“number”); %>
<sasads:Submit id=”submit1″ connection=”connection1″
display=”LASTOUTPUT” >
%let numObs=<%=selObs%>;
%include ‘c:printProcedure.sas’;
</sasads:Submit>
III. <% String selObs=request.getParameter(“number”); %>
<sasads:Submit id=”submit1″ connection=”connection1″
display=”LASTOUTPUT” >
%let numObs=selObs;
%include ‘c:printProcedure.sas’;
</sasads:Submit>
IV. <% String selObs=request.getParameter(“number”); %>
<sasads:Submit id=”submit1″ connection=”connection1″
display=”LASTOUTPUT” >
%let numObs=&selObs;
%include ‘c:printProcedure.sas’;
</sasads:Submit>
A. I only
B. III only
C. I and II only
D. III and IV only
Answer: C

3. Which of the following are advantages of using JavaScript on an HTML form?
I. It can implement client-side validation.
II. It can implement server-side validation.
III. It can implement data security on the form.
IV. It can enable a submit request without needing a submit button.
A. I and IV only
B. II and IV only
C. I, III, and IV
D. II, III, and IV
Answer: A

4. Click on the Exhibit button to display an entity-relationship data model for a stock broker program.
The data model needs to be optimized for queries to gather a customer’s net worth on a given day. The broker has two customers holding stock in several hundred different companies. Daily pricing history goes back ten years for each company.
Which one of the following index schemes allows optimal performance of the query?
A. composite index on cusip and date in the Prices table
composite index on cusip and trandate in the Transaction table
B. composite index on cusip and date in the Prices table
composite index on cust_name, cusip, and trandate in the Transaction table
C. simple index on cusip in the Prices table
simple index on date in the Prices table
composite index on cusip and trandate in the Transaction table
D. composite index on date and cusip in the Prices table
simple index on cusip in the Transaction table
simple index on trandate in the Transaction table
Answer: C

5. The following JSP uses tags to access SAS data:
<%@taglib uri=”http://www.sas.com/taglib/sasads”
prefix=”sasads”%>
<html><body>
<sasads:Connection id=”connection1″ scope=”session”
initialStatement=”libname db ‘.’;” />
<sasads:Submit connection=”connection1″
display=”LASTOUTPUT” >
data report;
set db.payroll (obs=10);
where division=’EUROPE’;
run;
proc print data=report;
</sasads:Submit>
/body></html>
Which of the following explains why no results are displayed?
A. The SAS program contains a syntax error.
B. The SAS program is missing a step boundary.
C. The Connection Custom Tag syntax is incorrect.
D. The open Submit Custom Tag syntax is incorrect.
Answer: B

Download SAS Institute A00-205 Dumps


December 08 2009

SAS Institute A00-202 Dumps

sas advanced programming exam

  • Exam Number/Code : A00-202
  • Exam Name : sas advanced programming exam
  • Questions and Answers : 130 Q&As

Download Pass4sure SAS Institute A00-202 Dumps from the link below
Download CertifyMe SAS Institute A00-202 Dumps from the link below
Download Testking SAS Institute A00-202 Dumps from the link below


Download SAS Institute A00-202 Dumps


PrepKing.com SAS Institute A00-202 Sample Questions

Exam : SAS-Institute-Systems
A00-202
Title : SAS Advanced Programming Exam

1. The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?
A. any integer between 1 and 10
B. any real number between 0 and 1
C. any integer between 1 and 2,500,000
D. any real number between 1 and 2,500,000
Answer: C

2. The following SAS code is submitted:
%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = “&sub”;
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)
Which one of the following is the value of the automatic macro variable SYSLAST?
A. work.ranch
B. work.houses
C. WORK.RANCH
D. WORK.HOUSES
Answer: D

3. The following SAS program is submitted:
proc sort data = sales tagsort;
by month year;
run;
Which of the following resource(s) is the TAGSORT option reducing?
A. I/O usage only
B. CPU usage only
C. I/O and CPU usage
D. temporary disk usage
Answer: D

4. Given the following SAS data set ONE:
ONE
REP COST
____________
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
JONES 200
JONES 400
SMITH 800
JONES 100
JONES 300
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep
having avg(cost) > (select avg(cost) from one);
quit;
Which one of the following reports is generated?
A. REP AVERAGE
_______________
JONES 200
B. REP AVERAGE
_________________
JONES 320
C. REP AVERAGE
________________
SMITH 320
D. REP AVERAGE
________________
SMITH 500
Answer: D

5. Which one of the following programs contains a syntax error?
A. proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and
p.item = s.item;
quit;
B. proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
C. proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and
p.item = s.item;
quit;
D. proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
Answer: D

6. The following SAS program is submitted:
;
%let development = ontime;
proc print data = sasuser.highway;
title “For &dept”;
title2 “This project was completed &development”;
run;
Which one of the following statements completes the above and resolves title1 to “For research&development”?
A. %let dept = %str(research&development);
B. %let dept = %str(research%&development);
C. %let dept = %nrstr(research&development);
D. %let dept = %nrstr(research%&development);
Answer: C

7. Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?
A. RENAME statement only
B. CHANGE statement only
C. MODIFY and RENAME statements
D. MODIFY and CHANGE statements
Answer: B

8. Which one of the following options controls the pagesize of a SAS data set?
A. SIZE=
B. BUFNO=
C. BUFSIZE=
D. PAGESIZE=
Answer: C


Download SAS Institute A00-202 Dumps

December 08 2009

SAS Institute A00-204 Dumps

sas warehouse architect concepts

  • Exam Number/Code : A00-204
  • Exam Name : sas warehouse architect concepts
  • Questions and Answers : 65 Q&As

Download Pass4sure SAS Institute A00-204 Dumps from the link below
Download CertifyMe SAS Institute A00-204 Dumps from the link below
Download Testking SAS Institute A00-204 Dumps from the link below


Download SAS Institute A00-204 Dumps


PrepKing.com SAS Institute A00-204 Sample Questions

Exam : SAS A00-204
Title : SAS Warehouse Architect Concepts

1. Which of the following factors must be considered when designing an efficient client-server ad hoc query system?
A. output appearance
B. user access privileges
C. graphical user interface
D. number of rows in the result set
Answer: D

2. Which of the following provides read access control to a SAS dataset?
A. Racf and RSA
B. LDAP and Racf
C. Roscoe and RSA
D. Panvelet and Roscoe
Answer: B

3. During warehouse process and architecture planning, which of the following are required inputs for an effective gap analysis of the operational source systems?
I.detailed logical models
II.locations of source data
III.detailed physical models
IV.business requirements document
A. I and III only
B. III and IV only
C. I, II, and IV only
D. I, III, and IV only
Answer: D

4. The performance scalability of SAS full table scans is being estimated. Which of the following metrics is appropriate for direct attached storage?
A. I/O per second
B. I/O latency per request
C. I/O request average size
D. I/O in megabytes per second
Answer: D

5. Usage success criteria have been defined for a data warehouse project. Which of the following metrics supports these criteria?
A. number of queries in a given time period
B. performance against a pre-warehouse baseline
C. number of gigabytes of data stored in the warehouse
D. amount of time between the close of business and warehouse refresh
Answer: A

6. A diagram of a logical entity-relationship model of a magazine subscription company is shown below:
Which of the following statements about this model is true?
A. Every sales region has several sales reps.
B. A package may be related to several subscriptions.
C. All magazines are included in at least one package.
D. A subscription may be related to several subscribers.
Answer: B

7. A data warehouse uses a relational database management system (RDBMS) for its core data repository. Bulk loading has been proposed as the method for loading larger RDBMS tables into the warehouse.
Which of the following must be considered when developing the bulk load routines?
I.indexes
II.join efficiency
III.integrity constraints
IV.representation of null values
A. I and II only
B. III and IV only
C. I, II, and III only
D. I, III, and IV only
Answer: D

8. According to the SAS Rapid Warehousing Methodology, which of the following are valid outputs from the Requirements Phase?
I.project plan
II.cost/benefit analysis
III.logical and physical models
IV.metadata exploitation, population, and update process
A. I and II only
B. I, II, and III only
C. I, II, and IV only
D. I, II, III, and IV
Answer: A


Download SAS Institute A00-204 Dumps

December 08 2009

SAS Institute A00-206 Dumps

sas warehouse technology exam

  • Exam Number/Code : A00-206
  • Exam Name : sas warehouse technology exam
  • Questions and Answers : 65 Q&As

Download Pass4sure SAS Institute A00-206 Dumps from the link below
Download CertifyMe SAS Institute A00-206 Dumps from the link below
Download Testking SAS Institute A00-206 Dumps from the link below


Download SAS Institute A00-206 Dumps


PrepKing.com SAS Institute A00-206 Sample Questions

Exam : SAS A00-206
Title : SAS Warehouse Technology Exam

1. Which statement is true about the Quality Knowledge Base (QKB) in the SAS Data Quality Solution?
A. The QKB is required by dfPower Studio applications, but not by the SAS Data Quality Server.
B. The QKB facilitates the sharing of source data between dfPower Studio applications and SAS ETL Studio.
C. The QKB is used to translate data as it is transferred between dfPower Studio applications and SAS ETL Studio.
D. The QKB facilitates the sharing of data quality rules between dfPower Studio applications and the SAS Data Quality Server.
Answer: D

2. In SAS Management Console, which components are required for promotion and replication?
A. Foundation Repository, Custom Repository and Project Repository
B. SAS Administration Server, SAS Source Server and SAS Target Server
C. SAS Replication Server, SAS Administration Server and SAS Workspace Server
D. SAS Workspace Server, SAS Stored Process Server and SAS/CONNECT Server
Answer: B

3. If the SAS ETL Studio Metadata Import Wizard cannot be used, how can metadata be captured from legacy systems using the Open Metadata API?
I.use the SAS XML Mapper
II.use the SAS METADATA procedure
III.use the SAS METAOPERATE procedure
IV.use a customized Java plug-in to SAS ETL Studio
A. I and III
B. I and IV
C. II and III
D. II and IV
Answer: D

4. Which statement is true about defining target table columns using the Target Designer in SAS ETL Studio?
A. Column metadata is imported from a data dictionary columns table.
B. Column metadata is linked to columns in the table from which they are selected.
C. Column metadata is independent of columns in the table from which they are selected.
D. Column metadata is synchronized with columns in the table from which they are selected by the Impact Analysis Wizard.
Answer: C

5. In SAS ETL Studio, what does a Transformation Template contain?
A. sources and/or targets
B. the process flow diagram for a job
C. a transformation object and the process flow diagram for a job
D. a transformation object and one or more drop zones for tables and/or transformations
Answer: D


Download SAS Institute A00-206 Dumps

December 08 2009

SAS Institute A00-211 Dumps

SAS Base Programming for SAS 9

  • Exam Number/Code : A00-211
  • Exam Name : SAS Base Programming for SAS 9
  • Questions and Answers : 140 Q&As

Download Pass4sure SAS Institute A00-211 Dumps from the link below
Download CertifyMe SAS Institute A00-211 Dumps from the link below
Download Testking SAS Institute A00-211 Dumps from the link below


Download SAS Institute A00-211 Dumps



PrepKing.com SAS Institute A00-211 Sample Questions

Exam : SAS A00-211
Title : SAS Base Programming for SAS (r) 9

1. What is the purpose of the END= option on the INFILE statement?
A.It identifies the last record read in a raw data file.
B.It identifies the last DATA step statement to be executed.
C.It identifies the length of the record that is being processed.
D.It moves the end of record marker to the length specified by the logical record length.
Answer: A

2. The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?
A.6
B.7
C.8
D.. (missing numeric)
Answer: B

3. Given the SAS data set SASUSER.HOUSES:
The following SAS program is submitted:
The following output is desired:
style price
CONDO $79,700
TWOSTORY $62,550
Which DEFINE statement completes the program and produces the desired output?
A.define style / width = 9;
B.define style / order width = 9;
C.define style / group width = 9;
D.define style / display width = 9;
Answer: C

4. Given the raw data file YEARAMT:
—-|—-10—|—-20—|—-30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile ‘yearamt’;
input year quantity;
totquantity = totquantity + quantity;
run;
What is the value of the variable TOTQUANTITY in the second observation?
A.0
B.1
C.3
D.. (missing numeric)
Answer: D

5. The following SAS program is submitted:
data work.flights;
destination = ‘CPH’;
select(destination);
when(‘LHR’) city = ‘London’;
when(‘FRA’) city = ‘Frankfurt’;
otherwise;
end;
run;
What are the length and value of the CITY variable?
A.length of 6, value of CPH
B.length of 9, value of CPH
C.length of 6, value of ‘ ‘ (missing character value)
D.length of 9, value of ‘ ‘ (missing character value)
Answer: C

6. Given the contents of the raw data file PRODUCT:
—-|—-10—|—-20—|—-30
24613 $25.31
The following SAS program is submitted:
data inventory; infile ‘product’; input idnum 5. @10 price; run;
What is the value of the PRICE variable?
A.25.31
B.$25.31
C.. (missing numeric value)
D.No value is stored.
Answer: C

7. Given the SAS data set ONE:
ONE
XY Z
1 A 27
1A 33
1 B45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
The following SAS program is submitted:
data two;
set one;
by x y;
if first.y;
run;
proc print data = two noobs;
run;
Which report is produced?
A.X Y Z
1 A 27
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
B.X Y Z
1 A 33
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
C.X Y Z
1 B 45
2 A 52
2 B 69
3 B 70
4 A 82
4 C 91
D.The PRINT procedure fails because the data set TWO is not created in the DATA step.
Answer: A

8. The following SAS program is submitted:
libname temp ‘SAS data library’;
data work.new;
set temp.jobs;
format newdate mmddyy10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2005.
What output is produced if April 15, 2005 falls on a Friday?
A.Obs newdate mdate ddate
1 04/15/2005 APR 6
B.Obs newdate mdate ddate
1 04/15/2005 4 6
C.Obs newdate mdate ddate
1 04/15/2005 APR 7
D.Obs newdate mdate ddate
1 04/15/2005 4 7
Answer: B


Download SAS Institute A00-211 Dumps

prepking

Tag Cloud

Adobe