How to add Relative Standard Error (RSE) to a Survey Module

In this example we will be adding the Relative Standard Error to the BRFSS query module.

1. The first step is always to update your local version of your tomcat files to make sure you are working with the most current files.

2. Go to C:\tomcat\webapps\ibisph-view\xml\query\module\brfss and open FRFSSCrude.xml (or the xml you are working on)

FRONT END
1. You will be adding a new column to the output page on the query module. You will need to insert the following text:

                <MEASURE>
		    <NAME>CV</NAME>
		    <TITLE>Coefficient of Variation (%)</TITLE>
		    <DESCRIPTION>Coefficient of Variation for Percentage</DESCRIPTION>
                    <XSLT_FORMAT_PATTERN>#0.00</XSLT_FORMAT_PATTERN>
		</MEASURE>

…. Directly after the following existing code:

		<UPPER_CONFIDENCE_LIMIT>
			<TITLE>Confidence Bounds - Upper Limit</TITLE>
			<DESCRIPTION>Confidence Bounds - Upper Limit</DESCRIPTION>
		</UPPER_CONFIDENCE_LIMIT>
	</MEASURE>

2. CHANGE func parameter name by adding ‘_cv’ (use find and replace .def with _cv.def) so that the look like the following:

		<PARAMETER>
			<NAME>func</NAME>
             From:      <VALUE>GeneralHlthStat.def</VALUE>
             To:	<VALUE>GeneralHlthStat_cv.def</VALUE>
		</PARAMETER>

You will be creating a new func file for the module later.

You will need to do these two steps for every parameter name for the:

1. Data table and chart
2. Data table and Quartile map
3. Data table and High-Low-Same Map

BACK END
1. Open WinSCP

2. Open /srv/ibis-q/modules/BRFSS by clicking …..

DATA TABLE AND CHART
3. You now need to create a new func.def file with the _cv in the name. You will want to copy the basic file and make changes to it and then save it as the _cv.def file

1. You will need to add or change the following:
   1. f include !TotalCrudeSurv_cv.sas (add the _cv)
   2. f xml_out_map_file XMLPercentNumerLCLUCLCV.map (add the CV)
   3. add the line “cv 7.4” directly under the line “upper 7.4”
   4. add the suppression rule, EXACTLY as shown below. Use cut and paste.

--------BoNdArY--------
1 suppressed_variables 2
n
percent
--------BoNdArY--------

2. Save the file and rename with the _cv
3. Test your changes and make sure they look correct
   1. Open local host
   2. Run a query to verify that the new CV column is there

DATA TABLE AND QUARTILE MAP
4. You now need to create a new func.def file with the _cv in the name. You will want to copy the basic file and make changes to it and then save it as the _cv.def file

1. You will need to add or change the following:
   1. f include !TotalCrudeSurv_cv.sas (add the _cv)
   2. f xml_out_map_file XMLPercentNumerLCLUCLCV.map (add the CV)
   3. add the line “q 2.0” directly under the line “upper 7.4”
   4. add the suppression rule, EXACTLY as shown below. Use cut and paste.

--------BoNdArY--------
1 suppressed_variables 2
n
percent
--------BoNdArY--------

2. Save the file and rename with the _cv
3. Test your changes and make sure they look correct
   1. Open local host
   2. Run a query to verify that the new CV column is there

DATA TABLE AND HIGH-LOW-SAME MAP
5. You now need to create a new func.def file with the _cv in the name. You will want to copy the basic file and make changes to it and then save it as the _cv.def file

1. You will need to add or change the following:
   1. f include !TotalCrudeSurv_cv.sas (add the _cv)
   2. f xml_out_map_file XMLPercentNumerLCLUCLCV.map (add the CV)
   3. add the line “hls 2.0” directly under the line “upper 7.4”
   4. add the suppression rule, EXACTLY as shown below. Use cut and paste.

--------BoNdArY--------
1 suppressed_variables 2
n
percent
--------BoNdArY--------

2. Save the file and rename with the _cv
3. Test your changes and make sure they look correct
   1. Open local host
   2. Run a query to verify that the new CV column is there

Back to IBIS HowTo Index