SAS A00-233

[Pages:13]SAS A00-233

SAS BASE PROGRAMMING CERTIFICATION QUESTIONS & ANSWERS

Exam Summary ? Syllabus ? Questions

A00-233

SAS Base Programming Specialist Delta 18-22 Questions Exam ? 725 / 1000 Cut Score ? Duration of 75 minutes



A00-233 Exam Questions

Table of Contents

Know Your A00-233 Certification Well: ......................... 2 A00-233 SAS Base Programming Certification Details: 2 A00-233 Syllabus: ......................................................... 3

Access and Create Data Structures ............................................................................... 3 Manage Data ............................................................................................................................... 3 Error Handling............................................................................................................................ 5 Generate Reports and Output........................................................................................... 5

SAS A00-233 Sample Questions: ................................. 6

Study Guide to Crack SAS Base Programming A00-233 Exam: .......................................................................... 12

SAS Base Programming Certification Practice Exam

1

A00-233 Exam Questions

Know Your A00-233 Certification Well:

The A00-233 is best suitable for candidates who want to gain knowledge in the SAS Foundation Tools. Before you start your A00-233 preparation you may struggle to get all the crucial SAS Base Programming materials like A00-233 syllabus, sample questions, study guide.

But don't worry the A00-233 PDF is here to help you prepare in a stress free manner.

The PDF is a combination of all your queries like-

? What is in the A00-233 syllabus? ? How many questions are there in the A00-233 exam? ? Which Practice test would help me to pass the A00-233 exam at the first

attempt? Passing the A00-233 exam makes you SAS Base Programming Specialist Delta. Having the SAS Base Programming certification opens multiple opportunities for you. You can grab a new job, get a higher salary or simply get recognition within your current organization.

A00-233 SAS Base Programming Certification Details:

Exam Name

SAS Certified Specialist - Base Programming Using SAS 9.4 Delta

Exam Code

A00-233

Exam Duration 75 minutes

Exam Questions 18-22

Passing Score

725 / 1000

Exam Price

$180 (USD)

Books / Training

SAS Programming 1: Essentials SAS Programming 2: Data Manipulation Techniques SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4

Exam Registration Pearson VUE

Sample Questions SAS Base Programming Certification Sample Question

Practice Exam

SAS Base Programming Certification Practice Exam

SAS Base Programming Certification Practice Exam

2

A00-233 Exam Questions

A00-233 Syllabus:

Objective

Details

Access and Create Data Structures

Create temporary and permanent SAS data sets.

- Use a DATA SAS data set.

step

to

create

a

SAS

data

set

from

an

existing

Investigate SAS data libraries using base SAS utility procedures.

- Use a LIBNAME statement to assign a library reference name to a SAS library. - Investigate a library programmatically using the CONTENTS procedure.

- Access SAS data sets with the SET statement. - Use PROC IMPORT to access non-SAS data sources.

Access data.

? Read delimited and Microsoft Excel (.xlsx) files with PROC IMPORT.

? Use PROC IMPORT statement options (OUT=, DBMS=, REPLACE)

? Use the GUESSINGROWS statement

- Use the SAS/ACCESS XLSX engine to read a Microsoft Excel workbook.xlsx file.

Combine SAS data sets.

- Concatenate data sets. - Merge data sets one-to-one. - Merge data sets one-to-many.

Create and manipulate SAS date values.

- Explain how SAS stores date and time values. - Use SAS informats to read common date and time expressions. - Use SAS date and time formats to specify how the values are displayed.

Control which - Use the WHERE statement in the DATA step to select

observations and observations to be processed.

variables in a SAS - Subset variables to be output by using the DROP and KEEP

data set are

statements.

processed and - Use the DROP= and KEEP= data set options to specify

output.

columns to be processed and/or output.

Manage Data

Sort observations in a SAS data set.

- Use the SORT Procedure to re-order observations in place output to a new dataset with the OUT= option. - Remove duplicate observations with the SORT Procedure.

or

SAS Base Programming Certification Practice Exam

3

A00-233 Exam Questions

Objective

Details

Conditionally execute SAS statements.

- Use IF-THEN/ELSE statements to process data conditionally. - Use DO and END statements to execute multiple statements conditionally.

Use assignment statements in the DATA step.

-

Create Assign Assign Assign

new variables and assign a value. a new value to an existing variable. the value of an expression to a variable. a constant date value to a variable.

Modify variable - Change the names of variables by using the RENAME= data

attributes using set option.

options and

- Use LABEL and FORMAT statements to modify attributes in a

statements in the DATA step.

DATA step.

- Define the length of a variable using the LENGTH statement.

Accumulate sub- - Use the BY statement to aggregate by subgroups.

totals and totals - Use first. and last. processing to identify where groups begin

using DATA step and end.

statements.

- Use the RETAIN and SUM statements.

- Use SAS functions such as SCAN, SUBSTR, TRIM, UPCASE, and LOWCASE to perform tasks such as the tasks shown below.

? Replace the contents of a character value.

? Trim trailing blanks from a character value.

Use SAS functions to manipulate

? Search a character value and extract a portion of the value.

character data,

? Convert a character value to upper or lowercase.

numeric data, - Use SAS numeric functions such as SUM, MEAN, RAND,

and SAS date values.

SMALLEST, LARGEST, ROUND, and INT. - Create SAS date values by using the functions MDY, TODAY,

