Changeset 24370 in main


Ignore:
Timestamp:
12/23/21 11:40:16 (8 months ago)
Author:
LoisHaggard_STG
Message:

NMBIS Backend qModules - committing all files

Location:
adopters/nm/trunk/src/main/backend_qModules/2.3
Files:
3 added
8 deleted
38 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/2.3/_EPHT/ed/_ED0818.cfg

    r20394 r24370  
    2222d saspath E:\ibisq\sasData\final\
    2323d saspop E:\ibisq\sasData\final\
    24 r sasdata nm_ed_0818
    25 d saspopdata popibiscnty90_18_28jun2019
     24
     25r sasdata nm_ed_0819
     26d saspopdata popibiscnty90_19_20oct2020
     27
    2628#d saspopdata popibissarea90_15_11oct2016
    2729d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2830#r sas_bin sas&-memsize&0
     31
    2932r pop_where 2008<=year<=2018
    3033r data_where 2008<=year<=2018
  • adopters/nm/trunk/src/main/backend_qModules/2.3/hidd/_HIDD18.cfg

    r22137 r24370  
    1111d workpath E:\ibisq\workpath
    1212####################################################################
    13 d saspath E:\ibisq\sasData\final\
    14 d saspop E:\ibisq\sasData\final\
     13d saspath E:\ibisq\sasData\final
     14d saspop E:\ibisq\sasData\final
    1515
    1616d sasdata hiddkiss08_18
     
    4141#value =any value, place holder only
    4242# name_sas  = SAS variable name in the numerator data set (birth data set)
    43 # name_html = html name that specified under <DIMENSION> <NAME> in Module XML file
     43# name_html = html name: <DIMENSION> <NAME> in Module XML file
    4444# name_pop  = SAS variable name in denominator data set (population data set)
    45 # prompt    = Place holder only, could by any character string. (I used x to pad the line)
     45# prompt    = Place holder only, could by any character string.
    4646# type1     = CGI data type for SAS variable type (see comment lines 48 & 49)
    4747# type2     = CGI data type for CGI regrouping purpose (see comment lines 51-59)
     
    165165
    16616610 null GeoProxy null ProxyVar num 10 4
    167 10 fipscode GeoCnty fipscode NMCounties num 0 8
     16710 fipscnty GeoCnty fipscode NMCounties num 0 8
    16816810 Region GeoRegion region NMRegion num 0 8
    16916910 urbanrur GeoUrbanRur UrbanRur UrbanRuralCounties num 0 8
     
    17317314 licensetyp SysFacilityType null PrimaryPayerCategory num 0 8
    174174
    175 # The popcount variable is only referenced in the .DEF files ====================
    176 
    177 
     175# The popcount variable is only referenced in the .DEF files ==================
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepi23/NM_CountMoWkPersYrs.def

    r18931 r24370  
    110110                        create table numbers as
    111111                        select tmp.*, pop.*
    112                         from tmp, pop
    113                         where
     112                        from tmp left join pop
     113                        on
    114114                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    115115                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    126126                        create table numbers as
    127127                        select tmp.*, pop.*
    128                         from tmp, pop
    129                         where tmp.%cross1%=pop.%popcross1% and
     128                        from tmp left join pop
     129                        on tmp.%cross1%=pop.%popcross1% and
    130130                        tmp.%cross2%=pop.%popcross2%;
    131131                quit;
     
    142142        data rate;
    143143                set numbers;
    144                 if 1<=eventmonth<=12 then popcount=(popcount/12);
    145                 if 1<=mmwr_week<=53 then popcount=(popcount/52);
    146144                rate=count/popcount;
    147145                if count>0 then do;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepi23/_IDEpi.cfg

    r18931 r24370  
    6161#value name_sas name_html name_pop prompt type1 type2 length
    6262
    63 10 null Disease null Event num 0 8
     6310 disease Disease null Event num 0 8
    646410 event Event null Event num 0 8
    656510 event HepBAcuteChronic null Acute&vs&Chronic&Cases num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_CaseFatalityAACOVID.def

    r21187 r24370  
    2828        proc summary data=tmp;
    2929                var percentvar;
    30                 class agegrp5 %cross1%
     30                class agegrp35 %cross1%
    3131                ?cross2? %cross2%
    3232                ;
    3333                output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum;
    34                 proc sort data=tmp out=sorted; by %cross1%
     34                run;
     35        run;
     36        data agecases;
     37                set tmp;
     38                agecases=.;
     39                if agegrp35 in  (1:5)  then  agecases=1;
     40                if agegrp35 in (6:18)  then  agecases=2;
     41                if agegrp35 in (19:23) then  agecases=3;
     42                if agegrp35 in (24 25) then  agecases=4;
     43                if agegrp35 in (26 27) then  agecases=5;
     44                if agegrp35 in (28:30) then  agecases=6;
     45                if agegrp35 in (31 32) then  agecases=7;
     46                if agegrp35 in (33 34) then  agecases=8;
     47                if agegrp35 in    (35) then  agecases=9;
     48                run;
     49        proc summary data=agecases;
     50                class agecases %cross1%
    3551                ?cross2? %cross2%
    36                 agegrp5;
    37                 run;
    38         run;
     52                ;
     53                output out=tmp (drop=_TYPE_ _FREQ_) sum(count)= sum(totalnum)=;
     54                run;
     55        data tmp;
     56                set tmp;
     57                stdwgt=.;
     58                if agecases=1 then stdwgt=0.016;  *0 - 4 Years;
     59                if agecases=2 then stdwgt=0.057;  *5 - 17 Years;
     60                if agecases=3 then stdwgt=0.215;  *18 - 29 Years;
     61                if agecases=4 then stdwgt=0.171;  *30 - 39 Years;
     62                if agecases=5 then stdwgt=0.159;  *40 - 49 Years;
     63                if agecases=6 then stdwgt=0.218;  *50 - 64 Years;
     64                if agecases=7 then stdwgt=0.080;  *65 - 74 Years;
     65                if agecases=8 then stdwgt=0.048;  *75 - 84 Years;
     66                if agecases=9 then stdwgt=0.037;  *85+ Years;
     67                run;
    3968        proc sort data=tmp out=sorted;
    40                 by %cross1% %cross2% agegrp5;
     69                by %cross1% %cross2% agecases;
    4170                run;
    4271        proc print data=sorted noobs;
     
    5988                retain count 0;
    6089                do
    61                         agegrp5= 1 to 5 by 1, 99 ;
     90                        agecases= 1 to 9 by 1;
    6291                        output;
    6392                end;
     
    92121                by %cross1%
    93122                   ?cross2? %cross2%
    94                    agegrp5;
     123                   agecases;
    95124                run;
    96125        proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run;
     
    98127        data tmp;
    99128                merge new_frame sorted;  *must list frame dataset first, then tmp;
    100                 by %cross1% %cross2% agegrp5;
     129                by %cross1% %cross2% agecases;
    101130        run;
    102131        proc print data=tmp noobs;
     
    108137 ************************************************************************************;
    109138        ****** Special Population Distribution for COVID Case Fatality Rates ******;
     139        *    This was replaced in August 2020 with the new age var and wgts.       ;
    110140        *    0-17     116,620    0.0549344                                         ;
    111141        *    18-44    894,974    0.4215820                                         ;
     
    119149                if %cross1%=. then %cross1%=-1;
    120150                ?cross2? if %cross2%=. then %cross2%=-1;
    121                 if agegrp5 = 1 then stdwgt = 0.0549344;
    122                 if agegrp5 = 2 then stdwgt = 0.4215820;
    123                 if agegrp5 = 3 then stdwgt = 0.3234462;
    124                 if agegrp5 = 4 then stdwgt = 0.0925034;
    125                 if agegrp5 = 5 then stdwgt = 0.1075339;
    126151        proc print data=numbers noobs;
    127152                title2 '4. NUMBERS';
     
    133158        data agespecific;
    134159                set numbers;
    135                 if agegrp5^=.;
     160                if agecases^=.;
    136161                r=count/totalnum;
    137162                ratewgt=r*stdwgt;               *weighted age-specific proportion;
     
    152177        run;
    153178        proc print data=aarate noobs;
    154                 title2 '5. AARATE - summed across weighted age group cross-products to get AA rate and';
    155                 title3 'rate variance within each cross-by var';
     179                title2 '5. AARATE - summed across weighted age group cross-products to get ';
     180                title3 'AA rate and rate variance within each cross-by var';
    156181        run;
    157182
     
    202227                *no variance, n=0, rse=div by zero;
    203228                if count<=0 then redflag=put('Unstable', $12.);
    204                 if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
     229                if totalnum=. then redflag=put('', $12.); *no value attribute for missing crossby values;
    205230        run;
    206231
     
    236261f out_variable rateper
    237262# definition for output file
    238 f xml_out_map_file XMLPctDesirableLow.map
     263f xml_out_map_file XMLRateNumerDenomLCLUCL.map
    239264--------BoNdArY--------
    240265f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_CaseFatalityCOVID.def

    r21187 r24370  
    234234f out_variable rateper
    235235# definition for output file
    236 f xml_out_map_file XMLPctDesirableLow.map
     236f xml_out_map_file XMLRateNumerDenomLCLUCL.map
    237237--------BoNdArY--------
    238238f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_RateCrudeCOVID.def

    r21194 r24370  
    1 #NM_RateCrudeMoWkPersYrs100K.def
     1#NM_RateCrudeCOVID.def
    22#For use with COVID dataset
    33#Less restrictive cell suppression
     
    7272 * data, matching up the appropriate values of the cross vars.    ;
    7373 *****************************************************************;
    74         data poptmp; format %popcross1% %popcross2% 15.; set poptmp; run; 
    7574        %let flag=0;
    7675        ?popcross1? %let flag=1;
     
    9392
    9493        %if &flag=1 %then %do;
     94        data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 
    9595                proc summary data=poptmp;
    9696                        var popcount;
     
    110110
    111111        %if &flag=2 %then %do;
     112        data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 
    112113                proc summary data=poptmp;
    113114                        var popcount;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/_COVID19Cnty.cfg

    r21187 r24370  
    1414d saspath E:\ibisq\sasData\final\
    1515d saspop E:\ibisq\sasData\final\
    16 r sasdata covid_ibis
     16
     17r sasdata covid_ibis_cases
    1718d saspopdata popibiscnty90_18_28jun2019
    1819d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
     
    878820 null GeoProxy fipscode Geography num 10 8
    888920 fipscnty GeoCnty fipscode ResidentialCounty num 0 8
     9020 fipscnty GeoCntyRank fipscode ResidentialCounty num 0 8
    899120 region GeoRegion region HealthRegion num 0 8
    909220 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/_COVID19CntyTests.cfg

    r21187 r24370  
    99
    1010#value name_path value_path
    11 d homepath E:\ibisq\qModules30\idepi\
     11d homepath E:\ibisq\qModules\idepiPGL\
    1212d workpath E:\ibisq\workpath
    1313####################################################################
     
    2525d response_tail_content XMLResponse.tail
    2626#####################################################################
    27 r form 30
     27r form 22
    2828r output xml
    2929r func 1
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_CaseFatalityAACOVID.def

    r21187 r24370  
    2828        proc summary data=tmp;
    2929                var percentvar;
    30                 class agegrp5 %cross1%
     30                class agegrp35 %cross1%
    3131                ?cross2? %cross2%
    3232                ;
    3333                output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum;
    34                 proc sort data=tmp out=sorted; by %cross1%
     34                run;
     35        run;
     36        data agecases;
     37                set tmp;
     38                agecases=.;
     39                if agegrp35 in  (1:5)  then  agecases=1;
     40                if agegrp35 in (6:18)  then  agecases=2;
     41                if agegrp35 in (19:23) then  agecases=3;
     42                if agegrp35 in (24 25) then  agecases=4;
     43                if agegrp35 in (26 27) then  agecases=5;
     44                if agegrp35 in (28:30) then  agecases=6;
     45                if agegrp35 in (31 32) then  agecases=7;
     46                if agegrp35 in (33 34) then  agecases=8;
     47                if agegrp35 in    (35) then  agecases=9;
     48                run;
     49        proc summary data=agecases;
     50                class agecases %cross1%
    3551                ?cross2? %cross2%
    36                 agegrp5;
    37                 run;
    38         run;
     52                ;
     53                output out=tmp (drop=_TYPE_ _FREQ_) sum(count)= sum(totalnum)=;
     54                run;
     55        data tmp;
     56                set tmp;
     57                stdwgt=.;
     58                if agecases=1 then stdwgt=0.016;  *0 - 4 Years;
     59                if agecases=2 then stdwgt=0.057;  *5 - 17 Years;
     60                if agecases=3 then stdwgt=0.215;  *18 - 29 Years;
     61                if agecases=4 then stdwgt=0.171;  *30 - 39 Years;
     62                if agecases=5 then stdwgt=0.159;  *40 - 49 Years;
     63                if agecases=6 then stdwgt=0.218;  *50 - 64 Years;
     64                if agecases=7 then stdwgt=0.080;  *65 - 74 Years;
     65                if agecases=8 then stdwgt=0.048;  *75 - 84 Years;
     66                if agecases=9 then stdwgt=0.037;  *85+ Years;
     67                run;
    3968        proc sort data=tmp out=sorted;
    40                 by %cross1% %cross2% agegrp5;
     69                by %cross1% %cross2% agecases;
    4170                run;
    4271        proc print data=sorted noobs;
     
    5988                retain count 0;
    6089                do
    61                         agegrp5= 1 to 5 by 1, 99 ;
     90                        agecases= 1 to 9 by 1;
    6291                        output;
    6392                end;
     
    92121                by %cross1%
    93122                   ?cross2? %cross2%
    94                    agegrp5;
     123                   agecases;
    95124                run;
    96125        proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run;
     
    98127        data tmp;
    99128                merge new_frame sorted;  *must list frame dataset first, then tmp;
    100                 by %cross1% %cross2% agegrp5;
     129                by %cross1% %cross2% agecases;
    101130        run;
    102131        proc print data=tmp noobs;
     
    108137 ************************************************************************************;
    109138        ****** Special Population Distribution for COVID Case Fatality Rates ******;
     139        *    This was replaced in August 2020 with the new age var and wgts.       ;
    110140        *    0-17     116,620    0.0549344                                         ;
    111141        *    18-44    894,974    0.4215820                                         ;
     
    119149                if %cross1%=. then %cross1%=-1;
    120150                ?cross2? if %cross2%=. then %cross2%=-1;
    121                 if agegrp5 = 1 then stdwgt = 0.0549344;
    122                 if agegrp5 = 2 then stdwgt = 0.4215820;
    123                 if agegrp5 = 3 then stdwgt = 0.3234462;
    124                 if agegrp5 = 4 then stdwgt = 0.0925034;
    125                 if agegrp5 = 5 then stdwgt = 0.1075339;
    126151        proc print data=numbers noobs;
    127152                title2 '4. NUMBERS';
     
    133158        data agespecific;
    134159                set numbers;
    135                 if agegrp5^=.;
     160                if agecases^=.;
    136161                r=count/totalnum;
    137162                ratewgt=r*stdwgt;               *weighted age-specific proportion;
     
    152177        run;
    153178        proc print data=aarate noobs;
    154                 title2 '5. AARATE - summed across weighted age group cross-products to get AA rate and';
    155                 title3 'rate variance within each cross-by var';
     179                title2 '5. AARATE - summed across weighted age group cross-products to get ';
     180                title3 'AA rate and rate variance within each cross-by var';
    156181        run;
    157182
     
    202227                *no variance, n=0, rse=div by zero;
    203228                if count<=0 then redflag=put('Unstable', $12.);
    204                 if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;
     229                if totalnum=. then redflag=put('', $12.); *no value attribute for missing crossby values;
    205230        run;
    206231
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_Rate100.def

    r21187 r24370  
    1 #NM_RateCrude1K_data_frame.def
     1#NM_Rate100.def
    22#Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp)
    33#Uses the IBIS-Q data_frame for cross1 and cross2
     
    3636 
    3737 *********************** 2. data_frame **************************;
    38  * df_%cross1%%cross2% is a dataset created by IBIS-Q.   ;
     38 * df_%cross1%%cross2% is a dataset created by IBIS-Q.           ;
    3939 * It consists of %cross1% and %cross2% (if the user specified   ;
    4040 * %cross2%) and a variable named "count" that is set to "0".    ;
    4141 * The results of the proc summary must be merged with the       ;
    42  * df_%cross1%%cross2% dataset.                          ;
     42 * df_%cross1%%cross2% dataset.                                  ;
    4343 ****************************************************************;
    4444        data frame;
     
    5252                run;
    5353
    54         data new;
     54        data tmp;
    5555                merge frame sorted;   *must list frame dataset first, then tmp;
    5656                by %cross1%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_Rate100ZIP.def

    r21187 r24370  
    5252                run;
    5353
    54         data new;
     54        data tmp;
    5555                merge frame sorted;   *must list frame dataset first, then tmp;
    5656                by %cross1%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_RateCrudeCOVID.def

    r21187 r24370  
    7272 * data, matching up the appropriate values of the cross vars.    ;
    7373 *****************************************************************;
    74         data poptmp; format %popcross1% %popcross2% 15.; set poptmp; run; 
    7574        %let flag=0;
    7675        ?popcross1? %let flag=1;
     
    9392
    9493        %if &flag=1 %then %do;
     94        data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 
    9595                proc summary data=poptmp;
    9696                        var popcount;
     
    110110
    111111        %if &flag=2 %then %do;
     112        data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 
    112113                proc summary data=poptmp;
    113114                        var popcount;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/_COVID19Cnty.cfg

    r21187 r24370  
    1414d saspath E:\ibisq\sasData\final\
    1515d saspop E:\ibisq\sasData\final\
    16 r sasdata covid_ibis
     16
     17r sasdata covid_ibis_cases
    1718d saspopdata popibiscnty90_18_28jun2019
     19
    1820d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    1921r data_where 1<=fipscnty<=97
     
    878920 null GeoProxy fipscode Geography num 10 8
    889020 fipscnty GeoCnty fipscode ResidentialCounty num 0 8
     9120 fipscnty GeoCntyRank fipscode ResidentialCounty num 0 8
    899220 region GeoRegion region HealthRegion num 0 8
    909320 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/_COVID19Sarea.cfg

    r21187 r24370  
    1414d saspath E:\ibisq\sasData\final\
    1515d saspop E:\ibisq\sasData\final\
     16
    1617r sasdata covid_sarea
    1718d saspopdata popibissarea90_18_28jun2019
     19
    1820d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    1921#r data_where mmwr_week^=0
  • adopters/nm/trunk/src/main/backend_qModules/2.3/infmort23/_InfMortSecure18.cfg

    r19153 r24370  
    77# Date        By         Description
    88# ----------  ---------  -------------------------------------------------
     9# 11/09/2020  Lois H      Added 2019 data
    910# 09/04/2019  Lois H      Added 2018 data
    1011# 08/02/2018  Lois H      Added 2017 data
     
    2223d saspop E:\ibisq\sasData\final
    2324
    24 d sasdata death99_17geo_18ngeo_ibis
    25 d saspopdata birth90_17geo_18ungeo
     25d sasdata death99_17geo_18_19ngeo
     26d saspopdata birth90_17geo_18_19ngeo
    2627#remember, use birth data for pop data!!
    2728
    2829d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2930
    30 r data_where (1999<=year<=2018&and&nmres=1&and&agepop=1)
    31 r pop_where (1999<=year<=2018)
     31r data_where (1999<=year<=2019&and&nmres=1&and&agepop=1)
     32r pop_where (1999<=year<=2019)
    3233
    3334####################################################################
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_Count_ARDI_data_frame.def

    r11779 r24370  
    11#NM_Count_ARDI_data_frame.def
    22#Counts records that have been filtered by IBIS-Q (data=tmp)
    3 #Numerator is sum of alcohol-attributable fraction (aaf2) values instead of "x" var
     3#Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var
    44#Uses the IBIS-Q data_frame for cross1 and cross2
    55#NM_ = New Mexico cell suppression version
     
    1818 * in already by ibis-q. Any filters have already been applied.  ;
    1919 * Proc summary counts number of deaths by cross1 and cross2.    ;
    20  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     20 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2121 ****************************************************************;
    2222        proc summary data=tmp;
    2323                format count 18.6;
    24                 var aaf2;
     24                var aaf3;
    2525                class %cross1%
    2626                ?cross2? %cross2%
     
    188188        data tmp;
    189189                set tmp;
    190                 if ((0<n<4) and (popcount<5000)) then do;
     190                if ((0<n<4) and (.<popcount<5000)) then do;
    191191                        n = .A;
    192192                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_3YrAvg_df.def

    r17280 r24370  
    22#Calculates age-adjusted rates for 3-year moving averages for 
    33#  records that have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55# values instead of "x" var
    66#Uses the IBIS-Q data_frame for cross1
     
    2121 * in already by ibis-q. Any filters have already been applied.  ;
    2222 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    23  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     23 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2424 * spvar1 is the first year that data are available for the      ;
    2525 * dataset. The spvar1 value is set in the Module.xml file.      ;
     
    2929        proc summary data=tmp nway; 
    3030                format count 15.6;
    31                 var aaf2;
     31                var aaf3;
    3232                class agepop %cross1%
    3333                ?cross2? %cross2%
     
    305305        data tmp;
    306306                set tmp;
    307                 if ((0<n<4) and (popcount3<5000)) then do;
     307                if ((0<n<4) and (.<popcount3<5000)) then do;
    308308                        n = .A;
    309309                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_5YrAvg_df.def

    r17280 r24370  
    22#Calculates age-adjusted rates for 5-year moving averages for
    33#  records that have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55# values instead of "x" var
    66#Uses the IBIS-Q data_frame for cross1
     
    2121 * in already by ibis-q. Any filters have already been applied.  ;
    2222 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    23  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     23 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2424 * spvar1 is the first year that data are available for the      ;
    2525 * dataset. The spvar1 value is set in the Module.xml file.      ;
     
    2929        proc summary data=tmp nway;
    3030                format count 15.6;
    31                 var aaf2;
     31                var aaf3;
    3232                class agepop %cross1%
    3333                ?cross2? %cross2%
     
    305305        data tmp;
    306306                set tmp;
    307                 if ((0<n<4) and (popcount5<5000)) then do;
     307                if ((0<n<4) and (.<popcount5<5000)) then do;
    308308                        n = .A;
    309309                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_data_frame.def

    r17280 r24370  
    22#Calculates directly age-adjusted rates for records that
    33# have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55#Uses the IBIS-Q data_frame for cross1 and cross2
    66#Uses an "agepop_frame" so all agepop groups are always included/represented
     
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        proc summary data=tmp;
    2525                format count 15.6;
    26                 var aaf2;
     26                var aaf3;
    2727                class agepop %cross1%
    2828                ?cross2? %cross2%
     
    275275        data tmp;
    276276                set tmp;
    277                 if ((0<n<4) and (popcount<5000)) then do;
     277                if ((0<n<4) and (.<popcount<5000)) then do;
    278278                        n = .A;
    279279                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_data_frame_legis.def

    r17669 r24370  
    5151 ***********************************************************************************;
    5252        proc summary data=tmp;
    53                 var aaf2;
     53                var aaf3;
    5454                class &STDVAR %cross1%
    5555                ?cross2? %cross2%
     
    289289        data tmp;
    290290                set rate;
    291                 if popcount=. and (0<n<4) then delete; *if unknown row is only suppressed row;
    292                 else if ((0<n<4) and (popcount<5000)) then do;
     291                else if ((0<n<4) and (.<popcount<5000)) then do;
    293292                        n = .A;
    294293                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_data_frame.def

    r17280 r24370  
    291291                        n = .A;
    292292                        rateper = .A;
     293                        popcount = .A;
    293294                        LL = put('**', 8.0);
    294295                        UL = put('**', 8.0);
     
    322323 n
    323324 rateper
    324 --------BoNdArY--------
     325 popcount
     326--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_3YrAvg_df.def

    r17280 r24370  
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        %let begyear=%spvar1%;
     
    2626        proc summary data=tmp;
    2727                format count 15.6;
    28                 var aaf2;
     28                var aaf3;
    2929                class %cross1%
    3030                ?cross2? %cross2%
     
    203203        data tmp;
    204204                set tmp;
    205                 if ((0<n<4) and (popcount3<5000)) then do;
     205                if ((0<n<4) and (.<popcount3<5000)) then do;
    206206                        n = .A;
    207207                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_5YrAvg_df.def

    r17280 r24370  
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        %let begyear=%spvar1%;
     
    2626        proc summary data=tmp;
    2727                format count 15.6;
    28                 var aaf2;
     28                var aaf3;
    2929                class %cross1%
    3030                ?cross2? %cross2%
     
    203203        data tmp;
    204204                set tmp;
    205                 if ((0<n<4) and (popcount5<5000)) then do;
     205                if ((0<n<4) and (.<popcount5<5000)) then do;
    206206                        n = .A;
    207207                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_data_frame.def

    r17280 r24370  
    11#NM_RateCrude100K_ARDI_data_frame.def
    22#Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp)
    3 #Numerator is sum of alcohol-attributable fraction (aaf2) values instead of "x" var
     3#Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var
    44#Uses the IBIS-Q data_frame for cross1 and cross2
    55#NM_ = New Mexico cell suppression version
     
    1818 * in already by ibis-q. Any filters have already been applied.  ;
    1919 * Proc summary counts number of deaths by cross1 and cross2.    ;
    20  * The variable "aaf2" must be in the dataset.                   ;
     20 * The variable "aaf3" must be in the dataset.                   ;
    2121 ****************************************************************;
    2222        proc summary data=tmp;
    2323                format count 15.6;
    24                 var aaf2;
     24                var aaf3;
    2525                class %cross1%
    2626                ?cross2? %cross2%
     
    187187        data tmp;
    188188                set tmp;
    189                 if ((0<n<4) and (popcount<5000)) then do;
     189                if ((0<n<4) and (.<popcount<5000)) then do;
    190190                        n = .A;
    191191                        rateper = .A;
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_data_frame.def

    r19153 r24370  
    1010--------BoNdArY--------
    11111 script
    12 OPTIONS MPRINT MLOGIC SYMBOLGEN NONUMBER NODATE PAGESIZE=4000;
     12OPTIONS MPRINT MLOGIC MLOGICNEST SYMBOLGEN MPRINTNEST MEXECNOTE NONUMBER NODATE PAGESIZE=4000;
    1313OPTION SPOOL;
    1414
     
    7979                if fipscode in (88 99) and count in (0 1 2 3) then delete;
    8080                run;
    81         %end;   
     81        %end;
    8282        %mend unkncnty;
    8383        %unkncnty;
     
    204204                        n = .A;
    205205                        rateper = .A;
     206                        popcount = .A;
    206207                        LL = put('**', 8.0);
    207208                        UL = put('**', 8.0);
     
    234235 ********************************************************************;
    235236--------BoNdArY--------
    236 1 suppressed_variables 2
     2371 suppressed_variables 5
    237238  rateper
    238239  n
    239 --------BoNdArY--------
     240  popcount
     241  LL
     242  UL
     243--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_3YrAvg_df.def

    r17280 r24370  
    22#Calculates age-adjusted rates for 3-year moving averages for 
    33#  records that have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55# values instead of "x" var
    66#Uses the IBIS-Q data_frame for cross1
     
    2121 * in already by ibis-q. Any filters have already been applied.  ;
    2222 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    23  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     23 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2424 * spvar1 is the first year that data are available for the      ;
    2525 * dataset. The spvar1 value is set in the Module.xml file.      ;
     
    2929        proc summary data=tmp nway; 
    3030                format count 15.6;
    31                 var aaf2;
     31                var aaf3;
    3232                class agepop %cross1%
    3333                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_5YrAvg_df.def

    r17280 r24370  
    22#Calculates age-adjusted rates for 5-year moving averages for
    33#  records that have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55# values instead of "x" var
    66#Uses the IBIS-Q data_frame for cross1
     
    2121 * in already by ibis-q. Any filters have already been applied.  ;
    2222 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    23  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     23 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2424 * spvar1 is the first year that data are available for the      ;
    2525 * dataset. The spvar1 value is set in the Module.xml file.      ;
     
    2929        proc summary data=tmp nway;
    3030                format count 15.6;
    31                 var aaf2;
     31                var aaf3;
    3232                class agepop %cross1%
    3333                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_data_frame.def

    r17280 r24370  
    22#Calculates directly age-adjusted rates for records that
    33# have been filtered by IBIS-Q (data=tmp)
    4 #Numerator is sum of alcohol-attributable fraction (aaf2)
     4#Numerator is sum of alcohol-attributable fraction (aaf3)
    55#Uses the IBIS-Q data_frame for cross1 and cross2
    66#Uses an "agepop_frame" so all agepop groups are always included/represented
     
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        proc summary data=tmp;
    2525                format count 15.6;
    26                 var aaf2;
     26                var aaf3;
    2727                class agepop %cross1%
    2828                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_3YrAvg_df.def

    r17280 r24370  
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        %let begyear=%spvar1%;
     
    2626        proc summary data=tmp;
    2727                format count 15.6;
    28                 var aaf2;
     28                var aaf3;
    2929                class %cross1%
    3030                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_5YrAvg_df.def

    r17280 r24370  
    2020 * in already by ibis-q. Any filters have already been applied.  ;
    2121 * The proc summary counts deaths by agepop, cross1, and cross2. ;
    22  * "aaf2" the attrib fraction variable, must be in the dataset.  ;
     22 * "aaf3" the attrib fraction variable, must be in the dataset.  ;
    2323 ****************************************************************;
    2424        %let begyear=%spvar1%;
     
    2626        proc summary data=tmp;
    2727                format count 15.6;
    28                 var aaf2;
     28                var aaf3;
    2929                class %cross1%
    3030                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_data_frame.def

    r17280 r24370  
    11#S_ND_RateCrude100K_ARDI_data_frame.def
    22#Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp)
    3 #Numerator is sum of alcohol-attributable fraction (aaf2) values instead of "x" var
     3#Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var
    44#Uses the IBIS-Q data_frame for cross1 and cross2
    55#S_ND_ = Secure, No-Dagger version
     
    1919 * in already by ibis-q. Any filters have already been applied.  ;
    2020 * Proc summary counts number of deaths by cross1 and cross2.    ;
    21  * The variable "aaf2" must be in the dataset.                   ;
     21 * The variable "aaf3" must be in the dataset.                   ;
    2222 ****************************************************************;
    2323        proc summary data=tmp;
    2424                format count 15.6;
    25                 var aaf2;
     25                var aaf3;
    2626                class %cross1%
    2727                ?cross2? %cross2%
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_Mort18.cfg

    r19153 r24370  
    55# Date        By          Description
    66# ----------  ---------   -------------------------------------------------
     7# 11/09/2020  Lois H      added 2019
    78# 08/02/2018  Lois H      added 2018
    89# 08/02/2018  Lois H      added 2017
     
    1920
    2021r sasdata death99_17geo_18ngeo_ibis
    21 d saspopdata popibiscnty90_18_28jun2019
     22d saspopdata popibiscnty90_19_20oct2020
    2223
    2324d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortLegis17.cfg

    r20394 r24370  
    3434r cross1 AgeGrpProxy
    3535r cross2 none
     36r popcross1 none
     37r popcross2 none
    3638r spvar1 none
    3739#r pass_through none
     
    82842 NCHS50 ICDNCHS15LCD null 15NMleadingcauses num 0 8
    83852 NCHS113 ICDNCHS113 null NCHS113causes num 0 8
    84 2 aaf2_3a_cat CauseAlcohol null AlcoholRelated num 0 8
     862 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8
    85872 drug_od CauseDrug null DrugOverdose num 0 8
    86882 drug_od2 CauseDrug2 null DrugOverdose num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSDH17.cfg

    r20394 r24370  
    4242r cross1 AgeGrpProxy
    4343r cross2 none
     44r popcross1 none
     45r popcross2 none
    4446r spvar1 none
    4547#r pass_through none
     
    93952 NCHS50 ICDNCHS50 null NCHS50leadingcauses num 0 8
    94962 NCHS113 ICDNCHS113 null NCHS113causes num 0 8
    95 2 aaf2_3a_cat CauseAlcohol null AlcoholRelated num 0 8
     972 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8
    96982 drug_OD2 CauseDrug null DrugOverdose num 0 8
    97992 injwork CauseWork null Workrelated num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSarea17.cfg

    r18931 r24370  
    1919d saspop E:\ibisq\sasData\final\
    2020
    21 r sasdata death99_17geo_ibis
     21r sasdata death99_17geo_18_19ngeo
    2222d saspopdata popibissarea90_18_28jun2019
    2323
     
    88882 nchs50 ICDNCHS15LCD null 15NMleadingcauses num 0 8
    89892 nchs113 ICDNCHS113 null NCHS113causes num 0 8
    90 2 aaf2_3a_cat CauseAlcohol null AlcoholRelated num 0 8
     902 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8
    91912 drug_od CauseDrug null DrugOverdose num 0 8
    92922 drug_od2 CauseDrug2 null DrugOverdose num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSareaSecure17.cfg

    r18931 r24370  
    88882 NCHS50 ICDNCHS15LCD null 15NMleadingcauses num 0 8
    89892 NCHS113 ICDNCHS113 null NCHS113causes num 0 8
    90 2 aaf2_3a_cat CauseAlcohol null AlcoholRelated num 0 8
     902 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8
    91912 drug_od CauseDrug null DrugOverdose num 0 8
    92922 drug_od2 CauseDrug2 null DrugOverdose num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSecure18.cfg

    r19153 r24370  
    55# Date        By          Description
    66# ----------  ---------   -------------------------------------------------
     7# 11/09/2020  Lois H      added 2019
    78# 08/02/2018  Lois H      added 2017
    89# 07/25/2017  Lois H      added 2016 data and denominators
     
    1920
    2021r sasdata death99_17geo_18ngeo_ibis
    21 d saspopdata popibiscnty90_18_28jun2019
     22d saspopdata popibiscnty90_19_20oct2020
    2223
    2324d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
Note: See TracChangeset for help on using the changeset viewer.