Ultimate Guide to Prepare Free SASInstitute A00-231 Exam Questions and Answer
Pass SASInstitute A00-231 Tests Engine pdf - All Free Dumps
NEW QUESTION # 54
The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?
- A. . (missing numeric value)
- B. January 1st
- C. The value can not be determined as the program fails to execute due to errors
- D. 01012000
Answer: C
NEW QUESTION # 55
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A. Fail
- B. Pass
- C. .(missing numeric value)
- D. 50.5
Answer: D
NEW QUESTION # 56
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
- A. 0
- B. 1
- C. . (missing numeric value)
- D. The program fails to execute due to errors.
Answer: A
NEW QUESTION # 57
The following SAS program is submitted:
Which output is correct?
- A. yearamount i qtr 2017 33637.50 65
- B. yearamount i qtr 2016 33637.50 55
- C. yearamount i qtr 2016 33637.50 64
- D. yearamount i qtr 2016 33637.50 65
Answer: D
NEW QUESTION # 58
Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- A. where Age not between 15 and 16 then Group=1; else Group=2;
- B. both A or C will work.
- C. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
- D. if Age not in(15,16) then Group=1; else Group=2;
Answer: D
NEW QUESTION # 59
Given the SAS data set WORK.THREE:
The following SAS program is submitted:
What is the result?
- A. Data set SASUSER.ONE has 2 observations Data set SASUSER.TWO has 2 observations Data set WORK.OTHER has 1 observations
- B. No data sets are output. The DATA step fails execution due to syntax errors.
- C. Data set SASUSER.ONE has 2 observations Data set SASUSER.TWO has 2 observations Data set WORK.OTHER has 5 observations
- D. Data set SASUSER.ONE has 5 observations Data set SASUSER.TWO has 5 observations Data set WORK.OTHER has 3observations
Answer: D
NEW QUESTION # 60
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
What value will SAS assign to Total?
- A. 1.2
- B. 4.8
- C. (missing value)
- D. 1.6
Answer: D
NEW QUESTION # 61
The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 ='Pre-Teen'
13-high = 'Teen';
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification:
Which statement below was modified or added to generate the results above:
- A. proc means data=SASHELP.CLASS maxdec=1 ;
- B. proc means data=SASHELP.CLASS min max mean maxdec=1;
- C. var Height / nobs min max mean maxdec=1;
- D. output nobs min max mean maxdec=1;
Answer: B
NEW QUESTION # 62
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
- A. A LIBNAME statement for the libref TEMP only must be submitted.
- B. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
- C. A LIBNAME statement for the libref SASUSER only must be submitted.
- D. No LIBNAME statement needs to be submitted.
Answer: A
NEW QUESTION # 63
Scenario:
This project will use data set cert.input13. At any time, you may
save your program as program13 in cert\programs.
This data set contains 1001 observations and 2 variables:
* Date1, a numeric variable representing an unformatted
SAS date value. Example: 12001.
* Charnum, a character variable representing a monetary
amount. Example: $50,000.
Write a SAS program that will:
* Save the new data set as results.output13.
* Create a new variable Chdate that converts
the datel variable to a character variable that is in the
format ddmonyyyy, such as 11NOV1992.
* Create a new variable num1 that converts
the Charnum variable to a numeric variable.
What is the average (mean) of the num1 variable for the entire data set?
Enter your numeric answer in the space below (Round your answer to the nearest integer).
Answer:
Explanation:
51763
Explanation:
data results.output13;
set cert.input13;
Chdate=put(date 1,date9.);
num 1=input(Charnum,dollar7.);
run;
proc means data=results.output13;
var num 1;
run;
NEW QUESTION # 64
Given the SAS data set WORK.PRODUCTS:
How many observations does the WORK.OUTDOOR data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 65
Given the contents of the raw data file TYPECOLOR:
----I----10---I----20---I----30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile 'typecolor';
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?
- A. No values are stored for the TYPE and COLOR variables.
- B. type colordaisyyellow" "(missing character value)
- C. type colordaisygreen
- D. type colordaisy ellow
Answer: D
NEW QUESTION # 66
Given the following SAS data set WORK.TOYS:
Product Group Price
--------- ----------- -----
Cards Indoors 9.99
Marbles Indoors 8.99
Drum Instruments 12.99
Hula-Hoop Outdoors 12.99
Ball Outdoors 8.49
The following SAS program is submitted:
data WORK.GROUPS;
set WORK.TOYS;
if Group="Outdoors" then Price_Gp="C";
if Price ge 12.99 then Price_Gp="A";
else if Price ge 8.99 then Price_Gp="B";
run;
What will be the value of Price_Gp for Hula-Hoop and Ball? Select one:
- A. Hula-Hoop: 'A', Ball: ' ' (missing value)
- B. Hula-Hoop: 'C', Ball: ' ' (missing value)
- C. Hula-Hoop: 'A', Ball: 'C'
- D. Hula-Hoop: 'C', Ball: 'C'
Answer: C
NEW QUESTION # 67
The following SAS DATA step executes on Monday, April 25, 2000:
data newstaff;
set staff;
start_date = today();
run;
Which one of the following is the value of the variable START_DATE in the output data set?
- A. the numeric value 14725, representing the SAS date for April 25, 2000
- B. the numeric value 04252000, representing the SAS date for April 25, 2000
- C. a character string with the value '04/25/2000'
- D. a character string with the value 'Monday, April 25, 2000'
Answer: A
NEW QUESTION # 68
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: B
NEW QUESTION # 69
The following SAS program is submitted:
data work.test;
type='SQL';
if type='SAS' then description='SAS Program';
else description='other'; length description 8;
run;
What occurs when the program is submitted?
Select one:
- A. The variable Description is created as a 5-byte character variable and is assigned the value 'SAS P' in the DATA step.
- B. The variable Description is created as an 11-byte character variable and the DATA step fails due to errors.
- C. The variable Description is created as an 8-byte character variable and is assigned the value 'SAS Prog' in the DATA step.
- D. The variable Description is created as an 11-byte character variable and is assigned the value 'SAS program' in the DATA step.
Answer: B
NEW QUESTION # 70
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
- A. LocalFee has format of 9. and CountryFee has a format of 7.
- B. The data step fails execution; there is no format for LocalFee.
- C. Both LocalFee and CountryFee have a format of percent7.2
- D. LocalFee has format of 9. and CountryFee has a format of percent7.2
Answer: C
NEW QUESTION # 71
Which one of the following SAS statements renames two variables?
- A. set work.dept1work.dept2(rename = (jcode = jobcodesal = salary));
- B. set work.dept1work.dept2(rename = jcode = jobcodesal = salary);
- C. set work.dept1work.dept2(rename = (jcode jobcode)(sal salary));
- D. set work.dept1work.dept2(rename = (jcode = jobcode)(sal = salary));
Answer: A
NEW QUESTION # 72
The following SAS program is submitted:
What is produced as output?
- A. A text file named test.cvs that can be opened in Excel or in any text editor.
- B. A file named test.cvs that can only be opened by SAS.
- C. A file named test.cvs that can only be opened in Excel.
- D. A text file named test.cvs that can only be opened in a text editor.
Answer: A
NEW QUESTION # 73
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 named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?
- A. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
- B. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.
- C. The BY statement in the DATA step causes a syntax error.
- D. The statement payroll + wagerate; in the DATA step causes a syntax error.
Answer: A
NEW QUESTION # 74
......
Online Exam Practice Tests with detailed explanations!: https://actualtests.testinsides.top/A00-231-dumps-review.html