base 123 三道題

是 否 +2 論壇幣

k人 參與回答

經(jīng)管之家送您一份

應(yīng)屆畢業(yè)生專屬福利!

求職就業(yè)群

趙安豆老師微信：zhaoandou666

經(jīng)管之家聯(lián)合CDA

送您一個(gè)全額獎(jiǎng)學(xué)金名額~ !

立即領(lǐng)取

感謝您參與論壇問題回答

經(jīng)管之家送您兩個(gè)論壇幣！

+2 論壇幣

109. The contents of the raw data file EMPLOYEE are listed below:
----|----10---|----20---|----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Sue' then input age 7-8;
else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the
name of the employee is "Sue"?
A. 30
B. 33
C. 40
D. . (missing numeric value)
Answer: C(不知道怎末得出

110. The contents of the raw data file EMPLOYEE are listed below:
----|----10---|----20---|----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else 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(不知道怎末得出的)


111. A SAS PRINT procedure output of the WORK.LEVELS data set is listed
below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
A00-211
- 34 - http://www.ePlanetLabs.com
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = 'Unknown';
else if level = 1 then
expertise = 'Low';
else if level = 2 or 3 then
expertise = 'Medium';
else
expertise = 'High';
run;
Which of the following values does the variable EXPERTISE contain?
A. Low, Medium, and High only
B. Low, Medium, and Unknown only
C. Low, Medium, High, and Unknown only
D. Low, Medium, High, Unknown, and ' ' (missing character value)
Answer:B(為何不是C呢)

謝謝

掃碼加我 拉你入群

請注明：姓名-公司-職位

以便審核進(jìn)群資格，未注明則拒絕

分享0 收藏0 回帖

關(guān)鍵詞：Base following Procedure Character Employee Base

先給你回答第一個(gè)問題

input employee_name $ 1-4 @@;

這是input讀取數(shù)據(jù)的時(shí)候，前后兩個(gè)如果不加 @@，就讀成兩條了，

[em01]

第二題 跟第一個(gè)是一個(gè)問題。

第三題：else if level = 2 or 3 then

編譯的時(shí)候，會自動(dòng)將這個(gè)式子自動(dòng)判斷為 TRUE.所以，不會出來High 這一項(xiàng)

你可以寫 else if level =2 or level = 3 then 或者 else if level = in(2:3) then

good luck

[em01]

但是109/110還是不明白,如果不加@@的話,在109題為何讀出40呢? 謝謝

他的結(jié)果是

Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44

input 你只是讀入了name這個(gè)變量，而對于這一行后面的 你想要繼續(xù)讀的話 就要加 @@了，不然他會另起一行的。

[em01]

[em17][em17]

thanks learning

嗯，第三題，謝謝指點(diǎn)了，忘記優(yōu)先級了，