sasba70题新题
71.Which one of the following SAS REPORT procedure options controls how column headings are displayed over multiple lines?
a. SPACE=
b. SPLIT=
c. LABEL=
d. BREAK=
Answer: B
72. Which one of the following SAS DATA steps saves the temporary data t named MYDATA as a permanent data t?
A. libnamesasdata 'SAS-data-library';
偷的英语
copymydata;
run;
B. libnamesasdata 'SAS-data-library';
keepmydata;
run;
C. libnamesasdata 'SAS-data-library';
savemydata;
run;
D. libnamesasdata 'SAS-data-library';
tmydata;
人事管理
run;学习委员竞选>僵尸的英文
Answer: D
73. The SAS data t named COMPANY.PRICES is listed below:
COMPANY.PRICES
prodidpriceproducttype sales returns
K12S 5.10 NETWORK 15 2
B132S 2.34 HARDWARE 300 10
R18KY2 1.29 SOFTWARE 25 5
3KL8BY 6.37 HARDWARE 125 15
DY65DW 5.60 HARDWARE 45 5
DGTY23 4.55 HARDWARE 67 2
起讫地点The following SAS program is submitted:
libnamecompany 'SAS-data-library';
datahware inter soft;
tcompany.prices (keep = producttype price);
if price le 5.00;
ifproducttype = 'HARDWARE' then output HWARE;
el if producttype = 'NETWORK' then output INTER;
el if producttype = 'SOFTWARE' then output SOFT;
run;
How many obrvations does the HWARE data t contain?
A. 0
B. 2
C. 4
D. 6
Answer: B
74. The following SAS program is submitted:
twork.staff (keep = jansalesfebsalesmarsales);
arraydiff_sales{3} difsales1 - difsales3;
A00-201
/doc/11470b87767f5acfa0c7cd1f.html - The Power of Knowing
array monthly{3} jansalesfebsalesmarsales;
run;
Which one of the following reprents the new variables that are created?
A. JANSALES, FEBSALES and MARSALES
B. MONTHLY1, MONTHLY2 and MONTHLY3
C. DIFSALES1, DIFSALES2 and DIFSALES3
D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
Answer: C
75. The following SAS DATA step is submitted:
datawork.accountting;
twork.department;
lengthjobcode$ 12;
run;
The WORK.DEPARTMENT SAS data t contains a character variable named JOBCODE with a length of 5. Which one of the following is the length of the variable JOBCODE in the output data t?
A. 5
B. 8
C. 12
D. The length can not be determined as the program fails to execute due to errors. Answer: A
procfreq data=sales;
run:
Exhibit: output from the FREQ procedure.
Which one of the following statements completes the program and produces the output?
A. tables region product;
B. tables region* product;
C. tables product region;
D. tables product region*;
Answer: B
77. The following SAS program is submitted:
proc format;
value score 1 - 50 = 'Fail'
51-100='Pass';
run;
proc report data=work .cours 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. Fail
B. Pass
C. 50.5
D. . (missing numeric value)
Answer: C
78. The following SAS program is submitted:
proc means data= sasur .shoes;
where product in ('sandal' , 'Slipper' , 'Boot');
run;
Which one of the following ODS statements completes the program and nds the report to an HTML file?
A. ods html = 'sales .html';
B. ods file='sales .html';
C. ods file html='sales .html';
D. ods html file='sales. html';
Answer: D
libnamesasdata 'SAS-data-library';
data t;
tsasdata .chemists;
ifjobcode = 'chem3'
then description = 'Senior Chemist';
el 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?
A. chem3
B. Unknown
C. Senior Chemist
D. ' ' (missing character value)
Answer: B
80. The contents of the raw data file EMPLOYEE are listed below:
----|----10---|----20---|----30
Ruth 39 11
Jo 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
in file' employee';
input employee_ name $ 1-4;
if employee_ name = 'Ruthh' then input idnum 10-11;
el input age 7-8;
run
Which one of the following values does the variable IDNUM contain when the name of the employee is "Ruth"?
A. 11
B. 22
C. 32
D. . (missing numeric value)
Answer: B
81. The following SAS program is submitted:
datawork.january;
twork.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 t contain?
A. PRODUCT and SALES only
B. PRODUCT, MONTH, NUM_SOLD and COST only
C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
D. An incomplete output data t is created due to syntax errors.
Answer: D
82. The following SAS program is submitted:
retrainmontnsales {12};
arraymontnsales {12};
doi=1 to 12;
monthsales{i}=sales;
end;
ent+1;
monthsales{ent}=sales;
run;
The data t named WORK.MONTHLYSALES has one obrvation per month for each of five years for a total of 60 obrvations. Which one of the following is the result of the above program?
A. The program fails execution due to data errors.
B. The program fails execution due to syntax errors.
C. The program runs with warnings and creates the WORK.TOTALSALES data t with 60 obrvations.
D. The program runs without errors or warnings and creates the
WORK.TOTALSALES data t with 60 obrvations.
Answer: B
83. The following SAS program is submitted:
srraymonthsales {12};
doi=1 to 12;
monthsales{i}=sales;
end;
run;
The data t named WORK.MONTHLYSALES has one obrvation per month for each of five years for a total of 60 obrvations. Which one of the following is the result of the above program?
A. The program fails execution due to data errors.
B. The program fails execution due to syntax errors.
C. The program executes with warnings and creates the WORK.TOTALSALES data t.
D. The program executes without errors or warnings and creates the
平板怎么连接键盘WORK.TOTALSALES data t.
Answer: B
84.Which one of the following statements is true regarding the SAS automatic
_ERROR_ variable?
A. The _ERROR_ variable contains the values 'ON' or 'OFF'.
B. The _ERROR_ variable contains the values 'TRUE' or 'FALSE'.
C. The _ERROR_ variable is automatically stored in the resulting SAS data t.
D. The _ERROR_ variable can be ud in expressions or calculations in the DATA step.
Answer: D
New Questions:
85.
length var1 var2 12 (都是character类型的）
t work.two (e.g. var1 length 5)
format var1 20
问最后one⾥var1 length是多少，应该是12，由最开始的length决定
86. ⼀个排序的问题
by var1 desceding var2 var3
问三个vars是怎么排序的
应该是var1 var3 ascending，var2 descending
87. 下⾯哪⼏种是有效的data t name
DATA
<
_test
test_
2Test
好像还有⼏个不记得了
但是最后答案是⼀共4个有效
88.⼀个datat，列出了所有的variables的类型
Name Type
N1 num
N2 num
N3 char
N4 char
问在程序中array{*} _numeric_ 建⽴了⼏个variable
答案是0，因为这条命令只是refer了datat⾥所有num类型的variables，并没有建⽴新的变量
89.如果今天是Jan 2，1960
问today（）
答案应该是1
90.obs number
1 25
2 10
3 .
4 20
5 30
问total+number的output是神马
obs number total
1 25 25
2 10 35
3 . 35
4 20 55
5 30 85
理解yearcutoff的意义即可。题⽬中60必须是1970之后，我选2060年
丧事请假条怎么写
92.这题之前看到其他帖⼦介绍了，是个新提。于是背答案了。
四个选项中有两个是input( )，有两个是put( )，显然input( )是错的，于是在put( ) ⾥⾯⼆选⼀：
A) put(date, date9., worddate20.)
水浒传的作者简介B) put(date, worddate20.)
B为正确答案。
93.对于libref的命名规则也考了，问你以下4个选项有⼏个是符合规则的。libref is 1 to 8 characters long, begins with a letter or underscore, and contains only letters, numbers, or underscores.
94. ods html file="F:reg1.html";
run;
odspdf clo;
