Previous Page | Next Page

User Import Macros


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

Tables and Macro Variables Created by %MDUIMPC


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

All parameters for this macro are optional.


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]


controls whether any tables or views are created.


specifies that no tables or views are created (this is the default).


specifies that empty canonical tables are created.


specifies that DATA step views of the CSV files in the fileref directory are created.


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.


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


indicates that the input files have header information in the first row.


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.

Previous Page | Next Page | Top of Page