Free SAS Institute A00-232 Exam Questions

Which clause in the following program is incorrect?proc sql;select age,mean(weight) as avgweight    from certadv.employees certadv.health    where employees.id=health.id    group by age;quit;

What value will these statements assign to the macro variable Reptile?%let area = "Southeast";%let reptitle = * Sales Report for &area Area *;

The keyword ALL cannot be used with which of the following set operators?

In which step does the SAS hash object exist?

Consider this PROC SQL query:proc sql;select flightnumber,        count(*) as Flights,        avg(boarded)        label="Average Boarded"        format=3.    from certadv.internationalflights    group by flightnumber    having avg(boarded) > 150;quit;The table Certadv.Internationalflights contains 201 rows, 7 unique values of FlightNumber, 115 unique values of Boarded, and 4 different flight numbers that have an average value of Boarded that is greater than 150. How many rows of output will the query generate?