assertprimarykey.sas File Reference

Checks whether a set of columns can be used as primary key for the data set. More...

Go to the source code of this file.

Detailed Description

Checks whether a set of columns can be used as primary key for the data set.

Version

$Revision: 316 $

Author

$Author: akirchmann $

Date

$Date: 2014-03-02 10:20:58 +0100 (So, 02 Mrz 2014) $

See Also

For further information please refer to SASUnit User's Guide Here you can find the SASUnit documentation, release notes and license information.

$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/saspgm/sasunit/assertprimarykey.sas $

Copyright

Copyright 2010, 2012 HMS Analytical Software GmbH. This file is part of SASUnit, the Unit testing framework for SAS(R) programs. For terms of usage under the GPL license see included file readme.txt or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/.

Parameters

i_Library	library of data set treated as master table
i_Dataset	member name of data set treated as master table
i_Variables	variables of the data set, that should be used as key. Multiple variables have to be separated by blank
i_desc	a description of the test default: "Check for primary key"
o_maxReportObs	optional: maximum number of records to be listed where lookup failed. By default set to MAX
o_listingVars	additional variables from master dataset to be listed. Additional variables have to be separated by blanks
o_treatMissings	optional: Handling of missing values in the master data set: Possible parameters are IGNORE, DISALLOW, VALUE(default)

Definition in file assertprimarykey.sas.