최신 A00-211 무료덤프 - SASInstitute SAS Base Programming for SAS 9
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?
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?
정답: C
The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
정답: D
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
정답: C
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
정답: B
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?
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
정답: C
The following SAS program is submitted:
What new value would be assigned to X if its original value was a missing value?
What new value would be assigned to X if its original value was a missing value?
정답: A
Which program displays a listing of all data sets in the SASUSER library?
정답: A
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?
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
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
정답: C
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
정답: A
Given the SAS data set AGES:
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
AGES
AGE
---------
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
정답: C
The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
--------10-------20-------30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?
정답: C
Which one of the following SAS system options displays the time on a report?
정답: B
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:
The following SAS program is submitted:
In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
Given the SAS data set WORK.EMPLOYEE_UNFO:
The following SAS program is submitted:
In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
정답:
See explanation below.
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
Explanation
by IDNumber Expenses;
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
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?
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?
정답: D
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
정답: B
Given the following SAS log entry:
What caused the error?
정답: D