SASInstitute SAS 9.4 Base Programming - Performance-based - A00-231무료 덤프문제 풀어보기
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?
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?
정답: B
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
정답: A
The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?
정답: C
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?
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
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?
What changes should be made to the KEEP statement to correct the errors in the LOG?
정답: C
Given the SAS data set WORK.ORDERS:
Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?
Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?
정답: D
Given the raw data record in the file phone.txt:
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
정답: B
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
정답: C
The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?
정답: C
The following SAS program is submitted:
Which statement is true about the output data set?
Which statement is true about the output data set?
정답: D
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
정답: A
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.
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
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