User Import Macros

%MDUIMPC

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

Used in:	User Import, User Synchronization
Depicted in:	Initial Import, Periodic Synchronization

Syntax
Tables and Macro Variables Created by %MDUIMPC

Syntax

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

All parameters for this macro are optional.

LIBREF

specifies the output location for any canonical tables or views that are created (the default is Work).

Note: If you choose to not create tables or views, this parameter is not used. [cautionend]

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 file names 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

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 email 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

See Canonical Tables.

Top of Page