Quiz 2 SAS pro - Analytiks International Inc

Name

Email

1.

Which of the following DATA steps correctly reads the permanent dataset orders from the sales library and creates a new data set named orders2 in the same library?

data sales.orders2: set orders: run;

data orders2: set sales.orders: run;

data sales.orders2: set sales.orders run;

None of the above

2.

Which of the following is a valid name for a character format?

Country

$ctry

$country

_country

3.

Which of the following statements is true about merging SAS data sets by using the DATA step?

SAS can merge data sets based on the position of observations in the original data set or by the values of one or more common variables.

Merging combines observations from two or more data sets into a single observation in new data set

Match-merging is merging by values of one or more common variables.

All the above

4.

What is the syntax error in this DATA step?

data qtr1;
set returns_jan(rename=(ID=CustID) (Return=Item))
returns_feb(rename=(Dt=Date))
returns_mar;

You cannot specify more than two data sets in the SET statement.

There are too many sets of parentheses in the RENAME= option

You cannot specify multiple variables in the RENAME= option.

The BY statement is missing.

5.

If you run this DATA step, what observations does the dataset bonuses contain?

data bonuses;

        merge managers (in=M)

                   staff (in=S);

     by EmpID;

     if M=0 and S=1;

Only the observations from staff that have no match in managers.

Only the observations from managers that have no match in staff

All observations from both managers and staff, whether or not they match

No observations

data qtr1; set returns_jan(rename=(ID=CustID) (Return=Item)) returns_feb(rename=(Dt=Date)) returns_mar;

data bonuses; merge managers (in=M) staff (in=S); by EmpID; if M=0 and S=1;

Share This

data qtr1;
set returns_jan(rename=(ID=CustID) (Return=Item))
returns_feb(rename=(Dt=Date))
returns_mar;

data bonuses;

merge managers (in=M)

staff (in=S);

by EmpID;

if M=0 and S=1;