SAS Unit 12: SAS Combining Tables

Which statement is true concerning concatenating tables?

• All tables must have the same number of columns.

• Columns in all tables must have matching names and lengths.

• Tables must be in the same library.

• Missing values are generated for columns that exist in one input table and not in another.

Which statement renames the existing column Location in work.travel as Destination?

• set vacations(rename=(Location=Destination)) travel;

• set vacations travel(rename=(Destination=Location));

• set vacations travel(rename=(Location=Destination));

• set vacations travel(rename(Destination=Location));

Which statement is true concerning merging with matching rows?

• The MERGE statement must refer to temporary input tables.

• The columns in the BY statement can be in only one of the tables.

• Only two input tables can be specified in the MERGE statement.

• The input tables must be sorted by the columns in the BY statement.

How many rows are in the both output table given the following input tables and code?

• two

• three

• four

• five

• seven

How many rows are in the empsauc output table given the following input tables and code?

• two

• three

• four

• five

• six

What is the result of the following step?

•  The table combine is created with four columns and five rows.

• The step fails because the BY column ID is not properly sorted.

• The step fails because Units is in both tables and not the BY column.

• The step fails because of duplicate ID values within the donors1 table.

Which statement best describes the rows in the output table?

• all the matching rows from both managers and staff

• only the rows from managers that have no match in staff

• only the rows from staff that have no match in managers

• all the matching and nonmatching rows from both managers and staff

What are the values of C and A during the third iteration of the DATA step?

• C=0 and A=0

• C=1 and A=0

• C=0 and A=1

• C=1 and A=1

What is the value of Location in the output table?

• Italy

• France

• Belgium

• France Belgium Italy

• Italy Belgium France

A single DATA step can be used to merge the following three tables:

• True

• False