31.WAY TO CREATE MACRO VARIABLES(INTO CLAUSE)-2

                  WAY TO CREATE MACRO VARIABLES(INTO CLAUSE)-2

3.BY INTO CLAUSE IN PROC SQL:

PROC MEANS DATA=SASHELP.HEART;

VAR HEIGHT;

OUTPUT OUT=HEART MEAN=AVG_MEAN;

RUN;

PROC SQL;

SELECT AVG_MEAN INTO :ABC

FROM HEART;

QUIT;

%PUT &ABC;

PROC SQL;

SELECT MEAN(HEIGHT) INTO :BOT

FROM SASHELP.CLASS;

QUIT;

%PUT ⊥

PROC SQL;

SELECT AVG(AGE) INTO :CBA

FROM SASHELP.CLASS;

QUIT;

%PUT &CBA;

PROC SQL;

SELECT MEAN(WEIGHT) INTO:A1

FROM SASHELP.CLASS;

QUIT;

%PUT &A1;

PROC SQL;

SEELCT SUM(CYLINDERS) INTO:C1

FROM SASHELP.CARS;

QUIT;

%PUT &C1;

REFER FOR 1 AND 2 STEPS 30.WAY OF CREATE MACROS VARIABLE-1:

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

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

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