x cd /pub/data/sf32000/Tools;  %let pgm=access_trbgs;   filename pgm "&pgm..sas";
  *---Access the xxtrbgs data sets stored on Windows server in 626 Clark----;
  %include sascode(mcdcshr3);

 libname xxtrbgs server=mcdc3.mcdcshr3;
   title 'Extract sf32000 tract and bg level data using SAS/Share server to access';

  *---We have 1 data set per state with just the P and H tables at the 140 and 150 (tract and bg) levels--;
 proc sql;
  *---Boone county census tracts---;
  select geocode,  county, tract, p1i1
         from xxtrbgs.motrbgsph
         where county='29019' and sumlev='140';
  *----All tract and bgs in Kent county,  Delaware---;
  select sumlev, county, tract, bg , p1i1
         from xxtrbgs.detrbgsph
         where county='10001';
  quit;

 %include sascode(notify);