ExamDumpster

Free A00-231 sample questions

Try these free A00-231 sample questions, each with the answer and an explanation. Topics include SAS date values, sorting and debugging programs. Run the code yourself in SAS when you can, since part of the exam is hands-on.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose 2

A programmer is developing a reusable program that processes monthly data. The input dataset name changes each month (e.g., `data_jan`, `data_feb`). To make the program flexible, the programmer wants to use a macro variable `&Month` to specify the dataset name. Which statements correctly create a macro variable from a DATA step variable and then use it in a subsequent DATA step? (Select TWO)

Question 2Choose one

A program designed to calculate compound interest runs without any syntax errors. However, the final interest amount is always equal to the interest from the very last period, not the accumulated total. The programmer suspects a logic error in the `DO` loop. Review the code below: ```sas data WORK.COMPOUND; Principal = 1000; Rate = 0.05; do Year = 1 to 10; Interest = Principal * Rate; Principal = Principal + Interest; end; run; ``` What is the primary logic error causing the incorrect final `Principal` value in the output dataset?

Question 3Choose one

A clinical research organization is consolidating patient data from three sources: - `DEMO`: Contains `PatientID` and demographic variables (e.g., `Age`, `Gender`). This is the master list of all patients. - `VISITS`: Contains `PatientID`, `VisitDate`, and `VisitType`. A patient can have multiple visits. - `LABS`: Contains `PatientID`, `TestDate`, and `Result`. A patient may not have lab results for every visit. The goal is to create a final dataset, `ANALYSIS`, that contains one row for each visit a patient had, including their demographic information and any lab results that match the `PatientID`. Which sequence of steps is the most robust and accurate method to achieve this? flowchart TD A[DEMO Data] --> C{Sort DEMO} B[VISITS Data] --> D{Sort VISITS} C & D --> E(Merge DEMO and VISITS) F[LABS Data] --> G{Sort LABS} E & G --> H(Merge with LABS) H --> I[Final ANALYSIS Dataset]

Question 4Choose one

A dataset contains a character variable `LoanDate_char` with values like '2024-03-15'. To perform date calculations, it must be converted to a numeric SAS date variable named `LoanDate_num`. Which assignment statement correctly performs this conversion?

Question 5Choose one

A project manager wants a simple report from the `WORK.TASKS` dataset, which contains `ProjectID`, `TaskName`, and `HoursSpent`. The report must list all tasks for each project and provide a total of `HoursSpent` for each project. Which `PROC PRINT` code will generate this report?

Question 6Choose one

A programmer needs to iterate through a dataset of transactions and stop processing as soon as a transaction with a `Fraud_Score` greater than 0.95 is found. The dataset is not sorted by `Fraud_Score`. Which type of `DO` loop is most appropriate for this task?

Question 7Choose one

While attempting to import a text file, a programmer receives the following note in the SAS log: `NOTE: Invalid data for CustomerID in line 15 23-30.` What is the most likely cause of this note?

Question 8Choose one

A programmer has two datasets, `Q1_SALES` and `Q2_SALES`, with identical variable structures. They want to create a single dataset, `HALFYEAR_SALES`, by stacking `Q2_SALES` onto the end of `Q1_SALES`. Which of the following is the most direct and efficient method for this task in a DATA step?

Question 9Choose one

An analyst needs to create a summary dataset called `SUMMARY_STATS` that contains the number of observations (N), mean, and standard deviation for the `Income` variable, grouped by `Region` and `JobType`. Which `PROC MEANS` code will produce the required output dataset?

Question 10Choose one

A DATA step is processing a sorted dataset using a `BY` statement (`BY CustomerID;`). The goal is to identify the first transaction for each customer. How are the special, temporary variables `FIRST.CustomerID` and `LAST.CustomerID` valued during the processing of a group of observations for a single customer? flowchart TD Start --> Read_Obs1[Read Obs 1 for Cust A] Read_Obs1 --> Set_First[FIRST.CustomerID = 1] Set_First --> Read_Obs2[Read Obs 2 for Cust A] Read_Obs2 --> Set_Mid[FIRST.CustomerID = 0] Set_Mid --> Read_Obs3[Read Obs 3 for Cust A] Read_Obs3 --> Set_Last[LAST.CustomerID = 1] Set_Last --> Read_Obs4[Read Obs 1 for Cust B] Read_Obs4 --> Reset_First[FIRST.CustomerID = 1] Reset_First --> End

10 more free samples are waiting

Create a free account to unlock the whole A00-231 sample bank, or get full access to all 487 practice questions in the simulator.

Create account