SASInstitute SAS base programming - A00-201 模擬練習
Click the Exhibit button to view a listing of the SASUSER.HOUSES data set.
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price lt 100000;
< insert DEFINE statement here>
define price / mean width = 9;
title;
run;
The following ouput is created by the REPORT procedure:
Which one of the following DEFINE statements completes the above program and produces the above output?
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price lt 100000;
< insert DEFINE statement here>
define price / mean width = 9;
title;
run;
The following ouput is created by the REPORT procedure:
Which one of the following DEFINE statements completes the above program and produces the above output?
正解: B
The following SAS program is submitted:
data work.month; d
ate = input('13mar2000',date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
data work.month; d
ate = input('13mar2000',date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
正解: A
The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
正解: D
The following SAS program is submitted:
< insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
Which one of the following ODS statements completes the program and sends the report to an HTML file?
< insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
Which one of the following ODS statements completes the program and sends the report to an HTML file?
正解: D
Which one of the following SAS system options prevents the page number from appearing on a report?
正解: A
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;
Which one of the following is the value of the CITY variable?
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
Which one of the following is the value of the CITY variable?
正解: A
A raw data record is listed below:
----|----10---|----20---|----30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile 'file-specification';
input date $ 1 - 10;
< insert statement here>
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?
----|----10---|----20---|----30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile 'file-specification';
input date $ 1 - 10;
< insert statement here>
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?
正解: C
Which one of the following statements is true regarding the SAS automatic _ERROR_ variable?
正解: D
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?
----|----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