Changeset 19915 in main


Ignore:
Timestamp:
02/28/20 16:35:50 (5 weeks ago)
Author:
LoisHaggard_NM
Message:

NM backend qModules files update

Location:
adopters/nm/trunk/src/main/backend_qModules
Files:
2 added
6 deleted
4 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/pcc/NM_Count_df_unks.def

    r12040 r19915  
    113113                proc sql;
    114114                        create table rate as
    115                         select tmp.*, pop.*
    116                         from tmp
    117                          full join pop on tmp.%cross1%=pop.%popcross1%;
     115                        select tmp.*, pop.*,
     116                        coalesce
     117                        ?popcross1? (tmp.%cross1%, pop.%popcross1%)
     118                        ?popcross2? (tmp.%cross2%, pop.%popcross2%)
     119                        from pop full join tmp
     120                        on
     121                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
     122                        ?popcross2? tmp.%cross2%=pop.%popcross2%;
    118123                quit;
    119124        %end;
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/pcc/NM_RateCrude100K_df_unks.def

    r17280 r19915  
    106106                        create table rate as
    107107                        select tmp.*, pop.*
    108                         from tmp
    109                          full join pop on tmp.%cross1%=pop.%popcross1%;
     108                        from tmp, pop
     109                        where
     110                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
     111                        ?popcross2? tmp.%cross2%=pop.%popcross2%;
    110112                quit;
    111113        %end;
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/pcc/_pcc_co.cfg

    r18931 r19915  
    2424d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2525r sas_bin sas&-memsize&0
    26 r pop_where 2008<=year<=2018
    27 r data_where 2008<=year<=2018
     26r pop_where 2008<=year<=2019
     27r data_where 2008<=year<=2019
    2828r sasstdpop morstd
    2929####################################################################
  • adopters/nm/trunk/src/main/backend_qModules/pop/_PopSarea18.cfg

    r18931 r19915  
    87878 region GeoRegion region NMRegion num 0 8
    8888
    89 # The popcount variable is only referenced in the .DEF files ==============
     89# The popcount variable is referenced in the .DEF files, ***
     90# it does not need to be included here.                  ***
    9091
    9192
Note: See TracChangeset for help on using the changeset viewer.