w*********a
发帖数: 3 | 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 Avg
------- ------ ---- | g********d
发帖数: 2022 | 2 6: B
Inner query produce less obs than outer. Conflict results.
11: A
To create a data step view, the two names need to be the same. If not, a
dataset with the first name will be created.
26: C
There are two names before /
50: B
Need a "calculated" before "overall".
54: B
Use "OPTION SYMBOLGEN;" to see the process yourself. |
|
