SAS Advanced
Programming STUDY
GUIDE TEST
QUESTIONS &
ANSWERS ALREADY
GRADED A+ 2025
Practice questions for this set
, Learn 1/ 7 Study with Learn
proc sql; describe table discount; quit;
Choose matching term
Write code to display a list of
columns and column attributes for What is the wildcard character for
1 2
the discount table (not PROC any single character?
CONTENTS)
Write code to complete a Cartesian
3 What does DBMS stand for? 4
product of tables One and Two
Don't know?
Terms in this set (122)
Write code to write the proc sql feedback; select * from certadv.s taff changes; quit;
expanded list of all columns
to the SAS log, from the
certadv. staff changes
dataset
What algorithm does the SOUNDEX
Sounds-like operator use?
, Write code to select rows proc sql; select address from frequent flyers where address like
from frequent flyers where "%P%PLACE"; quit;
address street name begins
with P and ends with the
word PLACE
What is the wildcard %
character for any
sequence of 0 or more
characters?
What is the wildcard _
character for any single
character?
Write code to use the lastname =* "Smith";
sounds-like operator to
select any lastname that
sounds like Smith
NMISS
To count the number of
missing values, use the ___
function
Write code to select only 5 proc sql noexec inobs=5 number; select * from dog; quit;
rows, and all columns, from
the dog table, and include a
column named Row that
displays row numbers.
Choose not to run the query
but to only validate kit.
Write code to create a table proc sql; create table flightdelays2 like flightdelays; quit;
flightdelays2 containing the
aame columns and attributes
as flightdelays; but with no
rows.
Programming STUDY
GUIDE TEST
QUESTIONS &
ANSWERS ALREADY
GRADED A+ 2025
Practice questions for this set
, Learn 1/ 7 Study with Learn
proc sql; describe table discount; quit;
Choose matching term
Write code to display a list of
columns and column attributes for What is the wildcard character for
1 2
the discount table (not PROC any single character?
CONTENTS)
Write code to complete a Cartesian
3 What does DBMS stand for? 4
product of tables One and Two
Don't know?
Terms in this set (122)
Write code to write the proc sql feedback; select * from certadv.s taff changes; quit;
expanded list of all columns
to the SAS log, from the
certadv. staff changes
dataset
What algorithm does the SOUNDEX
Sounds-like operator use?
, Write code to select rows proc sql; select address from frequent flyers where address like
from frequent flyers where "%P%PLACE"; quit;
address street name begins
with P and ends with the
word PLACE
What is the wildcard %
character for any
sequence of 0 or more
characters?
What is the wildcard _
character for any single
character?
Write code to use the lastname =* "Smith";
sounds-like operator to
select any lastname that
sounds like Smith
NMISS
To count the number of
missing values, use the ___
function
Write code to select only 5 proc sql noexec inobs=5 number; select * from dog; quit;
rows, and all columns, from
the dog table, and include a
column named Row that
displays row numbers.
Choose not to run the query
but to only validate kit.
Write code to create a table proc sql; create table flightdelays2 like flightdelays; quit;
flightdelays2 containing the
aame columns and attributes
as flightdelays; but with no
rows.
