93.%LET | % PUT | MACROS | SIMPLE EXAMPLES

%MACRO SORT(DS,NVAR,OUTPUT);

PROC SORT DATA=&DS OUT=&OUTPUT;

BY &NVAR;

RUN;

%MEND;

PROC PRINT;RUN;

%SORT(SASHELP.CLASS,AGE,A0);

OUTPUT:

The SAS System

Obs	Name	Sex	Age	Height	Weight
1	Joyce	F	11	51.3	50.5
2	Thomas	M	11	57.5	85.0
3		M	12	57.3	83.0
4		M	12	59.0	99.5
5	James	M	12	57.3	83.0
6	Jane	F	12	59.8	84.5
7	John	M	12	59.0	99.5
8	Louise	F	12	56.3	77.0
9	Robert	M	12	64.8	128.0
10		F	13	56.5	84.0

HERE I HAVE GIVEN ONLY FIRST 10 OBSERVATIONS DUE TO OVER LENGTH ...

%LET AA='Alice';

%LET BB='F';

%PUT &AA &BB;

PROC print DATA=SASHELP.CLASS;

WHERE Name=&AA AND Sex=&BB;

RUN;

OUTPUT:

The SAS System

Obs	Name	Sex	Age	Height	Weight
6	Alice	F	13	56.5	84

*/TRY WITH AND WITHOUT APOSTROPHE THEN COMMENT YOUR RESULTS*/

%LET AA='Alfred';

%LET BB='M';

%PUT &AA &BB;

PROC PRINT DATA=SASHELP.CLASS;

WHERE Name=&AA AND Sex=&BB;

RUN;

OUTPUT:

The SAS System

Obs	Name	Sex	Age	Height	Weight
5	Alfred	M	14	69	112.5

TO LEARN MORE ABOUT MACRO CLICK HERE

TRY THIS AND COMMENT YOUR ANSWER...

-->PLEASE READ AND COMMENT THE BLOG...

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

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES

Sas All