30.WAY TO CREATE MACRO VARIABLES-1

                                       WAYS TO CREATE MACRO VARIABLES-1


1.BY    %LET:


%LET DATE=&SYSDATE9;

%PUT THIS IS DATE  &DATE;


%LET XX=SASHELP.CLASS;

%PUT &XX;


%LET CLASS=SASHELP.CLASS;


PROC CONTENTS DATA=&CLASS;

RUN;


PROC FREQ DATA=&CLASS;

RUN;

 

%LET CARSS=SASHELP.CARS;


PROC MEANS DATA=&CARSS;

VAR MSRP;

RUN;


%LET A=IDDCR;

%LET B=HYDERABAD;

%PUT &A &B;


2.BY MACRO PARAMETER(KEYWORD AND POSITIONAL AND  MIXED PARAMETERS):


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

PROC MEANS DATA=&INPUT;

VAR &IVAR;

OUTPUT OUT=&OUTPUT;

RUN;

%MEND;

%REDDY(INPUT=SASHELP.HEART,IVAR=AgeAtStart,OUTPUT=REDDY);


REFER 29.MACRO PARAMETERS FOR ABOVE WAY OF CREATING MACROS:


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

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

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


Comments