Example 3: Creating BFD Schemes

Blue Fusion Data schemes can be read by SAS and by the dfPower Studio software. Generating Blue Fusion Data schemes is advantageous when you want to use dfPower to edit those schemes. The following example generates three schemes in Blue Fusion Data format. Also note that the locale ENUSA is assumed to have been loaded into memory as part of the locale list.

/* Create filerefs with required suffixes. */
filename city 'c:\my schemes\city.sch.bfd';
filename state 'c:\my schemes\state.sch.bfd';
filename org 'c:\my schemes\org.sch.bfd';

/* Create the input data set. */
data vendors;
  input city $char17. state $char22. company $char36.;
datalines;
Detroit          MI                     Ford Motor
Dallas           Texas                  Wal-mart Inc.
Washington       District of Columbia   Federal Reserve Bank

/* See Example 3: Creating BFD Schemes for the full data set. */

Washington       District of Columbia   Federal Reserve Bank
Atlanta          GEORGIA                Target
;
run;

proc dqscheme data=vendors bfd;
  create matchdef='City (Scheme Build)'
    var=city scheme=city locale='ENUSA';
  create matchdef='State (Scheme Build)' 
     var=state scheme=state locale='ENUSA';
  create matchdef='Organization (Scheme Build)' 
     var=company scheme=org locale='ENUSA';
run;

This example is available in the SAS Sample Library under the name DQBFDSCH.

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.