s*******2
发帖数: 791 | 1 The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money(in = insal);
if insal and inemp;
run;
The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY
has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
A. 0
B. 5
C. 7
D. 12
Answer: A
为什么？ 我觉得 BCD都有可能呀。
QUESTION 72
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City = substr(First,1,7);
City_Country= City!!'; '!!'E | a****g
发帖数: 480 | 2 Answer for Question 73:
Putting strings together is called concatenation. For example, if you have
separate variables representing a first and last name, you can concatenate
them (with a blank in between) to create a variable containing the full name.
The concatenation operator, || (or !!), has always been available to SAS
programmers. For example, if One = ABC and Two = DEF, then One || Two is
equal to ABCDEF.
When you use the || operator, if you do not define the length of the
resulting string | s*******2
发帖数: 791 | 3 Thanks.
The question 72,73,75,76 are solved. How about the Q79? why the length of
Product_Number is 8 and the length of Item is 4 , but the length of Item||'/
'||Product_Number is 17?
How about Q39 and Q93?
Many thanks.
name.
【在 a****g 的大作中提到】
: Answer for Question 73:
: Putting strings together is called concatenation. For example, if you have
: separate variables representing a first and last name, you can concatenate
: them (with a blank in between) to create a variable containing the full name.
: The concatenation operator, || (or !!), has always been available to SAS
: programmers. For example, if One = ABC and Two = DEF, then One || Two is
: equal to ABCDEF.
: When you use the || operator, if you do not define the length of the
: resulting string
| g*******y
发帖数: 380 | 4 Check out the attachment, which is I found online when I was preparing for
the base exam. You can learn most of character functions which appear in the
practice exam.
For the question 93, you can't answer it unless you see the display.
'/
【在 s*******2 的大作中提到】
: Thanks.
: The question 72,73,75,76 are solved. How about the Q79? why the length of
: Product_Number is 8 and the length of Item is 4 , but the length of Item||'/
: '||Product_Number is 17?
: How about Q39 and Q93?
: Many thanks.
:
: name.
| s*******2
发帖数: 791 | 5 Thanks so much.
the
【在 g*******y 的大作中提到】
: Check out the attachment, which is I found online when I was preparing for
: the base exam. You can learn most of character functions which appear in the
: practice exam.
: For the question 93, you can't answer it unless you see the display.
:
: '/
| s*******2
发帖数: 791 | | C******t
发帖数: 72 | 7 39:data work.empsalary;
set work.people (in = inemp)
work.money(in = insal);
run;
In the set work.empsalary, each observation comes from either people or
money. Therefore, inemp and insal can not be true at the same time.
if insal and inemp; =>false
for example;
people:
x y
1 2
salary:
x y
3 4
empsalary:
x y inemp insal
1 2 1 0
3 4 0 1
Alternatively, if we change the question to:
set work.people (in = inemp);
work.money(in = insal);
run;
The SAS data set WORK.PEOPLE has 5 observation | s*******2
发帖数: 791 | 8 感谢ColdPitt回答问题， 但是有两点要修正：
1。 ColdPitt回答的是16题
2。 最后你的假设题目，答案应该是5+7=12 observations
【在 C******t 的大作中提到】
: 39:data work.empsalary;
: set work.people (in = inemp)
: work.money(in = insal);
: run;
: In the set work.empsalary, each observation comes from either people or
: money. Therefore, inemp and insal can not be true at the same time.
: if insal and inemp; =>false
: for example;
: people:
: x y
|
|
