Free Online SAS Institute A00-234 Practice Test

Which of the following statements about the %INCLUDE statement is correct?

Suppose you had the program below, and you wanted to concatenate the values from the libname and memname columns to create a call to %Report3 for each row of data read. Which option would correctly run the program below and generate a result?

data _null_;

    set sashelp.vtable;

    where libname='MC1' and memtype='DATA';

    rc=_______________________;

run;

Consider the following PROC SQL query:

proc sql;

select lastname, firstname, total, since

    from certadv.donors

        where not exists

            (select lastname

                from certadv.current

                where donors.lastname =

                    current.lastname);

quit;

The query references two tables: Certadv.Donors lists name and contact information for all donors who have made contributions since the charity was founded. The table also contains these two columns: Total, which shows the total dollars given by each donor, and Since, which stores the first year in which each donor gave money. Certadv.Current lists the names of all donors who have made contributions in the current year, and the total dollars each has given this year (YearTotal). Assume that the values of LastName are unique in both tables. What will the output of this query display?