mp_guesspk.sas File Reference

Guess the primary key of a table. More...

Go to the source code of this file.

Detailed Description

Tries to guess the primary key of a table based on the following logic:

  Columns with nulls are ignored
  Return only column combinations that provide unique results
  Start from one column, then move out to composite keys of 2 to 6 columns

The library of the target should be assigned before using this macro.

Usage:

filename mc url
  "https://raw.githubusercontent.com/sasjs/core/main/all.sas";
%inc mc;
%mp_guesspk(sashelp.class,outds=classpks)

Parameters

[in]	baseds	The dataset to analyse
[out]	outds=	(mp_guesspk) Output dataset to contain the possible PKs
[in]	max_guesses=	(3) The total number of possible primary keys to generate. A table may have multiple (unlikely) PKs, so no need to list them all.
[in]	min_rows=	(5) The minimum number of rows a table should have in order to try and guess the PK.
[in]	ignore_cols	(0) Space seperated list of columns which you are sure are not part of the primary key (helps to avoid false positives)
[in]	mdebug=	Set to 1 to enable DEBUG messages and preserve outputs

SAS Macros

• mf_getvarlist.sas
• mf_getuniquename.sas
• mf_wordsInstr1butnotstr2.sas
• mf_nobs.sas

Related Macros

• mp_getpk.sas

Version

9.3

Author

Allan Bowe

Definition in file mp_guesspk.sas.