Static binding

Dynamic binding

-

--

Foo b = a;

Foo b = a.clone();

Foo b;b=a;

-

. (dot)

,

->

>

True

False

Foo d = c;

Foo *d = c;

Foo d; d=c;

--

join conditions are not specified in a PROC SQL join.

join conditions are not specified in a PROC SQL set operatio

more than two tables are specified in a PROC SQL join.

the keyword ALL is used with the OUTER UNION operator.

150

7

4

1

The query syntax is not valid.

The outer query must pass values to the subquery before the subquery can return values to the outer query.

PROC SQL will not execute this query when it is submitted.

After the query is submitted, the SAS log will indicate whether the query has valid syntax.

the tables being joined must contain the same number of columns.

the tables must be sorted before they are joined

the columns that are specified in a join condition in the WHERE clause must have the same data type.

the columns that are specified in a join condition in the WHERE clause must have the same name.

a maximum of 2 tables or in-line views, but multiple joins can be chained together.

a maximum of 32 tables or 2 in-line views.

a maximum of 32 tables, which includes any tables referenced by an in-line view.

a maximum of 2 tables and 32 columns.

proc sql nodup; select membertype from sasuser.frequentflyers;

proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;

proc sql; select unique membertype from sasuser.frequentflyers group by membertype;

proc sql; select distinct membertype from sasuser.frequentflyers;

ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 744 . 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 744 55000 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 .

Table aliases must be used when referencing identical table names from different libraries.

Table aliases can be referenced by using the keyword AS.

Table aliases (or full table names) must be used when referencing a column name that is the same in two or more tables.

Table aliases must be used when using summary functions.

WHERE address is missing

WHERE address not exists

WHERE address is null

both a and c

proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance <= 0;

proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;

proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;

proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;

df

def

deef

deeef

all the above

$&

$%

$_

$@

$^

123

123ce

Cant modify constant item in translation

12d3e

None of the above

Hello world HELLO WORLD.

Hello World HELLO WORLD.

Hello world HELLO world.

hello world HELLO WORLD.

BA

AB

Compilation Error

Null point reference error