Changeset 21077 in main


Ignore:
Timestamp:
07/20/20 17:40:07 (3 weeks ago)
Author:
Paul Leo
Message:

Hawaii Death query Backend .def (SAS) file. Implemented data frame in order to display 0 values when display or grouping reults

File:
1 edited

Legend:

Unmodified
Added
Removed
  • adopters/hi/branches/2.3/src/main/backend_qModules/mort/HI_Count_data_frame.def

    r20522 r21077  
    3232       
    3333 *********************** 2. data_frame **************************;
    34  * df_%cross1%%cross2% is a dataset created by IBIS-Q.   ;
     34 * df_%cross1%%cross2% is a dataset created by IBIS-Q.           ;
    3535 * It consists of %cross1% and %cross2% (if the user specified   ;
    3636 * %cross2%) and a variable named "count" that is set to "0".    ;
    3737 * The results of the proc summary must be merged with the       ;
    38  * df_%cross1%%cross2% dataset.                          ;
     38 * df_%cross1%%cross2% dataset.                                  ;
    3939 ****************************************************************;
    4040
     
    141141        data tmp;
    142142                set tmp;
    143 /*
     143/*   NOT NEEDED FOR COUNTS
     144
    144145                rate=count/popcount;
    145146                rateper=(rate*100000);
     
    181182
    182183        run;
    183 
    184   **************** New Mexico Small Numbers Rule *********************;
    185   * Suppress cells if the numerator in (1 2 3) AND the denominator    ;
    186   * is less than 20. For Counts, must run the crude rate code to      ;
    187   * capture the denominator, but only output the N. ZW’s program      ;
    188   * uses ".A" to identify cells for suppression. I have co-opted      ;
    189   * his method so I can use the NM logic for cell suppression instead ;
    190   * of the standard IBIS logic. And I need to use ZWs program         ;
    191   * because it will suppress the table marginals that can be used to  ;
    192   * calculate the suppressed cells. If this code is used, the .def    ;
    193   * file should have the NM_ prefix. Needs suppressed_variabes        ;
    194   * code at the end of this file to work.                             ;
    195   ********************************************************************;
     184 ************************** 2. Hawaii Small Numbers rule  *******;
     185 * create var called n for ibis-q                                ;
     186 * Suppress cells if the numerator (count)  in (1 - 9)           ;
     187 * ZW’s program uses ".A" to identify cells for suppression.     ;
     188 * I have co-opted his method so I can use the HI logic for      ;
     189 * cell suppression instead of the standard IBIS logic. And I    ;
     190 *  need to use ZWs program   because it will suppress the      ;
     191 * table marginals that can be used to calculate the suppressed  ;
     192 * cells. If this code is used, the .def file should have the    ;
     193 * HI_ prefix. Needs suppressed_variabes code at the end of      ;
     194 * this file to work.                                            ;
     195 ****************************************************************;
     196
    196197        data tmp;
    197198                set tmp;
    198 /*
    199                 if ((0<n<4) and (popcount<5000)) then do;
     199                n=count;        **** ibis-q needs a count variable named 'n';
     200                if 0<count<10 then do;
    200201                        n = .A;
    201                         rateper = .A;
    202                         LL = put('**', 8.0);
    203                         UL = put('**', 8.0);
    204202                end;
    205 */
     203
    206204        proc print data=tmp noobs;  title2 '6. TMP - final dataset to pass to IBIS View app';
    207205        run;
     
    225223 * are active in the .CFG file, and with non-zero values.            ;
    226224 ********************************************************************;
    227  
     225--------BoNdArY--------
     2261 suppressed_variables 1
     227n
     228--------BoNdArY--------
     229 
Note: See TracChangeset for help on using the changeset viewer.