D**0
发帖数: 195 | 1 总是被这类的题弄晕。请大侠解释一下下面这些题。能解释几道都可以。多谢！
Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average
salary based on jobcode:
Jobcode Salary ... 阅读全帖 |
|
w******p
发帖数: 62 | 2 Item 6 of 63 Mark item for review Item 6 of 63 Mark item for review Item 6 of 63 Mark item for review Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summ... 阅读全帖 |
|
发帖数: 1 | 3 6. The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average
salary based on jobcode:
Jobcode Salary Avg
------- ------ -----
PT1 50000 60000
PT1 70000 60000
PT1 60000 60000
PT2 80000 85000
PT2 90000 85000
PT3 100000 100000
Which SQL statement could NOT generate this result?
... 阅读全帖 |
|
s*********y
发帖数: 34 | 4 Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average salary based on jobcode:
Jobcode Salary Avg
------- ------ ----... 阅读全帖 |
|
P*****i
发帖数: 63 | 5 29.A frequency report of the variable Jobcode in the Work.Actors data set is
listed below.
Jobcode Frequency Percent Cumulative
Frequency Cumulative
Percent
Actor I 2 33.33 2 33.33
Actor II 2 33.33 4 66.67
Actor III 2 33.33 6 100.00
Frequency Missing = 1
The following SAS program is submitted:
data work.joblevels;
set work.actors;
if jobcode in ('Actor I', 'Actor II') then
joblevel='Beginner';
if jobcode='Actor III' then
joblevel='Advanced';
else joblevel='Unknown';
run;
Which of the following r... 阅读全帖 |
|
s*****z
发帖数: 202 | 6 下周就考，还有以下三个问题不明白
第一道是
62. The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?
A. The variable JCODE is written to the output data set.
B. The variable JOBCODE is written to the output data set.
C. Neither variable JCODE nor JOBCODE is written to the output data set.
D. The program fails to execute due to errors.
Answer: B
不明白为什么jcode没有写入output data set.
第二道题是
89. The value |
|
n*****5
发帖数: 61 | 7 A frequency report of the variable Jobcode in the Work.Actors data set is
listed
below.
Jobcode Frequency Percent Cumulative
Frequency Cumulative
Percent
Actor I 2 33.33 2 33.33
Actor II 2 33.33 4 66.67
Actor III 2 33.33 6 100.00
Frequency Missing = 1
The following SAS program is submitted:
data work.joblevels;
set work.actors;
if jobcode in ('Actor I', 'Actor II') then
joblevel='Beginner';
if jobcode='Actor III' then
joblevel='Advanced';
else joblevel='Unknown';
run;
Which of the following repr... 阅读全帖 |
|
A*********u
发帖数: 8976 | 8 1 jcode was renamed
2 $,.都要算
3 level = 2 or 3
等价于
(levle = 2) or 3
since 3 is forever true, level = 2 or 3 is forever true
should be
level = 2 or level =3
or
level in (2,3)
下周就考，还有以下三个问题不明白
第一道是
62. The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?
A. The variable JCODE is written to the output data set.
B. The variable JOBCODE is written to the output data set.
C. Neit |
|
c*********n
发帖数: 87 | 9 why do the outputs of two silimar programs are different?
(1) libname sasdata 'sas_data_library';
data test;
set sasdata.chemists;
if jobcode='chem2';
then description='senior-chemist';
else description='unknown';
run;
a value for jobcode is listed blow:
jobcode
chem2
output: description
unknown
(2)data test;
infile 'amount';
input @1 salary 6.;
if _error_ then description='problems';
else description='no problems';
run;
|
|
s*******2
发帖数: 791 | 10 LZ如果是从123上看到的题目的话 你把题目就没有看清楚 这里你抄的题目也有错误 那
就是你为什么得不到结果的原因 ;)
以下是正确题目
108. The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'Chem2'
A00-211
- 33 - http://www.ePlanetLabs.com
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
chem2
Which one of the following values does the variable DESCRIPTION contain?
A. Chem2
B. Unknown
C. Senior Chemist
D. ' ' |
|
w*********a
发帖数: 3 | 11 Item 6 of 63 Mark item for review
The table WORK.PILOTS contains the following data:
WORK.PILOTS
Id Name Jobcode Salary
--- ------ ------- ------
001 Albert PT1 50000
002 Brenda PT1 70000
003 Carl PT1 60000
004 Donna PT2 80000
005 Edward PT2 90000
006 Flora PT3 100000
The data set was summarized to include average salary based on jobcode:
Jobcode Salary Avg
------- ------ ---- |
|
c*****n
发帖数: 1347 | 12 The following SAS program is submitted:
data work.accounting;
length jobcode $ 12;
set work.department;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE
with a length of 5.
Which of the following is the length of the variable JOBCODE in the output
data set?
A. 5
B. 8
C. 12
D. The length can not be determined as the program fails to execute due to
errors.
都是这题，123题的答案是A，50题的答案是C，这是怎么回事？谢谢！ |
|
t*******t
发帖数: 269 | 13 64. The following SAS program is submitted:
data work.accounting;
length jobcode $ 12;
set work.department;
run;
The WORK.DEPARTMENT SAS data set contains a character variable named
JOBCODE with a length of 5.
Which of the following is the length of the variable JOBCODE in the output
data set?
A. 5
B. 8
C. 12
D. The length can not be determined as the program fails to execute due to
errors
网上的答案是A 5，也有选C的，究竟是哪个呢
有没有人解答一下？谢谢了！ |
|
w********y
发帖数: 371 | 14 data work.accounting;
set work.department;
length jobcode $ 12;
run;
the work.department sas dataset 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 dataset?
A.5
B.8
C. 12
D. the length can not be determined as the program fails to execute due to
errors.
why the correct answer is A? I chose C and I think the rest of them (12-5)
are filled with blanks.
thank you! |
|
G********r
发帖数: 3161 | 15 两个Datasets啊，原数据就是SET语句里的那个，这个Dataset已经有一个Jobcode的变
量，长度是5。你用它来产生新的Dataset，然后改长度成12，但是这个步骤是不能改变
长度的。你自己试试这个Code不就完了。呵呵。
data test;
input jobcode $ 1-5;
datalines;
ABCDE
;
run;
data test2;
set test;
length jobcode $ 12;
run; |
|
|
|
|
|
H***M
发帖数: 7 | 20 一个是
length jobcode $ 12;
set work.department;
答案是12
另一个是
set work.department;
length jobcode $ 12;
答案是5 |
|
w********y
发帖数: 371 | 21 I change your program to:
data test;
input jobcode $ 1-10;
datalines;
ABCDEfghij
;
run;
data test2;
set test;
length jobcode $ 5;
run;
proc print data=test2;
run;
the result is : ABCDEfghij
then what's the point of this length statement?? |
|
t*****w
发帖数: 254 | 22 else joblevel='Unknown';
will change the other into unknown;
if "if jobcode='Actor III' then joblevel='Advanced';" is changed into
"else if jobcode='Actor III' then joblevel='Advanced';",
the correct answer is b. |
|
|
|
|
d***a
发帖数: 13752 | 26 http://www.higheredjobs.com/details.cfm?JobCode=175629837
Assistant Professor (0815679)
Salary: $25,000 USD Per Year
Position Summary
The University of New Mexico-Los Alamos is a two-year branch campus of the
University of New Mexico. With an emphasis on teaching excellence, the Los
Alamos Campus offers academic transfer courses, as well as vocational and
technical courses to the citizens of Los Alamos County, Sandoval County, and
northern New Mexico. The faculty and staff serve a student bo... 阅读全帖 |
|
|
|
U**********b
发帖数: 13 | 29 【 以下文字转载自 Chemistry 讨论区 】
发信人: UofLlaserlab (UofLlaserlab), 信区: Chemistry
标 题: Assistant Professor of Computational Chemistry , Department of Chemistry, University of Louisville
发信站: BBS 未名空间站 (Wed Sep 28 14:14:14 2016, 美东)
https://www.higheredjobs.com/institution/details.cfm?JobCode=176354471&Title
=Assistant%20Professor%20of%20Computational%20Chemistry&aID=7137
The Department of Chemistry in the College of Arts and Sciences of the
University of Louisville seeks a tenure-track Assistant Profes... 阅读全帖 |
|
w*****3
发帖数: 21 | 30 location: Cleveland, OH
facility: Cleveland Clinic Main Campus
department: Clinical Transformation Admin
jobcode: T98855
schedule: Full time
shift: 8:00am-5:00pm
Job Details
Job Summary:
Utilizes basic statistical, mathematical, and predictive modeling as well as
business strategy skills to build algorithms. Utilizes programing skills in
SAS, SQL, SPSS and R or Python and creates and designs new reports
independently. Utilizes advanced statistical, mathematical, and predictive
modeling as well a... 阅读全帖 |
|
l**********2
发帖数: 307 | 31 Check the link below:
http://www.higheredjobs.com/institution/details.cfm?JobCode=175
Position Description
The School of Dentistry is seeking a Postdoctoral Scholar to study oral
bacteria-induced inflammatory immune responses in a dynamic well-funded
research group, the Center of Oral Health and Systemic Disease (OHSD)
University of Louisville. This three year, NIH-funded project, aims to
elucidate the molecular mechanism of a novel serine/theronine kinase in P.
gingivalis-mediated inflammation ... 阅读全帖 |
|
|
|
U**********b
发帖数: 13 | 34 https://www.higheredjobs.com/institution/details.cfm?JobCode=176354471&Title
=Assistant%20Professor%20of%20Computational%20Chemistry&aID=7137
The Department of Chemistry in the College of Arts and Sciences of the
University of Louisville seeks a tenure-track Assistant Professor in
Computational Chemistry to begin in Fall 2017. The successful candidate is
expected to teach at the graduate and undergraduate levels in the area of
physical chemistry and to develop a competitive, extramurally funded
... 阅读全帖 |
|
s***1
发帖数: 343 | 35 非常感谢你给的SUGI26链接！
但是我在自己机器上用sas9.1试了里面的example，用的column input，试了missover
和truncover，但是结果竟然都是一样的，都是：
Obs lastn Firstn Empid Jobcode
1 LANGKAMM SARAH E0045 Mechanic
2 TORRES JAN E0029 Pilot
3 SMITH MICHAEL E0065
4 LEISTNER COLIN E0116 Mechanic
5 TOMAS HA... 阅读全帖 |
|
S******3
发帖数: 66 | 36 本题答案是C (12),不过死记答案不是学习的好方法。
换个顺序，
data work.accounting;
set work.department;
length jobcode $ 12;
run;
答案就是A (5)了。
需要学习的是本题的考点：SAS是SEQUENCIAL COMPILE，按照最先出现的定义变量。
output |
|
w********y
发帖数: 371 | 37 the question asks in the output dataset which is work.accounting, what do
you mean by "原来同名变量"?
jobcode in work.department is 5 byte long, is it the same in the work.
accounting even with a length statement?
Thank you for the reply |
|
t*******t
发帖数: 633 | 38 这个length命令是不可以改变length
变量长度在work.department里就定义了的。
jobcode |
|
G*********e
发帖数: 182 | 39 将中间那个data step 改成
data test2;
length jobcode $ 5;
set test;
run; |
|
w*****3
发帖数: 21 | 40 ocation: Cleveland, OH
facility: Cleveland Clinic Main Campus
department: Clinical Transformation Admin
jobcode: T98855
schedule: Full time
shift: 8:00am-5:00pm
Job Details
Job Summary:
Utilizes basic statistical, mathematical, and predictive modeling as well as
business strategy skills to build algorithms. Utilizes programing skills in
SAS, SQL, SPSS and R or Python and creates and designs new reports
independently. Utilizes advanced statistical, mathematical, and predictive
modeling as well as... 阅读全帖 |
|
w*****3
发帖数: 21 | 41 ocation: Cleveland, OH
facility: Cleveland Clinic Main Campus
department: Clinical Transformation Admin
jobcode: T98855
schedule: Full time
shift: 8:00am-5:00pm
Job Details
Job Summary:
Utilizes basic statistical, mathematical, and predictive modeling as well as
business strategy skills to build algorithms. Utilizes programing skills in
SAS, SQL, SPSS and R or Python and creates and designs new reports
independently. Utilizes advanced statistical, mathematical, and predictive
modeling as well as... 阅读全帖 |
|
w*****3
发帖数: 21 | 42 ocation: Cleveland, OH
facility: Cleveland Clinic Main Campus
department: Clinical Transformation Admin
jobcode: T98855
schedule: Full time
shift: 8:00am-5:00pm
Job Details
Job Summary:
Utilizes basic statistical, mathematical, and predictive modeling as well as
business strategy skills to build algorithms. Utilizes programing skills in
SAS, SQL, SPSS and R or Python and creates and designs new reports
independently. Utilizes advanced statistical, mathematical, and predictive
modeling as well as... 阅读全帖 |
|
|
