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.
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?
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]
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?
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?
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?
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?
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?
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?
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.