Try Free and Start Using Realistic Verified A00-231 Dumps Instantly
A00-231 Actual Questions - Instant Download 265 Questions
NEW QUESTION # 61
The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005.
What output is produced if April 15, 2005 falls on a Friday?
- A. Obs newdate mdate ddate104/15/2005 4 7
- B. Obs newdate mdate ddate104/15/2005 4 6
- C. Obsnewdate mdate ddate104/15/2005 APR 6
- D. Obs newdate mdate ddate104/15/2005 APR 7
Answer: B
NEW QUESTION # 62
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 min max mean maxdec=1;
- B. var Height / nobs min max mean maxdec=1;
- C. output nobs min max mean maxdec=1;
- D. proc means data=SASHELP.CLASS maxdec=1 ;
Answer: A
NEW QUESTION # 63
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 64
The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?
- A. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dsd = ','; put idnum sales_date : mmddyy10.; run;
- B. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;
- C. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dlm = ','; run;
- D. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;
Answer: B
NEW QUESTION # 65
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 # 66
The following SAS program is submitted:
What is the value of the variable Diff?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 67
When SAS encounters a data when reading from a raw data file, which action will occur?
- A. SAS will write a WARNING message to the SAS log and suspend execution.
- B. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
- C. SAS will write a NOTE to the SAS log and continue execution.
- D. SAS will write an ERROR message to the SAS log and suspend execution.
Answer: B
NEW QUESTION # 68
The following SAS program is submitted:
What will the data set WORK.TEST contain?
- A. Option C
- B. Option D
- C. Option A
- D. Option B
Answer: C
NEW QUESTION # 69
Given the contents of the raw data file TYPECOLOR.DAT:
The following SAS program is submitted:
What are the values of the variables Type and Color?
- A. Type=daisy, Color=yellow
- B. Type=daisy, Color=
- C. Type=daisy, Color=w
- D. Type=daisy, Color=daisyyellow
Answer: B
NEW QUESTION # 70
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = 'Jan' then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
- A. keep = product, sales;
- B. keep product sales;
- C. keep product, sales;
- D. keep = (product sales);
Answer: B
NEW QUESTION # 71
The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?
- A. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
- B. The program fails execution due to syntax errors.
- C. The program executes with warnings and creates the WORK.TOTALSALES data set.
- D. The program fails execution due to data errors.
Answer: B
NEW QUESTION # 72
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A. Option C
- B. Option D
- C. Option A
- D. Option B
Answer: A
NEW QUESTION # 73
The following SAS program is submitted:
libname rawdata1 'location of SAS data library';
filename rawdata2 'location of raw data file';
data work.testdata;
infile
input sales1 sales2;
run;
Which one of the following is needed to complete the program correctly?
- A. 'rawdata2'
- B. 'rawdata1'
- C. rawdata1
- D. rawdata2
Answer: D
NEW QUESTION # 74
The following SAS program is submitted:
If the value for the Alumcode is: ALUM2, what is the value of the variable Description?
- A. Unknown
- B. GRAD LEVEL
- C. '' (missing character value)
- D. Grad Level
Answer: D
NEW QUESTION # 75
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 76
The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?
- A. CROSSLIST
- B. NOCOLS
- C. LIST
- D. NOCROSSTAB
Answer: A
NEW QUESTION # 77
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then'
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?
- A. 0
- B. 1
- C. (missing numeric value)
- D. 2
Answer: B
NEW QUESTION # 78
The following SAS program is submitted;
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
- A. Russia
- B. Italy
- C. 0
- D. 1
Answer: D
NEW QUESTION # 79
The following SAS program is submitted:
data one;
date = '04juI2005'd;
format date weekdate.; run;
proc print data = one; run;
What output is generated?
- A. Obs date 1 July4, 2005
- B. Obs date 1 Monday, July 4, 2005
- C. Obs date 1 Monday, 07/04/2005
- D. Obs date 1 04Jul2005
Answer: B
NEW QUESTION # 80
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 at compile time.
- B. It is assigned a value 0 at compile time.
- C. It is assigned a value of missing when the data step begins execution.
- D. It is assigned a value 0 when the data step begins execution.
Answer: B
NEW QUESTION # 81
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
- A. Option C
- B. Option D
- C. Option A
- D. Option B
Answer: A
NEW QUESTION # 82
The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
- A. 0.001
- B. 0
- C. 1
- D. . (missing numeric value)
Answer: D
NEW QUESTION # 83
The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
- A. norow nocol
- B. norowcount nocolcount
- C. nocounts
- D. freq percent
Answer: A
NEW QUESTION # 84
Given the following raw data records:
The following output is desired:
Which SAS program correctly reads in the raw data?
- A. Option C
- B. Option A
- C. Option D
- D. Option B
Answer: C
NEW QUESTION # 85
This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?
- A. variable 1: Department variable 2: Department
- B. variable 1: Department variable 2: Gender
- C. variable 1: Gender variable 2: Department
- D. variable 1: Gender variable 2: Gender
Answer: D
NEW QUESTION # 86
......
Download Free Latest Exam A00-231 Certified Sample Questions: https://www.examcollectionpass.com/SASInstitute/A00-231-practice-exam-dumps.html
Prepare for your exam certification with our A00-231 Certified SASInstitute: https://drive.google.com/open?id=1qRJFaMdgyFegNRA5zUaBbsZVC1ftOQr3