- /*select some id from formc ,who meet formc='y' and mmajor=3*/
- proc sql noprint;
- create table formc1 as select distinct studentid from formc
- where formc='y' and mmajor=3;
- /*inner join zip to get zip code list*/
- create table final as select distinct a.id,a.zip from zip a
- inner join formc1 b on a.id=b.studentid;
- quit;