Tag: programming languages

Omitting the ORDER BY clause when you create tables and views improve the query performance.

using joins instead of subqueries improve the query performance.

A good practice to improve query performance is using WHERE expressions to limit the size of result tables created with joins.

Must use the ORDER BY clause when you create tables and views.

True

False

call symput(daily_fee, put(fee/days, dollar8.);

%let daily_fee=put(fee/days, dollar8.)

select fee/days format=dollar8. into :daily_fee from sasuser.a

select fee/days format=dollar8. into daily_fee from sasuser.all;

FMTSEARCH

FMTERR

CATALOG

FMTLIB

MODIFY creates a second copy of the data while variables in the data are being matched with a WHERE clause and then deletes the second copy.

You cannot modify the descriptor portion of the data set using the MODIFY statement

You can use the MODIFY statement to change the name of a variable.

If the system terminates abnormally while a DATA step that is using the WHERE statement is processing, SAS automatically saves a copy of the unaltered data set.

SELECT

FROM

WHERE

both a and c

000 Senior

70 Adult

70 Senior

070 Senior

6.1

Fair

Good

. (Missing)

Year, Jan, Feb, Mar, Apr

Year, 2000, 2001, 2002

NAME, Col1, Col2, Col3

NAME, Jan, Feb, Mar, Apr

JDBC is an API to connect to relational-, object- and XML data sources

JDBC stands for Java DataBase Connectivity

JDBC is an API to access relational databases, spreadsheets and flat files

JDBC is an API to bridge the object-relational mismatch between OO programs and relational