Quiz 3

a. It allows you to update column attributes.

b. It allows you to drop columns in your table.

c. It allows you to change a character column to a numeric column.

d. It allows you to add new columns in your table.

a. NULL

b. UNIQUE

c. PRIMARY KEY

d. CHECK

a. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then pointsearned*1.5 when milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;

b. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then pointsearned*1.5 if milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;

c. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

d. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then 1.5 if milestraveled >= 10000 then 2 else 1 end;

a. proc sql; create work.names (FullName char(25), Age num);

b. proc sql; create table work.names set (FullName char(25), Age num);

c. proc sql; create table work.names (FullName char(25), Age num);

d. proc sql; create table work.names as (FullName char(25), Age num);

a. It cannot be used with the keyword ALL.

b. When used in EXCEPT, INTERSECT, and UNION set operations, it removes any columns not found in both tables.

c. It overlays columns by name, not by position.

d. When used in OUTER UNION set operations, it causes same-named columns to be overlaid.

a. The query contains an IN subquery that references the key column.

b. The query is an equijoin, and all the columns in the join expression are indexed in one of the tables being joined.

c. The key column is specified only in a SELECT clause.

d. The key column is specified in a WHERE clause expression that contains a comparison operator, the TRIM or SUBSTR function, the CONTAINS operator, or the LIKE operator.

a. proc sql; create composite index places on sasuser.flightdelays (flightnumber, destination);

b. proc sql; create index on flightnumber,destination from sasuser.flightdelays (places);

c. proc sql; create index destination on sasuser.flightdelays(flightnumber, destination);

d. proc sql; create index places on sasuser.flightdelays (flightnumber, destination);

a. KEY

b. UNIQUE

c. NODUPKEY

d. NODUPS

a. The option allows you to create and name an index on the table.

b. The option directs SAS to use an index that you specify.

c. The specified index must be suitable by having at least its first or only column match a condition in the WHERE expression.

d. The specified index must exist.

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

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

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

d. the tables must be sorted before they are joined.