32.WAY TO CREATE MACRO VARIABLES-3

                              WAY TO CREATE MACRO VARIABLES-3


4.CALL SYMPUT:

--->WITH  _N_  IT WILL GIVE A MENTIONED OBSERVATION NUMBER


DATA SAS123;

SET HEART;

CALL SYMPUT('ROY',AVG_MEAN);

RUN;


%PUT &ROY;


DATA SAS13;

SET SASHELP.CLASS;

IF _N_=6 THEN DO;

CALL SYMPUT('KEN',AGE);

END;

RUN;


%PUT &KEN;


DATA SAS12;

SET SASHELP.CLASS;

IF _N_=8 THEN DO;

CALL SYMPUT('KIWI',NAME);

END;

RUN;


%PUT &KIWI;


--->WITHOUT  _N_ IT WILL GIVE LAST OBSERVATION


DATA SAS121;

SET SASHELP.CLASS;

CALL SYMPUT('ENCY',NAME);

RUN;


%PUT &ENCY;


DATA SAS85;

SET SASHELP.CLASS;

CALL SYMPUT('ENCY',SEX);

RUN;


%PUT &ENCY;


DATA SAS852;

SET SASHELP.CLASS;

CALL SYMPUT('EVE',HEIGHT);

RUN;


%PUT &EVE;



5.BY % DO ITRETIVE:


%MACRO EXMP;

DATA ENRI;

%DO I=1 %TO 4;

XX&I=&I;

%END;

RUN;

%MEND;


%EXMP;


ADD ARITHMETIC SYMBOLS


%MACRO TEST;

DATA VARCY;

%DO I=1 %TO 4;

XX&I=&I*5;

%END;

RUN;

%MEND;


%TEST;



REFER 1,2,3 STEPS IN 30.WAY OF CREATE MACROS VARIABLE-1
                              AND    31.WAY TO CREATE MACRO VARIABLES(INTO CLAUSE)-2:



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

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

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

Comments