INSTALLATION INSTRUCTIONS FOR HOT FIX 81FAIRBNKG01 ON UNIX BEFORE DOWNLOADING: The hot fix 81FAIRBNKG01 addresses the issue(s) in 8.1 of SAS Fair Banking software on UNIX as documented in the "Issue(s) Addressed" section of the hot fix download page: http://ftp.sas.com/techsup/download/hotfix/fairbnkg.html#81fairbnkg01 IMPORTANT NOTE(S): 1. You must have SAS Fair Banking 8.1 installed on your system before applying this hot fix. 2. The hotfix must be installed using the same userid that performed the initial SAS Fair Banking 8.1 installation. 3. You must have Administrator Privileges on your CLIENT or SERVER machine. 4. All currently active SAS sessions, daemons, spawners and servers must be terminated before applying this hot fix. 5. The following pre-installation steps must be completed before installing the hotfix. = (configuration folder)/Lev1/clients/hmdamva =(sas install) A. Backup everything under /global. B. Backup everything under /ucmacros/hmdamva/ C. Backup everything under /global/externaldata D. Backup everything under /global/custom/parameter E. Make build_edit_engine.sas and updatesuppresseditrec.sas under /ucmacros/hmdamva/ writable. F. Make q044.sas and q045.sas under /global/srccode/hmdaedits writable by removing the readonly attribute on the files. G. Remove all files in /global/srccode/editsengine INSTALLING THIS HOT FIX: These instructions assume that SAS Fair Banking 8.1 have been installed in the following locations: /ucmacros/hmdamva/ If you have installed these products in a different location, you will need to modify the paths in these instructions accordingly. 1. Technical Support strongly suggests that you back up the files being replaced by this hot fix. You should always try to include the current date in the name of the backup file created to distinguish between versions of backup files. By doing this you will maintain a history of the file, which will be helpful when multiple iterations of a hot fix have been applied to the same file. For example, cp sas.foo.tar sas.foo.tar.07012006 where 07012006 is the date when the hot fix is applied. The . extension MUST be appended AFTER the .tar extension as it appears above. The files that should be backed up for this hot fix are: /ucmacros/hmdamva/build_edit_engine.sas /ucmacros/hmdamva/table1.sas /ucmacros/hmdamva/updatesuppresseditrecs.sas >/misc/hmdamva/hmda_edit/q044.sas >/misc/hmdamva/hmda_edit/q045.sas /global/externaldata/ext_geo.sas7bdat /global/externaldata/ext_geo.sas7bndx /global/externaldata/ext_hud_ma_mfi.sas7bdat /global/externaldata/ext_ma_count.sas7bdat /global/externaldata/ext_ma_count.sas7bndx /global/custom/parameter/l_ma.sas7bdat /global/custom/parameter/l_ma.sas7bndx 2. Download the following files from http://ftp.sas.com/techsup/download/FairBanking/ExtDataUpdate/ by right clicking on each individual file and saving it to a convenient location on your file system. If you have trouble downloading these files, please contact SAS Technical Support for assistance. Please note that the installation of these files will be completed in the "MANUAL POST-INSTALLATION STEPS" listed below. readme.txt census_ext.cpo census_sys.cpo censusdata_install.sas 3. Navigate to the directory by using the cd command. Once in this directory, unarchive the Hotfix tar file using the following command: tar -xvf 81fairbnkg01xx.tar where xx is the appropriate suffix for your unix platform, such as 's6' or r6'. This will extract the updated files to your Fair Banking installation. 4. To verify the installation of the hot fix, confirm that the files in the locations below have been updated to the level indicated by the date provided: /ucmacros/hmdamva/build_edit_engine.sas 06/09/2008 /ucmacros/hmdamva/table1.sas 06/09/2008 /ucmacros/hmdamva/updatesuppresseditrecs.sas 06/09/2008 /misc/hmdamva/hmda_edit/q044.sas 06/09/2008 /misc/hmdamva/hmda_edit/q045.sas 06/09/2008 MANUAL POST-INSTALLATION STEPS: 1. Copy the q044.sas and q045.sas programs from /misc/hmdamva/hmda_edit to /global/srccode/hmdaedits 2. Start up SAS with the SAS Fair Banking configuration in SAS Display Manager or Enterprise Guide. (The SAS Fair Banking configuration files sfb_autoexec_all.sas and sasv9.cfg are in !ROOTPATH/global/control.) 3. Open the censusdata_install.sas program from your SAS Display Manager or Enterprise Guide session. Modify the default cpopath to point to the location where you downloaded the census_ext.cpo and census_sys.cpo files. Execute the censusdata_install.sas program. 4. Verify that the files in the locations below have been updated to reflect the current date: /global/externaldata/ext_geo.sas7bdat /global/externaldata/ext_geo.sas7bndx /global/externaldata/ext_hud_ma_mfi.sas7bdat /global/externaldata/ext_ma_count.sas7bdat /global/externaldata/ext_ma_count.sas7bndx /global/custom/parameter/l_ma.sas7bdat /global/custom/parameter/l_ma.sas7bndx 5. Execute the following macro to update the edit engine: %build_edit_engine; 6. Check SAS log to make sure there are no errors. 7. Check /global/srccode/editengine to make sure all the files have the new creation datetime. If there are any 2005 HMDA loans in l_2005s.app_hmda_detail_*, run the following code: a. %let sub_year=2005; %apply_edits_to_master(hmda_or_cra=HMDA); 8. If there are any 2008 HMDA/CRA loans in l_2008s.app_hmda_detail_* or l_2008s.app_cra_detail_* with a state_code=’12’ and a county_code in (‘081’,’115’), run the following macros to update the MA values for each loan and regenerate the reporting data: a. For CRA loan updates, execute the following code: %let sub_year=2008; %apply_edits_to_master(hmda_or_cra=CRA); For HMDA loan updates, execute the following code: %let sub_year=2008; %apply_edits_to_master(hmda_or_cra=HMDA); b. For reporting data updates, execute the following code: %let sub_year=2008; %reporting_driver; 9. Restart all SAS sessions, daemons, spawners and servers. NOTE: This hotfix does not deal with the changes of the edit description of Q044 and Q045. For 2005, the description of Q044 and Q045 for 2006+ is still being used. It will be fixed in the next release. This completes the installation of hotfix 81FAIRBNKG01