/* File name: /home/nwu/pledesma/naics-select.sas   */
/* Program for example 2 in Feb 18, 2002 workshop   */
/* Written by: P. Ledesma                           */


proc sql;
  create table out.naicsyrs as select
  compann.gvkey, compann.naics, compann.yeara, compann.smbl,
  compann.coname, compann.data6, compann.data36
  from comp.compann
  where compann.naics in ("322130" "334612") and compann.yeara >= 1996;
quit;
proc print data=out.naicsyrs;