2024年最新ののSASInstitute A00-231問題集PDFA00-231最速合格したいならここ
A00-231練習試験問題集で99%合格率SASInstitute試験合格させます
SASInstitute A00-231試験は挑戦的な資格であり、受験前に十分な準備が必要です。SASInstituteは、受験者が試験の準備をするためのトレーニングコース、学習教材、模擬試験を提供しています。さらに、受験者はオンラインコミュニティやディスカッションフォーラムに参加して、他のSASプロフェッショナルと交流し、彼らの経験から学ぶことができます。
質問 # 75
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
正解：D
質問 # 76
The following SAS program is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?
- A. The length of the variable JOBCODE is 5.
- B. The length of the variable JOBCODE is 3.
- C. The program fails to execute due to errors.
- D. The length of the variable JOSBODE is 12.
正解：A
質問 # 77
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. 400 for PROC PRINT4500 for PROC MEANS
- C. 401 for PROC PRINT4501 for PROC MEANS
- D. 500 for PROC PRINT5000 for PROC MEANS
正解：C
質問 # 78
The following SAS program is submitted:
What new value would be assigned to X if its original value was a missing value?
- A. This step does not run because of syntax errors.
- B. X would retain its original value of missing.
- C. X would get a value of 1.
- D. X would get a value of 3.
正解：C
質問 # 79
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A. .(missing numeric value)
- B. Pass
- C. Fail
- D. 50.5
正解：D
質問 # 80
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 04Jul2005
- C. Obs date 1 Monday, July 4, 2005
- D. Obs date 1 Monday, 07/04/2005
正解：C
質問 # 81
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
- A. department = trim(dept) number;
- B. department = left(dept) II number;
- C. department=trim(dept)||put(number,3.);
- D. department = dept II number;
正解：C
質問 # 82
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. a character string with the value '04/25/2000'
- B. the numeric value 04252000, representing the SAS date for April 25, 2000
- C. the numeric value 14725, representing the SAS date for April 25, 2000
- D. a character string with the value 'Monday, April 25, 2000'
正解：C
質問 # 83
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. The value can not be determined as the program fails to execute due to errors
- B. . (missing numeric value)
- C. 01012000
- D. January 1st
正解：A
質問 # 84
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. nocounts
- B. norow nocol
- C. norowcount nocolcount
- D. freq percent
正解：B
質問 # 85
The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
- A. . (missing numeric value)
- B. Pass
- C. Fail
- D. 50.5
正解：D
質問 # 86
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- B. The output displays only a list of the SAS data sets that are contained in the WORK library.
- C. The output displays only the metadata of the SAS data sets that are contained in the WORK library.
- D. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
正解：D
質問 # 87
The contents of the raw data file NAMENUM are listed below:
--------10-------20-------30
Joe xx
The following SAS program is submitted:
data test;
infile 'namenum';
input name $ number;
run;
Which one of the following is the value of the NUMBER variable?
- A. Joe
- B. The value can not be determined as the program fails to execute due to errors.
- C. . (missing numeric value)
- D. xx
正解：C
質問 # 88
After a SAS program is submitted, the following is written to the SAS log:
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;
正解：B
質問 # 89
The following SAS program is submitted:
data work.month;
date = put('13mar2000'd,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
- A. numeric, 8 bytes
- B. character, 10 bytes
- C. numeric, 10 bytes
- D. character, 8 bytes
正解：B
質問 # 90
The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
- A. JANSALES, FEBSALES and MARSALES
- B. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
- C. MONTHLY1, MONTHLY2 and MONTHLY3
- D. DIFSALES1, DIFSALES2 and DIFSALES3
正解：D
質問 # 91
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?
- A. 0
- B. 1
- C. 2
- D. 3
正解：D
質問 # 92
Given the following SAS log entry:
What caused the error?
- A. The INPUT statement should be after the DATALINES statement.
- B. A semi-colon is missing on the DATALINES statement.
- C. Character data must be specified in quotes.
- D. The CANCEL option is required with DATALINES.
正解：B
質問 # 93
The following SAS program is submitted:
data work.new;
length word $7;
amount = 7;
if amount = 5 then word = 'CAT';
else if amount = 7 then word = 'DOG';
else word = 'NONE!!!';
amount = 5;
run;
Which one of the following represents the values of the AMOUNT and WORD variables?
- A. amount word7 DOG
- B. amount word5 CAT
- C. amount word7 '' (missing character value)
- D. amount word5 DOG
正解：D
質問 # 94
A raw data file is listed below:
How many observations will the WORK.HOMEWORK data set contain?
- A. 0
- B. 1
- C. 2
- D. No data set is created as the program fails to execute due to errors.
正解：B
質問 # 95
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:
The following program is submitted:
Which statement should be inserted to produce the following output?
- A. Qtr1 = sum(of month{_ALL_});
- B. Qtr1 = month{1} + month{2} + month {3};
- C. Qtr1 = sum(of month {3});
- D. Qtr1 = sum(of month {*});
正解：D
質問 # 96
Given the raw data file YEARAMT:
----|---10---|---20---|----30
1901 2
1905 1
1910 6
1925 .
1941 1
The following SAS program is submitted:
data coins;
infile 'yearamt';
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?
- A. totquantity = sum(totquantity + quantity);
- B. retain totquantity; totquantity = totquantity + quantity;
- C. totquantity + quantity;
- D. retain totquantity0; totquantity = totquantity + quantity;
正解：C
質問 # 97
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?
- A. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.
- B. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- C. The output displays 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.
正解：A
質問 # 98
......
最新の検証済みA00-231問題と解答で合格保証：https://www.passtest.jp/SASInstitute/A00-231-shiken.html
A00-231認証と実際の解答：https://drive.google.com/open?id=17M0DtrE4CfALT_2M2M0RpjGXe-UbHLNr