A00-231 Study Guide: Latest [Jun 07, 2024] Realistic Verified A00-231 Dumps
A00-231 Questions & Practice Test are Available On-Demand
SASInstitute A00-231 certification exam is ideal for professionals looking to enhance their knowledge and skills in SAS programming. Professionals who work in fields like data analysis, statistics, data management, and data science can benefit from this certification. SAS 9.4 Base Programming - Performance-based exam certification is recognized worldwide, making it a valuable asset for professionals who want to improve their career prospects.
NEW QUESTION # 80
The following SAS program is submitted:
data work.report;
set work.sales_info;
if qtr(sales_date) ge 3;
run;
The SAS data set WORK.SALES_INFO has one observation for each month in the year 2000 and the variable SALES_DATE which contains a SAS date value for each of the twelve months.
How many of the original twelve observations in WORK.SALES_INFO are written to the WORK.REPORT data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 81
The following output is created by the FREQUENCY procedure:
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;
- A. tables region*product;
- B. tables region,product
- C. tables region product;
- D. tables region/product;
Answer: A
NEW QUESTION # 82
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:
Which statement is true?
- A. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
- B. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.
- C. The by statement in the DATA step causes a syntax error.
- D. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
Answer: A
NEW QUESTION # 83
The following SAS program is submitted:
What is produced as output?
- A. A text file named test.cvs that can only be opened in a text editor.
- B. A text file named test.cvs that can be opened in Excel or in any text editor.
- C. A file named test.cvs that can only be opened in Excel.
- D. A file named test.cvs that can only be opened by SAS.
Answer: B
NEW QUESTION # 84
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement.
Which statement regarding this variable is true?
- A. It is assigned a value of missing when the data step begins execution.
- B. It is assigned a value 0 at compile time.
- C. It is assigned a value of missing at compile time.
- D. It is assigned a value 0 when the data step begins execution.
Answer: B
NEW QUESTION # 85
The following SAS program is submitted:
What is the value of the variable Diff?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 86
The following SAS program is submitted once:
Which procedure output will appear in test.html?
- A. Only the FREQ procedure output
- B. Only the PRINT procedure output
- C. Both the PRINT procedure and FREQ procedure output
- D. No procedure output due to syntax errors
Answer: D
NEW QUESTION # 87
Scenario:
Open the existing program, program44.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram44incert\programs. This program is intended to:
O Create a new data set using thecert.input44set as input
O Drop variables:bp_status, weight_status, andsmoking _status.
* Create a new column,chol_status, based on the following values of cholesterol:
less than 200: "Safe"
200-239: "High - Borderline"
240 and higher: "High" oShould not calculatechol_statusfor missing cholesterol values There are multiple errors in the program.
These may be syntax errors, logic errors, or problems with the program structure.
Logic errors might not produce messages in the log, but will cause the program to produce results different than intended.
Correct the errors, run the program, and then use the results to answer the next 3 questions.
How many variables are in thework. outdata set? Enter your numeric answer in the space below:
Answer:
Explanation:
5
NEW QUESTION # 88
Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session:
data sasuser.one;
x=1;
y=27;
output one; run;
Select one:
- A. The data set Sasuser.One is created with 2 variables and 3 observations.
- B. The data set Sasuser.One is created with 2 variables and 1 observation.
- C. The data set Sasuser.One is created with 2 variables and 0 observations.
- D. The data set Work.One is created with 2 variables and 1 observation.
Answer: C
NEW QUESTION # 89
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country = City!!', '!!'England';
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
- A. Ipswich, England
- B. Ipswich, 'England'
- C. Ipswic h, England
- D. Ipswich!!
Answer: A
NEW QUESTION # 90
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?
- A. proc print data=MYXLS.NORTH;run;
- B. proc print data=MYXLS.'NORTH$'n;run;
- C. proc print data=MYXLS.NORTH$;run;
- D. proc print data=MYXLS.'NORTH'e;run;
Answer: B
NEW QUESTION # 91
The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:
What is the length of the Name variable in the data set WORK STAFF_UPDATE?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 92
Given the SAS data set WORK.ORDERS:
The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?
- A. ship_note=catx('','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
- B. ship_note=catx('','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
- C. ship_note=catx('','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
- D. ship_note=catx('','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
Answer: A
NEW QUESTION # 93
The SAS data set BANKS is listed below:
BANKS
name rate
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
The following SAS program is submitted:
data newbank;
do year = 1 to 3;
set banks;
capital + 5000;
end;
run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?
- A. 3 observations and 3 variables
- B. 0 observations and 0 variables
- C. 9 observations and 2 variables
- D. 1 observations and 4 variables
Answer: D
NEW QUESTION # 94
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100); run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500); run;
How many observations are processed by each procedure?
- A. 500 for PROC PRINT5000 for PROC MEANS
- B. 400 for PROC PRINT4500 for PROC MEANS
- C. 401 for PROC PRINT4500 for PROC MEANS
- D. 401 for PROC PRINT4501 for PROC MEANS
Answer: D
NEW QUESTION # 95
Which one of the following is true of the SUM statement in a SAS DATA step program?
- A. It adds the value of an expression to an accumulator variable and ignores missing values.
- B. It is only valid in conjunction with a SUM function.
- C. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
- D. It is not valid with the SET, MERGE and UPDATE statements.
Answer: A
NEW QUESTION # 96
Given the SAS data set AGES:
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 97
Which statement is true concerning the SAS automatic variable _ERROR_?
- A. It cannot be used in an if/then condition.
- B. It can be put into a keep statement or keep= option.
- C. It cannot be used in an assignment statement.
- D. It is automatically dropped.
Answer: D
NEW QUESTION # 98
Given the contents of the raw data file 'EMPLOYEE.TXT'
Which SAS informat correctly completes the program?
- A. ddmmyy10
- B. mondayyr10
- C. date9
- D. mmddyy10
Answer: D
NEW QUESTION # 99
The following SAS program is submitted:
What is the value of the variable var1?
- A. 0
- B. '1/15/1960'
- C. 1
- D. 2
Answer: D
NEW QUESTION # 100
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
* Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
* Write only observations that are in both data sets to a
new data set named results.match08.
* Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
* Exclude all variables that begin with
"ex" from results.nomatch08.
How many variables (columns) are in results.match08
Answer:
Explanation:
117
Explanation:
proc sort data=cert.input08b out=work.input08b;
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
SAS code that could be used to solve this project:
proc
sort data=cert.input08a out=work.input08a;
by ID;
run:
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 117
NEW QUESTION # 101
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
- A. No output is generated
Answer: A
NEW QUESTION # 102
Which one of the following statements is true regarding the name of a SAS array?
- A. It can be the same as the name of a variable in the data set.
- B. It exists only for the duration of the DATA step.
- C. It is saved with the data set.
- D. It can be used in procedures.
Answer: B
NEW QUESTION # 103
Given the following SAS log entry:
What caused the error?
- A. A semi-colon is missing on the DATALINES statement.
- B. The INPUT statement should be after the DATALINES statement.
- C. Character data must be specified in quotes.
- D. The CANCEL option is required with DATALINES.
Answer: A
NEW QUESTION # 104
......
Valid A00-231 Exam Dumps Ensure you a HIGH SCORE: https://www.examslabs.com/SASInstitute/SAS-Institute-Systems/best-A00-231-exam-dumps.html
Pass A00-231 Exam with Latest Questions: https://drive.google.com/open?id=1_wThvFZc1oOwZOvDbdaF516nkC22azgu