Get New 2023 Valid Practice To your A00-231 Exam (Updated 265 Questions)
SAS Institute Systems A00-231 Exam Practice Test Questions Dumps Bundle!
To qualify for the exam, candidates need to have a solid understanding of SAS programming and a minimum of six months of practical experience. Candidates can choose to take the exam online or in a test center. The time limit for completing the exam is four hours, and the passing score is 70%.
NEW QUESTION # 99
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. Obsnewdate mdate ddate104/15/2005 APR 6
- B. Obs newdate mdate ddate104/15/2005 APR 7
- C. Obs newdate mdate ddate104/15/2005 4 6
- D. Obs newdate mdate ddate104/15/2005 4 7
Answer: C
NEW QUESTION # 100
Which step displays a listing of all the data sets in the WORK library?
- A. proc contents data=WORK _ALL_;run;
- B. proc contents lib=WORKrun;
- C. proc contents lib=WORK.all;run;
- D. proc contents data=WORK._all_;run;
Answer: D
NEW QUESTION # 101
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?
- A. REPORT.
- B. WORK
- C. SASUSER
- D. HOUSES
Answer: B
NEW QUESTION # 102
The following SAS program is submitted:
What will the data set WORK.TEST contain?
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: D
NEW QUESTION # 103
The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?
- A. the data portion of every data set in the SASUSER library
- B. the descriptor portion of the data set SASUSER.AIRPLANES only
- C. the data portion of the data set SASUSER.AIRPLANES only
- D. the descriptor portion of every data set in the SASUSER library
Answer: B
NEW QUESTION # 104
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;
What is the result?
- A. The value of the DESCRIPTION variable can not be determined.
- B. The value of the DESCRIPTION variable is Problems.
- C. The value of the DESCRIPTION variable is No Problems.
- D. The value of the DESCRIPTION variable is No Probl.
Answer: B
NEW QUESTION # 105
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
- A. proc print data = sasuser.houses; where price lt 60000 and price gt 100000; run;
- B. proc print data = sasuser.houses; where price lt 60000 or where price gt 100000; run;
- C. proc print data = sasuser.houses; where price lt 60000; where price gt 100000; run;
- D. proc print data = sasuser.houses; where price lt 60000 or price gt 100000; run;
Answer: D
NEW QUESTION # 106
The following SAS program is submitted:
How many raw data records are read during each iteration of the DATA step?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 107
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
- A. libname sasdata 'SAS-data-library';data sasdata.mydata;keep mydata;run;
- B. libname sasdata 'SAS-data-library';data sasdata.mydata;copy mydata;run;
- C. libname sasdata 'SAS-data-library';data sasdata.mydata;set mydata;run;
- D. libname sasdata 'SAS-data-library';data sasdata.mydata;save mydata;run;
Answer: C
NEW QUESTION # 108
The following SAS program is submitted:
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
Which one of the following is the value of the variable FIRST in the output data set?
- A. A
- B. Agatha
- C. C
- D. '' (missing character value)
Answer: A
NEW QUESTION # 109
Which ODS statement option terminates output being written to an HTML rile?
- A. CLOSE
- B. END
- C. STOP
- D. QUIT
Answer: A
NEW QUESTION # 110
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: C
NEW QUESTION # 111
The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?
- A. The program fails to execute due to errors.
- B. Neither variable JCODE nor JOBCODE is written to the output data set.
- C. The variable JOBCODE is written to the output data set.
- D. The variable JCODE is written to the output data set.
Answer: C
NEW QUESTION # 112
The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?
- A. a raw data file only
- B. a SAS data set named GROUP and a raw data file
- C. No output is generated as the program fails to execute due to errors.
- D. a SAS data set named GROUP only
Answer: B
NEW QUESTION # 113
The following SAS program is submitted:
data work.clients;
calls = 6;
do while (calls le 6);
calls + 1;
end;
run;
Which one of the following is the value of the variable CALLS in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION # 114
The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?
- A. the code contains a syntax error and does not execute.
- B. the date value 01011960
- C. the numeric value 0
- D. the character value "01Jan1960"
Answer: C
NEW QUESTION # 115
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. NOCROSSTAB
- C. LIST
- D. NOCOLS
Answer: A
NEW QUESTION # 116
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?
- A. format salary comma8.2 dollar8.2;
- B. format salary comma11.2;
- C. format salary dollar8.2;
- D. format salary dollar11.2;
Answer: D
NEW QUESTION # 117
There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:
What will be the value of NewVar when SAS writes the last observation?
- A. 0
- B. . (a missing value)
- C. 1
- D. 2
Answer: C
NEW QUESTION # 118
Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
- A. ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17
- B. ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112
- C. ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24
- D. ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17
Answer: A
NEW QUESTION # 119
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. (missing numeric value)
- C. 1
- D. 2
Answer: C
NEW QUESTION # 120
The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A. The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.
- B. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- C. The output contains only a list of the SAS data sets that are contained in the WORK library.
- D. The output displays only the contents of the SAS data sets that are contained in the WORK library.
Answer: A
NEW QUESTION # 121
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
- A. Option C
- B. Option A
- C. Option D
- D. Option B
Answer: A
NEW QUESTION # 122
The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
What is the value of the CITY variable?
- A. Copenh
- B. Copenhagen
- C. ''(missing character value)
- D. Other
Answer: D
NEW QUESTION # 123
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. 401 for PROC PRINT4500 for PROC MEANS
- B. 401 for PROC PRINT4501 for PROC MEANS
- C. 500 for PROC PRINT5000 for PROC MEANS
- D. 400 for PROC PRINT4500 for PROC MEANS
Answer: B
NEW QUESTION # 124
......
SASInstitute A00-231 exam is intended for individuals who have a basic understanding of SAS programming concepts and techniques. It is ideal for those who want to advance their careers in data analysis, business intelligence, or programming. A00-231 exam covers a broad range of topics, including data step programming, SQL programming, macro programming, and SAS procedures.
Fully Updated Dumps PDF - Latest A00-231 Exam Questions and Answers: https://www.testsdumps.com/A00-231_real-exam-dumps.html
Updated A00-231 PDF for the A00-231 Tests Free Updated Today: https://drive.google.com/open?id=1leq6faUHdszz23NHXi5OxrIkvS3ibPlI
