Changes between Version 1 and Version 2 of HowToChangeTheCategoriesOfADimensionOnASurveyQueryModule


Ignore:
Timestamp:
10/05/09 15:02:24 (13 years ago)
Author:
kimberly
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • HowToChangeTheCategoriesOfADimensionOnASurveyQueryModule

    v1 v2  
     1'''How to Change the Categories of a Dimension on a Survey Query Module'''
     2''
     3
     4
     5In this example we will be updating the BRFSS income category dimension''
     6
     7A. Make sure the new/changed variable is in the SAS data set by running a proc contents then a proc freq to look at the actual data.
     8
     9B. Load new data set onto server[[BR]]
     10     1. Make a backup of the old file. You are going to need to name the new file with the standard name, which will end up writing over the old dataset if you do not rename it first[[BR]]
     11     2. Open Winscp or other ftp tool[[BR]]
     12     3. Double click on the highlighted blue bar at the top of the right-hand side window in WinSCP3. This will bring up a new window entitled “Open Directory”[[BR]]
     13     4. Highlight /srv/ibis-q/sasData/final by clicking on it [[BR]]
     14     5. Hit OK to go to that directory[[BR]]
     15
     16C. Update/create the dimension file. You will need to open tomcat and go to the  correct file C:\tomcat\webapps\ibisph-view\xml\query\module\brfss\dimension
     17
     18     1. In this example we will be changing the income dimension from having 3 reporting categories to having 4 reporting categories:
     19
     20
     21{{{
     22<?xml version="1.0" encoding="ISO-8859-1"?>
     23
     24<DIMENSION>
     25        <NAME>SurvDemoInc</NAME>
     26        <TITLE>Income</TITLE>
     27        <VALUES>
     28                <VALUE>1<TITLE>0-$24,999</TITLE></VALUE>
     29                <VALUE>2<TITLE>$25,000-$49,999</TITLE></VALUE>
     30                <VALUE>3<TITLE>$50,000-$74,999</TITLE></VALUE>
     31                <VALUE>4<TITLE>$75,000 or more</TITLE></VALUE>
     32                <VALUE>.<TITLE>Total</TITLE><NOT_ASSOCIATED_FLAG/></VALUE>
     33        </VALUES>
     34</DIMENSION>
     35}}}
     36
     37     2. Save file[[BR]]
     38     3. Close
     39
     40
     41D. Next you need to update the configuration file[[BR]]
     42     1. Open Winscp or other ftp tool[[BR]]
     43     2. Double click on the highlighted blue bar at the top of the right-hand side window in WinSCP3. This will bring up a new window entitled “Open Directory”[[BR]]
     44     3. Highlight /srv/ibis-q/modules/brfss by clicking on it[[BR]]
     45     4. Hit OK to go to that directory[[BR]]
     46     5. Open BRFSS.cgf[[BR]]
     47     6. Search for the variable you are changing, in this case incat3[[BR]]
     48     7. Change name from incat3 to the new dimension to be used, inc4[[BR]]
     49     8. Save file[[BR]]
     50     9. Close[[BR]]
     51
     52E. Test changes on your local machine[[BR]]
     53     1. Open tomcat by selecting Startup Tomcat on your local drive[[BR]]
     54     2. Connect to local host in a browser such as Firefox[[BR]]
     55     3. Do a test run of the data[[BR]]
     56     4. Hopefully all works fine! [[BR]]
     57
     58F. Deploy single page. See http://www.ibisph.org/trac/wiki/HowToPublishASinglePageForAQueryModule for instructions.
    159
    260