SAS- FINAL EXAM QUESTIONS WITH
100% CORRECT ANSWERS LATEST
VERSION 2025/2026.
The CREATE TABLE statement that includes a LIKE clause copies __________ only. -
ANS column names and attributes
In order to create a table with 1 row of information selected, you need... - ANS PROC SQL;
CREATE TABLE ______ AS
SELECT*
FROM
WHERE _ = 'selected row'
Which of the following PROC SQL steps creates a table that contains rows for the level-1 flights
attendants only?
Question 2 options:
a)
proc sql;
Create Table Work.newpayroll as
select *
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,from sasuser.payrollmaster
where jobcode='FA1';
b)
proc sql;
create work.newpayroll as
select *
from sasuser.payrollmaster
where jobcode='FA1';
c)
proc sql;
create table work.newpayroll as
select *
copy sasuser.payrollmaster
where jobcode='FA1';
d)
proc sql;
create table work.newpayroll as
select *
sasuser.payrollmaster
where jobcode='FA1'; - ANS a)
proc sql;
Create Table Work.newpayroll as
select *
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,from sasuser.payrollmaster
where jobcode='FA1';
Which of the following PROC SQL steps creates a new table by copying only the column
structure (but not the rows) of an existing table?
A)
proc sql;
create table work.newpayroll as
select *
from sasuser.payrollmaster;
B)
proc sql;
create table work.newpayroll
like sasuser.payrollmaster;
C)
proc sql;
create table work.newpayroll as
copy sasuser.payrollmaster;
D)
proc sql;
create table work.newpayroll as
describe sasuser.payrollmaster; - ANS B)
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, proc sql;
create table work.newpayroll
like sasuser.payrollmaster;
Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?
a.It must be used with the REQUIRED integrity constraint.
b.It ignores the specified integrity constraints if any of the rows that you want to insert or
update do not meet the constraint criteria.
c.It restores your table to its original state if any of the rows that you try to insert or update do
not meet the specified integrity constraint criteria.
d.It allows rows that meet the specified integrity constraint criteria to be inserted or updated,
but rejects rows that do not meet the integrity constraint criteria. - ANS c.It restores your
table to its original state if any of the rows that you try to insert or update do not meet the
specified integrity constraint criteria.
___________ is the default setting for PROC SQL. This setting undoes all inserts or updates if 1
or more rows violate the integrity constraint criteria, and restores the table to its original state
before the inserts or updates - ANS UNDO POLICY=REQUIRED
Which of the following is not a type of integrity constraint?
a.CHECK
b.NULL
c.UNIQUE
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
100% CORRECT ANSWERS LATEST
VERSION 2025/2026.
The CREATE TABLE statement that includes a LIKE clause copies __________ only. -
ANS column names and attributes
In order to create a table with 1 row of information selected, you need... - ANS PROC SQL;
CREATE TABLE ______ AS
SELECT*
FROM
WHERE _ = 'selected row'
Which of the following PROC SQL steps creates a table that contains rows for the level-1 flights
attendants only?
Question 2 options:
a)
proc sql;
Create Table Work.newpayroll as
select *
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,from sasuser.payrollmaster
where jobcode='FA1';
b)
proc sql;
create work.newpayroll as
select *
from sasuser.payrollmaster
where jobcode='FA1';
c)
proc sql;
create table work.newpayroll as
select *
copy sasuser.payrollmaster
where jobcode='FA1';
d)
proc sql;
create table work.newpayroll as
select *
sasuser.payrollmaster
where jobcode='FA1'; - ANS a)
proc sql;
Create Table Work.newpayroll as
select *
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
,from sasuser.payrollmaster
where jobcode='FA1';
Which of the following PROC SQL steps creates a new table by copying only the column
structure (but not the rows) of an existing table?
A)
proc sql;
create table work.newpayroll as
select *
from sasuser.payrollmaster;
B)
proc sql;
create table work.newpayroll
like sasuser.payrollmaster;
C)
proc sql;
create table work.newpayroll as
copy sasuser.payrollmaster;
D)
proc sql;
create table work.newpayroll as
describe sasuser.payrollmaster; - ANS B)
3 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, proc sql;
create table work.newpayroll
like sasuser.payrollmaster;
Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?
a.It must be used with the REQUIRED integrity constraint.
b.It ignores the specified integrity constraints if any of the rows that you want to insert or
update do not meet the constraint criteria.
c.It restores your table to its original state if any of the rows that you try to insert or update do
not meet the specified integrity constraint criteria.
d.It allows rows that meet the specified integrity constraint criteria to be inserted or updated,
but rejects rows that do not meet the integrity constraint criteria. - ANS c.It restores your
table to its original state if any of the rows that you try to insert or update do not meet the
specified integrity constraint criteria.
___________ is the default setting for PROC SQL. This setting undoes all inserts or updates if 1
or more rows violate the integrity constraint criteria, and restores the table to its original state
before the inserts or updates - ANS UNDO POLICY=REQUIRED
Which of the following is not a type of integrity constraint?
a.CHECK
b.NULL
c.UNIQUE
4 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
