SAS Training

SAS Certified Adv Programmer 50 Questions (24)

The following SAS program is submitted:

%let type=RANCH;
proc sql;
    create view houses as
        select *
            from sasuser.houses
            where style="&type";
quit;
%let type=CONDO;
proc print data=houses;
run;

The report that is produced displays observations whose value of Style are all equal to RANCH. Which one of the following functions on the WHERE clause resolves the current value of the macro variable type?

a. GET
b. SYMGET
c. %SYMGET
d. &RETRIEVE

2 comments | Add One

Leave a Comment