Chapter 1: Performing Queries Using Proc SQL
(111).jpg "Chapter 1: Performing Queries Using Proc SQL - Quiz")
Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system or for stream processing in a relational data stream management system. Do you understand how to perform queries using proc SQL? Take up the quiz blow and get to review what you learn it Chapter 1 in preparation for the advanced SAS certification exam that is coming up.
- 1.
Which of the following clauses in the PROC SQL program below is written incorrectly? proc sql; select style sqfeet bedrooms from choice.houses where sqfeet ge 800;
- A.
SELECT
- B.
FROM
- C.
WHERE
- D.
Both a and c
Correct Answer
A. SELECTExplanation
The SELECT clause in the program is written incorrectly. Columns that are listen in the clause must be separated by commas, not just blanks.Rate this question:
-
- 2.
How many statements does the program below contain? proc sql; select grapes, oranges, grapes + oranges as sumsales from sales.produce order by sumsales;
- A.
Two
- B.
Three
- C.
Four
- D.
Five
Correct Answer
A. TwoExplanation
There are two statements, the PROC SQL statement and the SELECT statement. The SELECT statement contains three clauses.Rate this question:
-
- 3.
Complete the following PROC SQL query to select the columns Address and SqFeet from the table List.Size and to select Price from the table List.Proce. (Only the Address column appears in both tables.) proc sql; ___________ where size.address = price.address; from list.size, list.price;
- A.
Select address, sqfeet, price
- B.
Select size.address, sqfeet, price
- C.
Select price.address, sqfeet, price
- D.
Either B or C
Correct Answer
B. Select size.address, sqfeet, priceExplanation
The SELECT clause lists the columns from both tables to be queried. You must use a prefix with the Address column because it appears in both tables. The prefix specifies the table from which you want the column to be read.Rate this question:
-
- 4.
Which of the clauses below correctly sorts rows by the values of the columns Price and SqFeet?
- A.
Order price, sqfeet
- B.
Order by price, sqfeet
- C.
Sort by price sqfeet
- D.
Sort price sqfeet
Correct Answer
B. Order by price, sqfeetExplanation
The ORDER BY clause specifies how the rows are to be sorted. You follow the keywords ORDER BY one or more column names or numbers, separated by columns.Rate this question:
-
- 5.
Which clause below specifies that the two tables Produce and Hardware be queried? Both tables are located in a library to which the libref Sales has been assigned.
- A.
Select sales.produce sales.hardware
- B.
From sales.produce sales.hardware
- C.
From sales.produce, sales.hardware
- D.
Where sales.produce, sales.hardware
Correct Answer
C. From sales.produce, sales.hardwareExplanation
In the FROM clause, you list the names of the tables to be queried, separated by commas.Rate this question:
-
- 6.
Complete the SELECT clause below to create a new column named Profit by subtracting the values of the column Cost from those of the column Price. select fruit,cost,price, _____________
- A.
Profit=price-cost
- B.
Price-cost as Profit
- C.
Profit= price-cost
- D.
Profit as price-cost
Correct Answer
B. Price-cost as ProfitExplanation
To create a new column and assign a column alias to the column, you specify the following in the SELECT clause, in the order shown here: an expression, (optionally) the keyword AS, and column alias. The case that you use when you create the column name is the one that will be displayed in the output.Rate this question:
-
- 7.
What happens if you use a GROUP BY clause in a PROC SQL step without a summary function?
- A.
The step does not execute.
- B.
The first numeric column is summed by default.
- C.
The GROUP BY clause is changed to an ORDER BY clause
- D.
The step executes but does not group or sort data.
Correct Answer
C. The GROUP BY clause is changed to an ORDER BY clauseExplanation
The GROUP BY clause is used in queries that include one or more summary functions. If you specify a GrOUP BY clause in a query that does not contain a summary function, it is changed to an ORDER BY clause.Rate this question:
-
- 8.
If you specify a CREATE TABLE statement in your PROC SQL step,
- A.
the results of the query are displayed, and a new table is created.
- B.
A new table is created, but it does not contain any summarization that was specified in the PROC SQL step.
- C.
A new table is created, but no report is displayed.
- D.
Results are grouped by the value of the summarized column.
Correct Answer
C. A new table is created, but no report is displayed.Explanation
The CREATE TABLE statement enables you to store your results in a SAS table instead of displaying the query results as a report.Rate this question:
-
- 9.
Which statement is true regarding the use of the PROC SQL step to query data that is stored in two or more tables?
- A.
When you join multiple tables, the tables must contain a common column.
- B.
You must specify the table from which you want each column to be read.
- C.
The tables that are being joined must be from the same type of data source.
- D.
If two tables that are being joined contain a same-named column, thenn you must specify the table from which you want the column to be read.
Correct Answer
D. If two tables that are being joined contain a same-named column, thenn you must specify the table from which you want the column to be read.Explanation
When using the PROC SQL step to query data from multiple tables, if there are two tables being joined that have a column with the same name, you must specify the table from which you want to retrieve the column. This is necessary to avoid any ambiguity and ensure that the correct column is selected from the appropriate table.Rate this question:
-
- 10.
Which clause in the following program is incorrect? proc sql; select sex, mean(weight) as avgweight from company.employees company.health where employees.id=health.id group by sex;
- A.
SELECT
- B.
FROM
- C.
WHERE
- D.
GROUP BY
Correct Answer
B. FROMExplanation
Tables in the from statement must be separated by a comma (,)Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 04, 2013Quiz Created by
Moxleyv
Back to top