Data Integrity Quizzes, Questions & Answers

Top Trending Data Integrity Quizzes

SAS Chapter 18: Modifying SAS Data Sets And Tracking Changes

Explore key SAS data set modifications and integrity constraints in this quiz. Master skills like creating audit trails, using transaction data sets for updates, and applying integrity constraints to ensure data quality....

Questions: 10 | Attempts: 130 | Last updated: Jul 24, 2024

Sample Question 1
Which type of integrity constraint would you place on the variable StoreID to ensure that there are no missing values and that there are no duplicate values?

UNIQUE

CHECK

PRIMARY KEY

NOT NULL

Sample Question 2
Which code creates an audit trail on the SAS data set Reports.Quarter1?

proc datasets nolist; audit quarter1; initiate; quit;

proc datasets lib=reports nolist; audit initiate reports.quarter1; quit;

proc datasets lib=reports nolist; initiate audit quarter1; quit;

proc datasets lib=reports nolist; audit quarter1; initiate; quit;

Sample Question 3
Which DATA step uses the transaction data set Records.Overnight to update the master data set Records.Snowfall by accumAmt?

data records.snowfall; modify records.snowfall records.overnight key=accumAmt; run;

data records.snowfall; modify records.overnight records.snowfall; by accumAmt; run;

data records.snowfall; modify records.snowfall records.overnight; by accumAmt; run;

data records.snowfall; modify records.snowfall records.overnight; update accumAmt; run;