Changeset 20946 in main


Ignore:
Timestamp:
07/05/20 13:54:43 (6 weeks ago)
Author:
LoisHaggard_NM
Message:

nm backend qModules 3.0 mort

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/mort
Files:
2 added
6 deleted
11 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_Count.def

    r20538 r20946  
    100100                        create table rate as
    101101                        select tmp.*, pop.*
    102                         from tmp, pop
    103                         where
     102                        from tmp left join pop
     103                        on
    104104                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    105105                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    116116                        create table rate as
    117117                        select tmp.*, pop.*
    118                         from tmp, pop
    119                         where tmp.%cross1%=pop.%popcross1% and
     118                        from tmp left join pop
     119                        on
     120                        tmp.%cross1%=pop.%popcross1% and
    120121                        tmp.%cross2%=pop.%popcross2%;
    121122                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_Count_ARDI.def

    r20538 r20946  
    104104                        create table rate as
    105105                        select tmp.*, pop.*
    106                         from tmp, pop
    107                         where
     106                        from tmp left join pop
     107                        on
    108108                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    109109                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    120120                        create table rate as
    121121                        select tmp.*, pop.*
    122                         from tmp, pop
    123                         where tmp.%cross1%=pop.%popcross1% and
     122                        from tmp left join pop
     123                        on
     124                        tmp.%cross1%=pop.%popcross1% and
    124125                        tmp.%cross2%=pop.%popcross2%;
    125126                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_Count_YPLL.def

    r20538 r20946  
    101101                        create table rate as
    102102                        select tmp.*, pop.*
    103                         from tmp, pop
    104                         where
     103                        from tmp left join pop
     104                        on
    105105                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    106106                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    117117                        create table rate as
    118118                        select tmp.*, pop.*
    119                         from tmp, pop
    120                         where tmp.%cross1%=pop.%popcross1% and
     119                        from tmp left join pop
     120                        on
     121                        tmp.%cross1%=pop.%popcross1% and
    121122                        tmp.%cross2%=pop.%popcross2%;
    122123                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_RateCrude100K.def

    r20633 r20946  
    119119                        select tmp.*, pop.*
    120120                        from tmp left join pop
    121                         on tmp.%cross1%=pop.%popcross1% and
     121                        on
     122                        tmp.%cross1%=pop.%popcross1% and
    122123                        tmp.%cross2%=pop.%popcross2%;
    123124                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_RateCrude100K_3YrAvg.def

    r20538 r20946  
    2424 ****************************************************************;
    2525        %let begyear=%spvar1%; *set beg year for year groups;
     26       
     27        *this is to get the value of the last year for the YearGrp3Yrs dimension value.;
     28        proc summary data=tmp nway ; class year; var x; output out=years n(x)=number; run;
     29        data lastyear; set years; if year=last.year; run;
     30        proc print years; run;
    2631
    2732        proc summary data=tmp;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_RateCrude100K_ARDI.def

    r20538 r20946  
    9898                        create table rate as
    9999                        select tmp.*, pop.*
    100                         from tmp, pop
    101                         where
     100                        from tmp left join pop
     101                        on
    102102                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    103103                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    114114                        create table rate as
    115115                        select tmp.*, pop.*
    116                         from tmp, pop
    117                         where tmp.%cross1%=pop.%popcross1% and
     116                        from tmp left join pop
     117                        on
     118                        tmp.%cross1%=pop.%popcross1% and
    118119                        tmp.%cross2%=pop.%popcross2%;
    119120                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_RateCrude100K_YPLL.def

    r20538 r20946  
    105105                        create table rate as
    106106                        select tmp.*, pop.*
    107                         from tmp, pop
    108                         where
     107                        from tmp left join pop
     108                        on
    109109                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    110110                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
     
    121121                        create table rate as
    122122                        select tmp.*, pop.*
    123                         from tmp, pop
    124                         where tmp.%cross1%=pop.%popcross1% and
     123                        from tmp left join pop
     124                        on
     125                        tmp.%cross1%=pop.%popcross1% and
    125126                        tmp.%cross2%=pop.%popcross2%;
    126127                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/NM_RateCrude10K.def

    r20538 r20946  
    124124                        select tmp.*, pop.*
    125125                        from tmp left join pop
    126                         on tmp.%cross1%=pop.%popcross1% and
     126                        on
     127                        tmp.%cross1%=pop.%popcross1% and
    127128                        tmp.%cross2%=pop.%popcross2%;
    128129                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/_Mort17Legis.cfg

    r20544 r20946  
    72721 null YearProxy year Year num 10 8
    73731 year Year year YearofDeath num 0 8
    74 1 year Year9 year YearofDeath num 3 8
    75 1 year YearGrp3Yrs year YearofDeath num 0 8
    76 1 year YearGrp5Yrs year YearofDeath num 0 8
     741 year Year9 year UserSpecifiedYearGrps num 3 8
     751 year YearGrp3 year YearsforDynamicYrGrps num 3 8
     761 year YearGrp5 year YearsforDynamicYrGrps num 3 8
     771 year YearGrp3Yrs year YearsforRollingAvg num 0 8
     781 year YearGrp5Yrs year YearsforRollingAvg num 0 8
    7779
    78802 null CauseDeathProxy null CauseofDeath char 10 8
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/_Mort18.cfg

    r20549 r20946  
    72721 null YearProxy year Year num 10 8
    73731 year Year year YearofDeath num 0 8
    74 1 year Year9 year YearofDeath num 3 8
    75 1 year YearGrp3Yrs year YearofDeath num 0 8
    76 1 year YearGrp5Yrs year YearofDeath num 0 8
     741 year Year9 year UserSpecifiedYearGrps num 3 8
     751 year YearGrp3 year YearsforDynamicYrGrps num 3 8
     761 year YearGrp5 year YearsforDynamicYrGrps num 3 8
     771 year YearGrp3Yrs year YearsforRollingAvg num 0 8
     781 year YearGrp5Yrs year YearsforRollingAvg num 0 8
    7779
    78802 null CauseDeathProxy null CauseofDeath char 10 8
     
    1161186 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
    1171196 Sarea134 GeoSarea Sarea134 ResidentSmallArea num 0 8
     1207 nmres GeoRes null NMResidence num 0 8
    1181217 res_st2 State null NMResidentDeaths char 0 8
    119 7 nmres GeoRes null NMResidence num 0 8
     122
    120123#~~~~~~~~~~~~~~~~~~~ END OF CFG FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    121124#Additional Vars not listed above that are referenced in .def files:
  • adopters/nm/trunk/src/main/backend_qModules/3.0/mort/_MortSarea17.cfg

    r20797 r20946  
    71711 null YearProxy year Year num 10 8
    72721 year Year year YearofDeath num 0 8
    73 1 year Year9 year YearofDeath num 3 8
    74 1 year YearGrp3Yrs year YearofDeath num 0 8
    75 1 year YearGrp5Yrs year YearofDeath num 0 8
    76 1 year YearGrp3 year YearofDeath num 3 8
    77 1 year YearGrp5 year YearofDeath num 3 8
    78 1 year YearRangeAll year Year num 0 8
     731 year Year9 year UserSpecifiedYearGrps num 3 8
     741 year YearGrp3 year YearsforDynamicYrGrps num 3 8
     751 year YearGrp5 year YearsforDynamicYrGrps num 3 8
     761 year YearRangeAll year YearsforDynamicYrGrps num 3 8
     771 year YearGrp3Yrs year YearsforRollingAvg num 0 8
     781 year YearGrp5Yrs year YearsforRollingAvg num 0 8
    7979
    80802 null CauseDeathProxy null CauseofDeath char 10 8
Note: See TracChangeset for help on using the changeset viewer.