S&P 500 Constituents from CRSP

sp500.sas

proc sql;
    create table out.sp500 as
        select distinct a.permno, a.date,
        a.permco,
        c.ncusip as CUSIP,
        c.exchcd,
        c.tsymbol,
        c.shrcls
        from crsp.msf a,
        crsp.msp500list b,
        crsp.msenames c
        where a.permno = b.permno
        and b.start <= a.date <= b.ending
        and a.permno = c.permno
        and c.namedt <= a.date <= c.nameendt
        and year(a.date) ge 2011
        order by a.permno, a.date;
quit;
proc print data=&syslast.(obs=25) width=min;run;