* SAS MACRO VIDEO SCRIPT;
LIBNAME STAT408 "/courses/d716b355ba27fe300";
/* MACRO VARIABLES */

%LET year = 1993;

TITLE "MLB players born in &year";
PROC SQL;
    SELECT * 
    FROM STAT408.player
    WHERE birth_year = &year;
RUN;
TITLE;

/* MACRO STATEMENTS */

%MACRO yearborn (year =, create=);
	LIBNAME STAT408 "/courses/d716b355ba27fe300";

    TITLE "MLB players born in &year";
    PROC SQL;
        SELECT * 
        FROM STAT408.player
        WHERE birth_year = &year;
    RUN;
    TITLE;
    
    %IF &create = 'YES' %THEN %DO;
        PROC SQL;
            CREATE TABLE born&year as
            SELECT *
            FROM STAT408.player
            WHERE birth_year = &year;
        RUN;
    %END;
%MEND yearborn;

%yearborn(year = 1995, create= 'YES');
%yearborn(year = 1994, create= 'NO');
%yearborn(year = 1993, create= 'YES');