%MDUIMPC

Defines a set of macro variables that create canonical tables and, optionally, creates empty tables for views for CSV files.

Used by:

User import, user synchronization

Syntax

%MDUIMPC (<LIBREF=libref>, <MAKETABLE=0|1|2>, <INFILEREF=fileref>,
<FILEHEADER=1|other_value>);

LIBREF: specifies the output location for any canonical tables or views that are created (the default is Work). If you choose to not create tables or views, this parameter is not used.

MAKETABLE

controls whether any tables or views are created.

0	specifies that no tables or views are created (this is the default).
1	specifies that empty canonical tables are created.
2	specifies that DATA step views of the CSV files in the fileref directory are created.

INFILEREF: specifies the location of the input CSV source files (used only when MAKETABLE=2). The CSV input files must have names and contents that match the table names and structures of the canonical tables. On UNIX, the filenames must be lowercase.

FILEHEADERS

indicates whether the CVS input files have a header line (used only when MAKETABLE=2).

1	indicates that the input files have header information in the first row.
other_value	indicates that the data begins in the first row.

Tables and Macro Variables Created by %MDUIMPC

Table	Purpose	Name/Keep List Global Variable	Column Attributes Macro
person	Create users	&persontbla;	%definepersoncols
location	Store addresses	&locationtbla;	%definelocationcols
phone	Store phone numbers	&phonetbla;	%definephonecols
email	Store e-mail addresses	&emailtbla;	%defineemailcols
idgrps	Create groups and roles	&idgrptbla;	%defineidgrpcols
grpmems	Store membership information	&idgrpmemstbla;	%defineidgrpmemscols
authdomain	Create SAS authentication domains	&authdomtbla;	%defineauthdomcols
logins	Create logins	&logintbla;	%definelogincols