DATE, and TIME. - Extract the month, year, and interval from a SAS date value by using the functions YEAR, QTR, MONTH, and DAY. - Perform calculations with date and datetime values and time intervals by using the functions INTCK, INTNX, DATDIF and YRDIF.

Utcnvoheusarem csroaSaen.AcrvitSceerraftundndactvtaiioctneos -v-v-toaaEUUllcxuusshpeeeealssattrhhaibtnoeecetttnIPehwNuUreePmTveaUaenfuTlurutdinofceaucmsvttn.aiaacolttntuiiycoetpnsoce.otseno.xvepexlripcsiiltoiclynitlctyhoanctovneSvrAteSrntuucmsheeasrritacocdtceaortnadvavetaratlues

- Explain how iterative DO loops function.

Process data using DO LOOPS.

- Use DO loops to eliminate redundant code and to perform repetitive calculations. - Use conditional DO loops.

- Use nested DO loops.

SAS Base Programming Certification Practice Exam

4

A00-233 Exam Questions

Objective

Details

Restructure SAS data sets with PROC TRANSPOSE.

- Select variables to transpose with the VAR statement. - Rename transposed variables with the ID statement. - Process data within groups using the BY statement. - Use PROC TRANSPOSE options (OUT=, PREFIX= and NAME=).

Use macro

variables to

- Create macro variables with the %LET statement

simplify program - Use macro variables within SAS programs.

maintenance.

Identify and resolve programming logic errors.

Recognize and correct syntax errors.

Error Handling

- Use the PUTLOG Statement in the Data Step to help identify logic errors. - Use PUTLOG to write the value of a variable, formatted values, or to write values of all variables. - Use PUTLOG with Conditional logic. - Use temporary variables N and ERROR to debug a DATA step.

- Identify the characteristics of SAS statements. - Define SAS syntax rules including the typical types of syntax errors such as misspelled keywords, unmatched quotation marks, missing semicolons, and invalid options. - Use the log to help diagnose syntax errors in a given program.

Generate Reports and Output

- Modify the default behavior of PROC PRINT by adding statements and options such as

Generate list reports using the PRINT procedure.

? use the VAR statement to select and order variables. ? calculate totals with a SUM statement. ? select observations with a WHERE statement.

? use the ID statement to identify observations.

? use the BY statement to process groups.

- Produce one-way and two-way frequency tables with the FREQ

procedure.

Generate

- Enhance frequency tables with options (NLEVELS, ORDER=).

summary reports - Use PROC FREQ to validate data in a SAS data set.

and frequency - Calculate summary statistics and multilevel summaries using

tables using base the MEANS procedure

SAS procedures. - Enhance summary tables with options.

- Identify extreme and missing values with the UNIVARIATE

procedure.

Enhance reports system userdefined formats, titles, footnotes

- Use PROC FORMAT to define custom formats.

? VALUE statement ? CNTLIN= option

SAS Base Programming Certification Practice Exam

5

A00-233 Exam Questions

Objective

Details

and SAS System - Use the LABEL statement to define descriptive column reporting options. headings.

- Control the use of column headings with the LABEL and SPLIT=options in Proc Print output.

Generate reports using ODS statements.

- Identify the Output Delivery System destinations. - Create HTML, PDF, RTF, and files with ODS statements. - Use the STYLE=option to specify a style template. - Create files that can be viewed in Microsoft Excel.

Export data

- Create a simple raw data file by using the EXPORT procedure as an alternative to the DATA step. - Export data to Microsoft Excel using the SAS/ACCESS XLSX engine.

SAS A00-233 Sample Questions:

Question: 1

This project will use the data set sashelp.shoes.

Write a SAS program that will: > Read sashelp.shoes as input. > Create a new SAS data set, work.shoerange. > Create a new character variable SalesRange that will be used to categorize the observations into three groups. > Set the value of SalesRange to the following: - Lower when Sales are less than $100,000. - Middle when Sales are between $100,000 and $200,000, inclusively. - Upper when Sales are above $200,000. Run the program, then use additional SAS procedures to answer the following questions: What is the mean value of observations in the "Middle" group? Round your answer to the nearest whole number. Solution: 135127

Determine whether the given solution is correct?

a) Incorrect b) Correct

Answer: b

SAS Base Programming Certification Practice Exam

6

A00-233 Exam Questions

Question: 2

This project will work with the following program:

data work.lowchol work.highchol; set sashelp.heart; if cholesterol lt 200 output work.lowchol; if cholesterol ge 200 output work.highchol; if cholesterol is missing output work.misschol; run; This program is intended to: - Divide the observations of sashelp.heart into three data sets, work.highchol, work.lowchol, and work.misschol - Only observations with cholesterol below 200 should be in the work.lowchol data set. - Only Observations with cholesterol that is 200 and above should be in the work.highchol data set. - Observations with missing cholesterol values should only be in the work.misschol data set. Fix the errors in the above program. There may be multiple errors in the program. Errors may be syntax errors, program structure errors, or logic errors. In the case of logic errors, the program may not produce an error in the log. After fixing all of the errors in the program, answer the following questions: How many observations are in the work.highchol data set?

Solution: 3652

Determine whether the given solution is correct?

a) Incorrect b) Correct

Answer: b

Question: 3

The following SAS program is submitted:

data WORK.TEMP; Char1='0123456789'; Char2=substr(Char1,3,4); run;

What is the value of Char2?

a) 23 b) 34 c) 345 d) 2345

Answer: d

SAS Base Programming Certification Practice Exam

7

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download