Changeset 20965 in main


Ignore:
Timestamp:
07/05/20 17:40:33 (4 weeks ago)
Author:
LoisHaggard_NM
Message:

NMBIS and NMEPHT Backend QModules - Working on fixing issues due to mapped drive disappearing during a previous commit

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0
Files:
64 added
4 edited

Legend:

Unmodified
Added
Removed

  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/wateranalytes/ConcsMax.def

    r19939 r20965  
    3838#################################################
    3939# definition for output file
    40 f xml_out_map_file XMLCount.map
     40f xml_out_map_file XMLMaxA.map
    4141--------BoNdArY--------
    4242f out_detail lbl_not_used__see_xml_out_map_file

  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/wateranalytes/ConcsMeans.def

    r19939 r20965  
    3131run;
    3232--------BoNdArY--------
    33 f out_variable count
     33f out_variable Mean
    3434#################################################
    3535# definition for output file
    36 f xml_out_map_file XMLCount.map
     36#  analytecode  $5.
     37
     38f xml_out_map_file XMLMeanA.map
    3739--------BoNdArY--------
    3840f out_detail lbl_not_used__see_xml_out_map_file
     41  AnalyteCode $5
     42  Year_S 4.0
    3943  Mean  12.2
    4044--------BoNdArY--------

  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/wateranalytes/_WaterAnalytes.cfg

    r19939 r20965  
    1 #==============================================================================
     1#=========================================================================
    22# IBIS-Q Configuration File
    33# 
    44# Modifications:
    55# Date        By          Description
    6 # ----------  ----------  -------------------------------------------------
     6# ----------  ----------  ------------------------------------------------
    77# 12/02/2013  Brian       Use NM Water module model and cfg. 
    8 #==============================================================================
     8#=========================================================================
    99#value name_path value_path   
    1010d homepath E:\ibisq\qModules30\_EPHT\wateranalytes
    … …  
    1414d sasdata water_cwsanalytes
    1515d sascdata temp
    16 ####################################################################
     16##########################################################################
    1717d response_head_content XMLResponse.head
    1818d response_tail_content XMLResponse.tail
    19 #####################################################################
     19##########################################################################
    2020r form 30
    2121r output xml
    … …  
    2626r sas 0
    2727r test 0
    28 #############################################################################
     28##########################################################################
    2929#value =any value, place holder only
    3030# name_sas  = SAS variable name in the numerator data set (birth data set)
    31 # name_html = html name that specified under <DIMENSION> <NAME> in Module XML file
    32 # name_pop  = SAS variable name in denominator data set (population data set)
    33 # prompt    = Place holder only, could by any character string. (I used x to pad the line)
    34 # type1     = CGI data type for SAS variable type (see comment lines 48 & 49)
    35 # type2     = CGI data type for CGI regrouping purpose (see comment lines 51-59)
     31# name_html = html name that specified under <DIMENSION> <NAME> in Module
     32#                         XML file
     33# name_pop  = SAS variable name in denominator data set (population)
     34# prompt    = Place holder only, could by any character string.
     35# type1     = CGI data type for SAS variable type (see lines 48 & 49)
     36# type2     = CGI data type for CGI regrouping purpose (see lines 51-59)
    3637# length    = used to indicate the variable length in SAS dataset
    3738#
    … …  
    4849#        9 -- Disable variable (To avoid conflict)
    4950#       10 –  Proxy variable
    50 #============================================================================
     51#=========================================================================
    5152#value name_sas Dimension_name_html name_pop prompt type1 type2 length 
    52 #============================================================================
     53#=========================================================================
    5354
    54 1 year_s Year_S null Year num 0 4
    55 2 PWSID CWSInventory null Community&Water&System num 0 8
     551 year_s Year null Year num 0 4
     562 PWSID PWSInventory null Community&Water&System num 0 8
    56573 AnalyteCode AnalyteType Null Water&Contaminant char 0 4
    57583 ConcentrationUnits UnitsType null Concentration&Units char 0 4

  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/NM_RateBirth1KGirls_3YrAvg.def

    r20663 r20965  
    108108                        create table numbers as
    109109                        select tmp.*, pop.*
    110                         from tmp, pop
    111                         where
     110                        from tmp left join pop
     111                        on
    112112                        ?popcross1? tmp.%cross1%=pop.%popcross1%;
    113113                        ?popcross2? tmp.%cross2%=pop.%popcross2%; 
    … …  
    124124                        create table numbers as
    125125                        select tmp.*, pop.*
    126                         from tmp, pop
    127                         where tmp.%cross1%=pop.%popcross1% and
     126                        from tmp left join pop
     127                        on
     128                        tmp.%cross1%=pop.%popcross1% and
    128129                        tmp.%cross2%=pop.%popcross2%;
    129130                quit;
Note: See TracChangeset for help on using the changeset viewer.