Changeset 21177 in main


Ignore:
Timestamp:
07/30/20 12:46:43 (2 weeks ago)
Author:
LoisHaggard_NM
Message:

NMBIS Backend QModules - idepi

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/idepi
Files:
5 added
2 deleted
13 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/Dashboard.def

    r20948 r21177  
    4747                THISYEAR=YEAR(DATE);
    4848                THISMONTH=MONTH(DATE);
    49                 if (eventyear=THISYEAR and eventmonth > THISMONTH) then delete;
     49                if (eventyear=THISYEAR and eventmonth > THISMONTH) then eventmonth=.;
    5050                run;
    5151        proc sort data=frame; by %cross1%
     
    143143        data rate;
    144144                set numbers;
    145                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    146                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    147145                rate=count/popcount;
    148146                if count>0 then do;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_CaseFatalityCOVID.def

    r21051 r21177  
    1 #NM_Percentage_data_frame.def
     1#NM_PctDesirableLow.def
    22#Generic percentage .def file
    33#Uses %spvar1% in place of name of variable and the var level for percentage calculation [e.g., "bwtgp in (1 2)"]
     
    2828        proc summary data=tmp;
    2929                var percentvar;
    30                 class agegrp5 %cross1%
     30                class %cross1%
    3131                ?cross2? %cross2%
    3232                ;
    33                 output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum
    34         run;
    35         proc sort data=tmp out=sorted;
    36                 by %cross1% %cross2% agegrp5;
    37                 run;
    38         proc print data=sorted noobs;
     33                output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum;
     34                proc sort data=tmp out=sorted; by %cross1%
     35                ?cross2? %cross2%
     36                ;
     37                run;
     38        run;
     39        proc print data=tmp noobs;
    3940                title1 '---------------------------------';
    4041                title2 '1. TMP - numerator dataset';
    4142                run;
    42        
    43  ********************** 2. %data_frame% ********************************************;
    44  * %data_frame% is a dataset created by IBIS-Q. It consists of %cross1% and %cross2%;
    45  * (if the user specified %cross2%) and a variable named "count" that has been given;
    46  * an initial value of "0". The results of the proc summary must be merged with the ;
    47  * %data_frame% dataset to get all the non-zero counts.                             ;
    48  ***********************************************************************************;
    49  * We don't use the cross1 and cross2 subtotals in the Kendo results table, we only ;
    50  * display the grand total. But deleting the subtotals here will mess with ZWs cell ;
    51  * suppression program and it will suppress table rows that shouldn't be suppressed ;
    52  * when it doesn't find the cross1 and cross2 totals.                               ;
    53  ***********************************************************************************;
    54         data agepop_frame;
    55                 retain count 0;
    56                 do
    57                         agegrp5= 1 to 5 by 1, 99 ;
    58                         output;
    59                 end;
    60         run;
    61         *************************************************************************************;
    62         * If user selects a subset of dimension values, e.g., years, a total row will not be ;
    63         * created in the data frame. The next few lines create a dimension value for the     ;
    64         * total row. But if user does not select specific values (e.g., selects a year,      ;
    65         * then crosses by sex), there will be a total row for the cross1 and cross2 values.  ;
    66         * So in a later step, the new_frame dataset is sorted with a "nodupkey" option to    ;
    67         * remove the additional dimension total values.                                      ;
    68         *************************************************************************************;
    69         data crosstotalframe;
    70                 retain count 0;
    71                 do
    72                         %cross1%=.;
    73                         ?cross2? %cross2%=.;
    74                         output;
    75                 end;
    76         run;
    77         data df_%cross1%%cross2%;
    78                 set df_%cross1%%cross2% crosstotalframe;
    79         run;
    80         proc print data=df_%cross1%%cross2% noobs; title2 'cross1cross2 frame with total row'; run;
    81         proc print data=agepop_frame noobs; title2 'agepop frame'; run;
    82         proc sql;
    83                 create table new_frame as
    84                 select df_%cross1%%cross2%.*, agepop_frame.*
    85                 from df_%cross1%%cross2%, agepop_frame ;
    86         quit;
    87         proc sort data=new_frame nodupkey;
    88                 by %cross1%
     43
     44 *********************** 2. data_frame **************************;
     45 * df_%cross1%%cross2% is a dataset created by IBIS-Q.           ;
     46 * It consists of %cross1% and %cross2% (if the user specified   ;
     47 * %cross2%) and a variable named "count" that is set to "0".    ;
     48 * The results of the proc summary must be merged with the       ;
     49 * df_%cross1%%cross2% dataset.                                  ;
     50 ****************************************************************;
     51        data frame;
     52                set df_%cross1%%cross2%;
     53                run;
     54        proc sort data=frame; by %cross1%
     55                ?cross2? %cross2%
     56                ; run;
     57        proc print data=frame noobs;
     58                title2 '2. Data Frame';
     59                run;
     60
     61        data tmp;
     62                merge frame sorted;   *must list frame dataset first, then tmp;
     63                by %cross1%
    8964                   ?cross2? %cross2%
    90                    agegrp5;
    91                 run;
    92         proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run;
    93 
    94         data tmp;
    95                 merge new_frame sorted;  *must list frame dataset first, then tmp;
    96                 by %cross1% %cross2% agegrp5;
    97         run;
     65                ;
     66                run;
     67
    9868        proc print data=tmp noobs;
    99                 title2 '2. TMP, after frame merged with tmp';
    100                 run;
    101 
    102  *********************** 3. NUMBERS *************************************************;
    103  * Get StdWgt variable onto the tmp dataset.                                         ;
    104  ************************************************************************************;
    105         ****** Special Population Distribution for COVID Case Fatality Rates ******;
    106         *    0-17     116,620    0.0549344                                         ;
    107         *    18-44    894,974    0.4215820                                         ;
    108         *    45-64    686,642    0.3234462                                         ;
    109         *    65-74    196,375    0.0925034                                         ;
    110         *    75+      228,283    0.1075339                                         ;
    111         *    Total  2,122,894    1.0                                               ;
    112         ***************************************************************************;
    113         data numbers;
    114                 set tmp;
    115                 if %cross1%=. then %cross1%=-1;
    116                 ?cross2? if %cross2%=. then %cross2%=-1;
    117                 if agegrp5 = 1 then stdwgt = 0.0549344;
    118                 if agegrp5 = 2 then stdwgt = 0.4215820;
    119                 if agegrp5 = 3 then stdwgt = 0.3234462;
    120                 if agegrp5 = 4 then stdwgt = 0.0925034;
    121                 if agegrp5 = 5 then stdwgt = 0.1075339;
    122         proc print data=numbers noobs;
    123                 title2 '4. NUMBERS';
    124         run;
     69                title2 '2. TMP merged with frame';
     70                run;
     71
     72 *************** 3. Flag variable and popcross macro *************;
     73 * The flag variable checks the cross variables for presence of   ;
     74 * variables that are found in the population dataset. IBIS-q     ;
     75 * created popcross vars based on info from the .CFG file.        ;
     76 * The popcross macro will merge the numerator and denominator    ;
     77 * data, matching up the appropriate values of the cross vars.    ;
     78 *****************************************************************;
     79 * IBIS does not need the population dataset to produce a percent.;
     80 * The following code, through the end of the macro, is used to   ;
     81 * compute the RSE for the data stability indicator and to check  ;
     82 * the numerator and denominator counts for the cell suppression. ;
     83 *****************************************************************;
     84        %let flag=0;
     85        ?popcross1? %let flag=1;
     86        ?popcross2? %let flag=1;
     87        ?popcross1? ?popcross2? %let flag=2;
     88
     89        %macro popcross;
     90
     91        %if &flag=0 %then %do;
     92                proc summary data=poptmp;
     93                        var popcount;
     94                        output out=pop sum=popcount;
     95                run;
     96                proc sql;
     97                        create table numbers as
     98                        select tmp.*, pop.*
     99                        from tmp, pop
     100                quit;
     101        %end;
     102
     103        %if &flag=1 %then %do;
     104                proc summary data=poptmp;
     105                        var popcount;
     106                        class %popcross1% %popcross2%;
     107                        output out=pop sum=popcount;
     108                run;
     109                data pop;
     110                        set pop;
     111                        rename
     112                        ?popcross1? %popcross1%=%cross1%
     113                        ?popcross2? %popcross2%=%cross2%
     114                        ;
     115                        drop _TYPE_ _FREQ_ ;
     116                        run;
     117                proc sort data=pop;
     118                        ?popcross1? by %cross1%;
     119                        ?popcross2? by %cross2%;
     120                run;
     121                proc sort data=tmp;
     122                        ?popcross1? by %cross1%;
     123                        ?popcross2? by %cross2%;
     124                run;
     125                proc print data=pop noobs; title2 '3. POP - pop dataset'; run;
     126                data numbers;
     127                        merge tmp pop;
     128                        ?popcross1? by %cross1%;
     129                        ?popcross2? by %cross2%;
     130                run;
     131        %end;
     132
     133        %if &flag=2 %then %do;
     134                proc summary data=poptmp;
     135                        var popcount;
     136                        class %popcross1% %popcross2%  ;
     137                        output out=pop sum=popcount;
     138                run;
     139                data pop;
     140                        set pop;
     141                        rename %popcross1%=%cross1%  %popcross2%=%cross2% ;
     142                        run;
     143                proc sort data=pop;
     144                        by %cross1% %cross2%;
     145                run;
     146                proc sort data=tmp;
     147                        by %cross1% %cross2%;
     148                run;
     149                data numbers;
     150                        merge tmp pop;
     151                        by %cross1% %cross2%
     152                        ;
     153                run;
     154        %end;
     155        %mend;
     156        %popcross;
     157        proc print data=numbers noobs; title2 'numbers'; run;
    125158
    126159 ********************** 4. tmp, again ****************************;
    127160 * Create the output variables for the IBIS xml/map file.         ;
    128161 *****************************************************************;
    129         data agespecific;
     162        data rate;
    130163                set numbers;
    131                 if agegrp5^=.;
    132                 r=count/totalnum;
    133                 ratewgt=r*stdwgt;               *weighted age-specific proportion;
    134                 rate_var=(stdwgt**2)*((r*(1-r))/totalnum);
    135                 run;
    136         proc print data=agespecific noobs; 
    137                 title2 '7. AGESPECIFIC - combines numer and denom data, includes R (age-specific proportion),';
    138                 title3 'RATEWGT (weighted age-specific rate), and RATE_VAR (rate variance) vars';
    139         run;
    140 
    141  ************************ 5. AARATE **************************************************;
    142  * Sum the age-specific rates into aa rates, and merge wgtmax.                        ;   
    143  *************************************************************************************;
    144         proc summary data=agespecific nway;
    145                 var ratewgt rate_var count totalnum;
    146                 class %cross1% %cross2%;
    147                 output out=aarate (drop= _TYPE_ _FREQ_) sum(ratewgt rate_var count totalnum)=aarate aarate_var count totalnum;
    148         run;
    149         proc print data=aarate noobs;
    150                 title2 '5. AARATE - summed across weighted age group cross-products to get AA rate and';
    151                 title3 'rate variance within each cross-by var';
    152         run;
    153 
    154  ******************* 6. TMP *********************************************************;
    155  * Almost final IBIS output dataset.  Make sure no summary rows are included.        ;
    156  * All -1 totals will be coded back to '.' after this step.                          ;
    157  ************************************************************************************;
    158         data tmp;
    159                 set aarate;
    160                 if %cross1%=-1 then %cross1%=.;         *Recode the statewide totals.;
    161                 ?cross2? if %cross2%=-1 then %cross2%=.;
    162                
    163                 if (count>0) then do;
    164                                 rateper=(aarate*100);
    165                                 rate_se=sqrt(aarate_var);
    166                                 stderr=(rate_se*100);
     164                if count>0 then do;
     165                                rate=count/totalnum;
     166                                rateper=(rate*100);
     167                                stderr=sqrt(rate*(1-rate)/totalnum)*100;
    167168                        end;
    168                 if (count<=0) then do;
    169                                 count=0;
     169                if count<=0 then do;
     170                                rate=0;
    170171                                rateper=0;
    171172                                stderr=sqrt((3/totalnum)*(1-(3/totalnum))/totalnum)*100;
     
    182183                if totalnum=. then totalnum=0;
    183184
    184  *********************** 7. Red Flag *****************************;
     185 *********************** 5. Red Flag *****************************;
    185186 * redflag is the statistical stability indicator based on the    ;
    186187 * relative standard error (RSE, or coefficient of variation).    ;
     
    200201                if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
    201202        run;
     203        proc print data=rate noobs; title2 'rate'; run;
    202204
    203205 ************* 8. New Mexico Small Numbers Rule ********************;
     
    214216 *******************************************************************;
    215217        data tmp;
    216                 set tmp;
     218                set rate;
    217219                if ((0<n<4) and (.<totalnum<20)) then do;
    218220                        n = .A;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_CountCOVID.def

    r20948 r21177  
    129129        data rate;
    130130                set numbers;
    131                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    132                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    133131                rate=count/popcount;
    134132                if count>0 then do;
     
    191189        run;
    192190
    193         proc sort data=tmp; by eventmonth; run;
    194 
    195191--------BoNdArY--------
    196192# definition for output file
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_CountCOVIDZIP.def

    r20948 r21177  
    2121 * The variable "x" must be in the dataset, it is set equal to 1.;
    2222 ****************************************************************;
     23        data tmp; format %cross1% %cross2% count 15.0; set tmp; run; 
    2324        proc summary data=tmp;
    2425                var x;
     
    135136        data rate;
    136137                set numbers;
    137                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    138                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    139138                rate=count/popcount;
    140139                if count>0 then do;
     
    199198        run;
    200199
    201         proc sort data=tmp; by eventmonth; run;
    202 
    203200--------BoNdArY--------
    204201# definition for output file
     
    208205f out_detail lbl_not_used__see_xml_out_map_file
    209206  n 15.0
     207  redflag 15.0
    210208--------BoNdArY--------
    211209 
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_CountMoWkPersYrs.def

    r20948 r21177  
    4040       
    4141 *********************** 2. data_frame **************************;
    42  * df_%cross1%%cross2% is a dataset created by IBIS-Q.   ;
     42 * df_%cross1%%cross2% is a dataset created by IBIS-Q.           ;
    4343 * It consists of %cross1% and %cross2% (if the user specified   ;
    4444 * %cross2%) and a variable named "count" that is set to "0".    ;
    4545 * The results of the proc summary must be merged with the       ;
    46  * df_%cross1%%cross2% dataset.                          ;
     46 * df_%cross1%%cross2% dataset.                                  ;
    4747 ****************************************************************;
    4848
     
    5353                THISMONTH=MONTH(DATE);
    5454                THISWEEK=WEEK(DATE);
    55                 if (THISYEAR=YEAR(DATE) and eventmonth > THISMONTH) then delete; *delete future periods from frame;
    56                 if (THISYEAR=YEAR(DATE) and mmwr_week > THISWEEK) then delete;
     55                if (THISYEAR=YEAR(DATE) and eventmonth > THISMONTH) then eventmonth=.; *future periods in frame;
     56                if (THISYEAR=YEAR(DATE) and mmwr_week > THISWEEK) then mmwr_week=.;
    5757                run;
    5858        proc sort data=frame; by %cross1%
     
    150150        data rate;
    151151                set numbers;
    152                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    153                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    154152                rate=count/popcount;
    155153                if count>0 then do;
     
    201199        data tmp;
    202200                set rate;
    203                 if ((0<n<4) and (popcount<5000)) then do;
     201                if ((0<n<4) and (.<popcount<5000)) then do;
    204202                        n = .A;
    205203                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_RateAA100K.def

    r21051 r21177  
    11#NM_RateAA100K_data_frame.def
    2 #THIS DEF FILE USES 5 AGE-ADJUSTING AGE GROUPS
    3 #Calculates directly age-adjusted rates per 100 for
     2#THIS DEF FILE USES 11 AGE-ADJUSTING AGE GROUPS
     3#Calculates directly age-adjusted rates per 100,000 for
    44#  records that have been filtered by IBIS-Q (data=tmp)
    55#Uses the IBIS-Q data_frame for cross1 and cross2
     
    2222 * The variable "x" must be in the dataset, it is set equal to 1.;
    2323 ****************************************************************;
     24        data tmp; format agepop %cross1% %cross2% count 15.0; set tmp; run; 
    2425        proc summary data=tmp;
    2526                var x;
     
    189190   
    190191 ************************ 8. AARATE **************************************************;
    191  * Sum the age-specific rates into aa rates, and merge wgtmax.                        ;
     192 * Sum the age-specific rates into aa rates, and merge wgtmax.                        ;   
    192193 *************************************************************************************;
    193194        proc summary data=agespecific nway;
    194195                var ratewgt rate_var count popcount;
    195196                class %cross1% %cross2%;
    196                 output out=aarate (drop=_TYPE_ _FREQ_) sum(ratewgt rate_var count popcount)=aarate aarate_var count popcount;
    197         run;
     197                output out=aarate sum(ratewgt rate_var count popcount)=aarate aarate_var count popcount;
     198        run;
     199        data aarate;
     200                set aarate;
     201                drop _TYPE_ _FREQ_ ;
     202                run;
     203                proc sort data=aarate; by %cross1% %cross2%; run;
    198204        proc print data=aarate noobs;
    199205                title2 '8. AARATE - summed across weighted age group cross-products to get AA rate and';
     
    262268                        LL = put('**', 8.0);
    263269                        UL = put('**', 8.0);
    264                         *Only 1 value attribute is allowed - so if suppressed, overwrite unstable;
    265                         *Also puts ** in record code column for suppressed rows, and adds footnote;
     270
     271                *Only one value attribute is allowed - so if suppressed, overwrite unstable;
     272                *This also puts ** in record code column for suppressed rows, and adds footnote;
    266273                        redflag = put('Suppressed', $12.);
    267274                end;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_RateAADths100K.def

    r21051 r21177  
    2727                ?cross2? %cross2%
    2828                ;
     29                format count %cross1% 15.0 ;
    2930                output out=tmp (drop=_TYPE_ _FREQ_) sum=count;
    3031        proc sort data=tmp out=sorted;
     
    9091                merge new_frame sorted;  *must list frame dataset first, then tmp;
    9192                by %cross1% %cross2% agepop;
     93                if agepop=. then delete;
    9294        run;
    9395        proc print data=tmp noobs;
     
    182184                rate_var=(stdwgt**2)*((r*(1-r))/popcount);
    183185                * Montana method... rate_var=count*(stdwgt/popcount)**2;  * New formula from doh.wa.gov;
    184 
     186        proc sort data=agespecific; by %cross1% %cross2% agepop ;
     187        run;
    185188        proc print data=agespecific noobs; 
    186189                title2 '7. AGESPECIFIC - combines numer and denom data, includes R (age-specific proportion),';
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_RateCrudeCOVID.def

    r21017 r21177  
    2121 * The variable "x" must be in the dataset, it is set equal to 1.;
    2222 ****************************************************************;
     23        data tmp; format %cross1% %cross2% count 15.0; set tmp; run; 
    2324        proc summary data=tmp;
    2425                var x;
     
    2829                format count 15.0 ;
    2930                output out=tmp (drop=_TYPE_ _FREQ_) sum=count;
    30         proc sort data=tmp out=sorted; by %cross1%
     31                proc sort data=tmp out=sorted; by %cross1%
    3132                ?cross2? %cross2%
    3233                ; run;
     
    3738 
    3839 *********************** 2. data_frame **************************;
    39  * df_%cross1%%cross2% is a dataset created by IBIS-Q.   ;
     40 * df_%cross1%%cross2% is a dataset created by IBIS-Q.           ;
    4041 * It consists of %cross1% and %cross2% (if the user specified   ;
    4142 * %cross2%) and a variable named "count" that is set to "0".    ;
    4243 * The results of the proc summary must be merged with the       ;
    43  * df_%cross1%%cross2% dataset.                          ;
     44 * df_%cross1%%cross2% dataset.                                  ;
    4445 ****************************************************************;
    4546        data frame;
    4647                format count 15.0 ;
    4748                set df_%cross1%%cross2%;
    48                 DATE=TODAY();
    49                 THISYEAR=YEAR(DATE);
    50                 THISMONTH=MONTH(DATE);
    51                 THISWEEK=WEEK(DATE);
    52                 if (THISYEAR=YEAR(DATE) and eventmonth > THISMONTH) then delete; *delete future periods from frame;
    53                 if (THISYEAR=YEAR(DATE) and mmwr_week > THISWEEK) then delete;
    5449                run;
    5550        proc sort data=frame; by %cross1%
     
    7772 * data, matching up the appropriate values of the cross vars.    ;
    7873 *****************************************************************;
     74        data poptmp; format %popcross1% %popcross2% 15.; set poptmp; run; 
    7975        %let flag=0;
    8076        ?popcross1? %let flag=1;
     
    142138        data rate;
    143139                set numbers;
    144                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    145                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    146140                rate=count/popcount;
    147141                if count>0 then do;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/NM_RateCrudeMoWkPersYrs100K.def

    r20948 r21177  
    4747                THISMONTH=MONTH(DATE);
    4848                THISWEEK=WEEK(DATE);
    49                 if (THISYEAR=YEAR(DATE) and eventmonth > THISMONTH) then delete; *delete future periods from frame;
    50                 if (THISYEAR=YEAR(DATE) and mmwr_week > THISWEEK) then delete;
     49                if (THISYEAR=YEAR(DATE) and eventmonth > THISMONTH) then eventmonth=.; *future periods in frame;
     50                if (THISYEAR=YEAR(DATE) and mmwr_week > THISWEEK) then mmwr_week=.;
    5151                run;
    5252        proc sort data=frame; by %cross1%
     
    144144        data rate;
    145145                set numbers;
    146                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    147                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    148146                rate=count/popcount;
    149147                if count>0 then do;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/_COVID19Cnty.cfg

    r21051 r21177  
    6262#value name_sas name_html name_pop prompt type1 type2 length
    6363
    64 30 mmwr_week WeekMMWR null MMWRWeek num 0 8
     6430 mmwr_week WeekMMWRCOVID null MMWRWeek num 0 8
    656530 onsetdate OnsetDate null IllnessOnset char 0 9
    666610 status CaseStatus null CaseStatus num 0 8
     
    787840 agegrp9 AgeGrp9 agegrp9 Age num 0 8
    797940 agepop AgeGrp11 agepop Age num 0 8
     8040 agegrp13 AgeGrp13 agegrp13 Age num 0 8
    808140 agegrp18 AgeGrp18 agegrp18 Age num 0 8
    818240 agegrp35 AgeGrp35 agegrp35 Age num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/_COVID19CntyTests.cfg

    r21017 r21177  
    1919
    2020d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    21 r data_where detention=2
     21#r data_where detention=2
    2222r pop_where year=2020
    2323####################################################################
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/_COVID19Sarea.cfg

    r21017 r21177  
    1818d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    1919#r data_where mmwr_week^=0
    20 r pop_where year=2020
    21 r sasstdpop morstd
     20r pop_where year=2018
    2221####################################################################
    2322d response_head_content XMLResponse.head
     
    3029r cross2 none
    3130r spvar1 none
     31r spvar2 none
    3232# Year 1993
    3333r sas 0
     
    757540 agegrp9 AgeGrp9 agegrp9 Age num 0 8
    767640 agepop AgeGrp11 agepop Age num 0 8
     7740 agegrp13 AgeGrp13 agegrp13 Age num 0 8
    777840 agegrp18 AgeGrp18 agegrp18 Age num 0 8
    787940 agegrp35 AgeGrp35 agegrp35 Age num 0 8
     
    838420 null GeoProxy fipscode Geography num 10 8
    848520 fipscnty GeoCnty fipscode ResidentialCounty num 0 8
    85 20 area134 GeoSarea sarea134 ResidentialCounty num 0 8
     8620 area134 GeoSarea sarea134 NMDOHSmallArea num 0 8
    868720 region GeoRegion region HealthRegion num 0 8
    878820 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/3.0/idepi/_COVID19ZIPTests.cfg

    r21017 r21177  
    1919
    2020d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    21 r data_where detention=2
     21#r data_where detention=2
    2222#r pop_where year=2020
    2323####################################################################
Note: See TracChangeset for help on using the changeset viewer.