1. Back up the existing Fair Banking solution
2. Copy <sasroot>\hmdamva\sashelp\*.* to <rootpath>\global\custom\parameter
3. Copy <sasroot>\hmdamva\sasmisc\data_model\l_yyyys\* to <rootpath>\global\install\ddl\sas
4. Copy <sasroot>\hmdamva\sasmisc\data_model\l_ext\* to <rootpath>\global\install\ddl\sas
5. Copy <sasroot>\hmdamva\sasmisc\setup\* to <rootpath>\global\install\setup
6. Copy <sasroot>\hmdamva\sasstp\sfb_autoexec_all.sas to <rootpath>\global\control
7. Start up Fair Banking SAS environment and run the following codes.
%inc "&rootpath\global\install\setup\load_job_list.sas";
%sfb_rate_job_driver ;
%inc "&rootpath\global\install\setup\load_columns.sas";
%apply_app_detail_ddl(hmda_or_cra=HMDA);
8. If HMDA data has been loaded before the hotfix is installed, run the following macro for the current submission year.
%apply_edits_to_master(hmda_or_cra=HMDA);
%sfb_reporting_job_driver;
9. Verify the installation.
a. L_SYS.L_FORMAT_CNTL should have a record with FOR_COLUMN=’FIXED_MORTGAGE_FLG’
b. L_SYS.L_COUNTY_CODE should not have records with county_desc contains ‘(CA)’.
c. CNTL.JOB_LIST should have a record with MACRO_CALL=’sfb_rate_job_driver’
d. L_EXT.EXT_RATE_ARM and L_EXT.EXT_RATE_FIXED should have a lot of records.
e. CNTL.COLUMNS should have records with NAME in (‘FIXED_MORTGAGE_FLG’ , ‘LOAN_TERM_FIXED_FOR_ARM’ , ‘PRIME_RATE_USED_RT’ ‘PRIME_RATE_USED_DT’)
f. L_<yyyy>s.APP_HMDA_DETAIL_CURR/ERR/AUDIT tables should have columns FIXED_MORTGAGE_FLG, LOAN_TERM_FIXED_FOR_ARM, PRIME_RATE_USED_RT, and PRIME_RATE_USED_DT.
g. Columns FIXED_MORTGAGE_FLG and LOAN_TERM_FIXED_FOR_ARM are added to the current year HMDA correction spreadsheets in <rootpath>\ C:\sas\SFBEntBI\Lev1\Applications\SASFairBanking\4.1\web_imart\error_download\hmda if the spreadsheets exist.
The problem described in SAS Note 38307 , requires a customized Dataflux
service job that can geocode a street address spanning 2 lines.
Follow the steps below to switch to your customized job.
Copy your customized DataFlux service job to:
<DATAFLUXHOME>/DIS/8.1/svc_job (rename the
file to include the .dmc extension).
Modify the following line in
<SASCONFIGDIR>/Lev1/Applications/SASFairBanking/4.1/global/control/sfb_autoexec_all.sas
call symputx('dfservice','SASFairBanking_AddressVerify_Geocoding');
to replace 'SASFairBanking_AddressVerify_Geocoding’
with your new service job name.