A00-231試験問題集を試そう！ベストA00-231試験問題トレーニングを提供しています
実践サンプルと問題集指導には2024年最新のA00-231有効なテスト問題集
SASINSTITUTE A00-231（SAS 9.4ベースプログラミング - パフォーマンスベース）認定試験は、SASプログラミングの候補者のスキルを検証するように設計されています。この認定試験は、SASプログラミングとデータ管理の習熟度を実証したい個人を対象としています。この試験はパフォーマンスベースです。つまり、候補者はSASプログラミングとデータ管理に関連するタスクを完了する必要があります。
質問 # 115
The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
- A. The descending option applies to the Date and Cost variables.
- B. The descending option applies only to the Code variable.
- C. The descending option applies only to the Date variable.
- D. The descending option applies to the Product and Code variables.
正解：A
質問 # 116
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
- A. 0
- B. 1
- C. 2
- D. 3
正解：B
質問 # 117
Scenario:
This project will use data set cert.input12. At any time, you may
save your program as program12 in cert\programs.
cert.input12 contains a single observation with two variables:
* salary
* year
Write a SAS program that will:
* Create an output data set results.output12.
* Read cert.input12 as input.
* Increase the salary variable by 5.65% annually until it is
greater than $500,000.
* Increment the year variable by 1 with each annual
increase.
* Create an output data set results.output12 that has one
observation for each value of year. Each observation
should have a year and salary variable.
What is the maximum salary hat is less than $500,000? Enter your numeric answer in the space below (Round your answer to the nearest integer)
正解：
解説：
498737
Explanation:
data results.output12;
set cert.input12;
do until (salary gt 500000);
salary=salary*1.0565;
year+1;
output;
end;
run;
proc print data=results.output 12;
run;
質問 # 118
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 How many observations are inresults.output36?
正解：
解説：
4992
Explanation:
data work.cleandata36;
set cert.input36;
group=upcase(group);
if group in ('A','B');
run;
proc means data=work.cleandata36 median;
class group;
var kilograms;
run;
data results.output36;
set cleandata36;
if Kilograms < 40 or Kilograms > 200 then do;
if group='A' then kilograms=79; else kilograms=89;
end;
run;
proc contents data=results.output36;
run;
質問 # 119
Given the following raw data records in TEXTFILE.TXT:
The following output is desired:
Which SAS program correctly produces the desired output?
- A. Option C
- B. Option B
- C. Option A
- D. Option D
正解：A
質問 # 120
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;
正解：B
質問 # 121
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 = month{1} + month{2} + month {3};
- B. Qtr1 = sum(of month{_ALL_});
- C. Qtr1 = sum(of month {3});
- D. Qtr1 = sum(of month {*});
正解：D
質問 # 122
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
- A. NUM CHAR 1 77 2
- B. No output is generated.
- C. NUM CHAR 1 23 3 23 1 77
- D. NUM CHAR 1 23 3 23
正解：B
質問 # 123
Scenario:
Continuing with the previous program (program27), add a PROC SORT step that satisfies the following criteria:
* Creates the output dataset results.output27b
* Sorts the observations by order.
* Removes duplicate values of the first occurrence found during the sort.
What is the value of Employee_ID for observation 98 inresults.output27b?
正解：
解説：
120779
Explanation:
proc sort data=cert.input27 out=results.output27b nodupkey;
by descending postal_code;
run;
proc print data=results.output27b (firstobs=98 obs=181);
var employee_ID;
run:
質問 # 124
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.nomatch08
Enter your numeric answer in the space below:
Save your program as ______________ program08.sas in folder cert programs before continuing with the next project.
正解：
解説：
5
Explanation:
SAS code that could be used to solve this project:
Proc
sort data=cert.input08a out=work.input08a;
by ID;
run;
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;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 5
質問 # 125
The following SAS program is submitted:
data revenue;
set year_1;
var1 = mdy(1,15,1960);
run;
Which one of the following values does the variable named VAR1 contain?
- A. 0
- B. '1/15/1960'
- C. 1
- D. 2
正解：C
質問 # 126
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 fails execution due to syntax errors.
- B. The program fails execution due to data errors.
- C. The program executes without errors or warnings and creates the WORK.TOTALSALES data set
- D. The program executes with warnings and creates the WORK.TOTALSALES data set.
正解：A
質問 # 127
This question will ask you to provide a missing option. Given the following SAS program:
Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?
- A. wrap = '*'
- B. split = '*'
- C. labelsplit = '*'
- D. label = '*'
正解：C
質問 # 128
Given the data sets below:
WORK.EMP with variables:
WORK.NEWHIRE with variables:
The following SAS program is submitted:
The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.
How many variables will the data set WORK.ALLEMP contain?
- A. 0
- B. The program fails execution.
- C. 1
- D. 2
正解：C
質問 # 129
CORRECT TEXT
The following SAS program is submitted:
What value will SAS assign to Pos? Enter your numeric answer in the space below.
正解：
解説：
12
質問 # 130
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. Neither variable JCODE nor JOBCODE is written to the output data set.
- B. The variable JCODE is written to the output data set.
- C. The program fails to execute due to errors.
- D. The variable JOBCODE is written to the output data set.
正解：D
質問 # 131
......
SASInstitute A00-231 認定試験に合格するためには、SASプログラミング言語を使用してデータを操作、分析、およびレポートする能力を証明する必要があります。試験は、データ操作、データセットの作成、データ分析、およびレポート作成など、さまざまなトピックをカバーしています。候補者は、SASマクロ、関数、およびその他の高度なプログラミング技術を使用する能力も証明する必要があります。この資格は、定期的にSASソフトウェアを使用し、SASプログラミングの知識とスキルを向上させたい個人に適しています。この認定試験に合格することで、個人はキャリアを進め、収益の可能性を高めることができます。
最新100%合格率保証付きの素晴らしいA00-231試験問題PDF：https://www.jpntest.com/shiken/A00-231-mondaishu