templatePattern4

%macro accessSAS(connectParameters,selectRecordParameters);

%macro connectDB(num,char);
%put SAS ConnectDB;
%mend connectDB;

%macro selectRecords(num,char);
%put SAS Record Selection;
%mend selectRecords;

%macro doQuery;
* doQuery is the same for all macros;
%connectDB&connectparameters.;
%selectRecords&selectRecordParameters.;
%mend doQuery;

%doQuery;
%mend accessSAS;

%macro accessSQLServer(connectParameters,selectRecordParameters);

%macro connectDB(num,char);
%put SQL Server ConnectDB;
%mend connectDB;

%macro selectRecords(num,char);
%put SQL Server Record Selection;
%mend selectRecords;

%macro doQuery;
* doQuery is the same for all macros;
%connectDB&connectparameters.;
%selectRecords&selectRecordParameters.;
%mend doQuery;

%doQuery;
%mend accessSQLServer;

%accessSAS(connectParameters=(num=1,char=SAS),
selectRecordParameters=(num=2,char=SAS));

%accessSQLServer(connectParameters=(num=1,char=SQLServer),
selectRecordParameters=(num=2,char=SQLServer));