29.MACRO PARAMETERS

                                    MACRO PARAMETERS

1.NAMED/KEYWORD PARAMETER(=):IT CONSISTS OF EQUAL SIGN

2.POSITIONAL PARAMETER( NO NEED OF =):NO NEED OF EQUAL SIGN

3.MIXED PARAMETER(COMBINATION OF = NE):COMBINATION OF EQUAL SIGN 

1.NAMED PARAMETER/KEYWORD(=):

%MACRO DIVYA (INPUT=,IVAR=,OUTPUT=);

PROC MEANS DATA=&INPUT;

VAR &IVAR;

OUTPUT OUT=&OUTPUT;

RUN;

%MEND;

%DIVYA(INPUT=SASHELP.HEART,IVAR=HEIGHT,OUTPUT=TEST);

%DIVYA(INPUT=SASHELP.CLASS,IVAR=AGE,OUTPUT=AGEDAT);

%TEST(INPUT=PROG1.SALES,IVAR=SALARY,OUTPUT=SALDATA);

%TEST(INPUT=SASHELP.CARS,IVAR=MSRP,OUTPUT=CARSS);

2.POSITIONAL PARAMETER(NO NEED OF =):

%MACRO TEST (INPUT,IVAR,OUTPUT);

PROC MEANS DATA=&INPUT;

VAR &IVAR;

OUTPUT OUT=&OUTPUT;

RUN;

%MEND;

%TEST(SASHELP.CLASS,AGE,TEST1); 

%TEST(SASHELP.CARS,MSRP,CARSS);

3.MIXED PARAMETER(IT WILL COMBINATION OF KEYWORD(=)AND POSITIONAL PARAMETER(EMPTY):

%MACRO TEST23 (INPUT,IVAR=,OUTPUT);

PROC MEANS DATA=&INPUT;

VAR &IVAR;

OUTPUT OUT=&OUTPUT;

RUN;

%MEND;

%TEST(SASHELP.CLASS,&IVAR=AGE,TEST23); 

--PLEASE FOLLOW THE BLOG FOR MORE INFO....

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

   CLICK HERE: https://t.me/SasAll4You