*-----redefine all the xxsums SAS views so that the geocodes precede the counts.  jgb, 4-7-01.
      run interactively;


proc sql;
%macro doit(state,stab);
 create view pl942000.&stab.sums as
   select * from &stab.geos g, &stab.sumsng d
   where g.geo_id=d.geo_id;
 %mend doit;

%dostates(n=51);

  quit;