Changeset 13220 in main


Ignore:
Timestamp:
02/23/17 17:46:39 (5 years ago)
Author:
Lois Haggard
Message:

nm backend qModules update

Location:
adopters/nm/trunk/src/main/backend_qModules
Files:
20 added
4 deleted
27 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/SDH/_MortSDH14.cfg

    r12680 r13220  
    2424d saspop E:\ibisq\sasData\final\
    2525r sasdata sdhmort09_13
    26 d saspopdata sdhpoptrct09_13
     26d saspopdata sdhpoptrct09_14
    2727d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2828#r sas_bin sas&-memsize&0
     
    1061063 agegrp7 AgeGrp7 agegrp7 AgeatDeath num 0 8
    1071073 agegrp8 AgeGrp8 agegrp8 AgeatDeath num 0 8
     1083 agegrp9 AgeGrp9 agegrp9 AgeatDeath num 0 8
    1081093 agepop AgeGrp11 agepop AgeatDeath num 0 8
    1091103 agegrp13 AgeGrp13 agegrp13 AgeatDeath num 0 8
     
    1111123 agegrp19 AgeGrp19 agegrp19 AgeatDeath num 0 8
    1121133 agegrp35 AgeGrp35 agegrp35 AgeatDeath num 0 8
    113        
     114
    1141154 sex Sex sex Sex num 0 8
    115116
    1161175 DOHRaceth RacEth DOHRaceth Race num 0 8
    117        
     118
    1181196 null GeoProxy null GeographicAreaSpecified num 10 8
    1191206 fipscode GeoCnty fipscode ResidentialCounty num 0 8
     
    1331347 NMRes GeoRes null NM&Resident&Births num 0 8
    1341357 stocc NMOccur null NM&Occurrent&Births num 0 8
    135        
     136
    1361379 stdyr stdpop null StandardPopulation num 7 8
    137138#~~~~~~~~~~~~~~~~~~~ END OF CFG FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/airq/PM25Average_ESC.def

    r12040 r13220  
    66OPTIONS MPRINT MLOGIC SYMBOLGEN NONUMBER NODATE PAGESIZE=4000;
    77
    8  **************** 1. ********************************************;
    9  * Cleanup input data set (get rid of output of proc summary     ;
    10  *      _TYPE_ = 0,1,2 (0=grand total, 1 sum across 1st class var .. ;
    11  * Calculate pct_running                                         ;
    12  ****************************************************************;
    13 
    14  data tmp;
    15                 set tmp;
    16                         if _TYPE_ =3;
    17         /*
    18         if daysbetween = .
    19                 then pct_running = 0;
    20         else if daysbetween = 1
    21                 then pct_running = n/ndays;
    22         else if daysbetween = 3
    23                 then pct_running = n/121;
    24         proc print data=tmp; title1 '================'; title2 'tmp';   
    25         run;
    26  */
    27  **************** 2. ********************************************;
    28  * Get nway totals/averages.                                     ;
    29  * cross1, _RowGroupByDimensionName is GeoProxy                  ;
    30  * cross2, _ColumnGroupByDimensionName is Year                   ;
    31  ****************************************************************;
    32 
    33    /*   proc summary data=tmp nway;
    34                var mean pct_running;
     8      proc summary data=tmp nway;
     9               var mean;
    3510               class %cross1%
    3611               ?cross2? %cross2%
    3712               ;
    38                 output out=tmp mean(mean)=mean mean(pct_running)=pct_running;
    39         */
     13                output out=tmp mean(mean)=mean;
     14       
    4015                proc print data=tmp;  title2 'nway tmp';
    4116                run;
     
    5631                end;
    5732        run;
     33
    5834        proc print data=tmp noobs; title2 'tmp3'; run;
    5935
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/airq/_O3.cfg

    r12680 r13220  
    55# Date        By                Description
    66# ----------  ----------        -------------------------------------------------
    7 # 07/05/11    Paul                      Air Quality Module
     7# 07/05/11    Paul                      Ozone - Days Above Regulatory Standard
    88#
    99#
     
    2525d saspath E:\ibisq\sasData\final\
    2626d saspop E:\ibisq\sasData\final\
    27 d sasdata airq_days_O3_exceed
     27d sasdata airq_O3_exceed
    2828d saspopdata popibiscnty90_15_11oct2016
    2929
    3030d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    3131
    32 #r data_where 2001<=Year<=2011
    33 r pop_where 2001<=Year<=2014
     32#r data_where 2001<=Year<=2015
     33r pop_where 2001<=Year<=2015
    3434r sasstdpop morstd
    3535##################################################################################
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/airq/_PM25AverageLURBME.cfg

    r12680 r13220  
    55# Date        By                Description
    66# ----------  ----------        -------------------------------------------------
    7 # 07/05/11    Paul                      Air Quality Module
     7# 07/05/11    Paul                      LURBME Model: Annual PM2.5 Concentration
    88#
    99#
     
    2727d saspopdata popibiscnty90_15_11oct2016
    2828d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    29 #r data_where 2001<=Year<=2011
    30 r pop_where 1999<=Year<=2008
     29#r data_where 2000<=Year<=2012
     30r pop_where 1999<=Year<=2012
    3131r sasstdpop morstd
    3232##################################################################################
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/airq/_PM25Average_ESC.cfg

    r12680 r13220  
    55# Date        By          Description
    66# ----------  ----------  ---------------------------------------
    7 # 07/05/11    Paul        Air Quality Module
     7# 07/05/11    Paul        Average Annual PM2.5 Concentration
    88#
    99#====================================================================
     
    2525d saspath E:\ibisq\sasData\final\
    2626d saspop E:\ibisq\sasData\final\
    27 d sasdata annual_pm25
     27d sasdata airq_pm25_means
    2828d saspopdata popibiscnty90_15_11oct2016
    2929d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    30 r data_where 1999<=Year<=2014
    31 r pop_where 1999<=Year<=2014
     30r data_where 1999<=Year<=2015
     31r pop_where 1999<=Year<=2015
    3232r sasstdpop morstd
    3333#####################################################################
     
    656511 null GeoProxy null Geo num 10 8
    666611 fipscode GeoCnty fipscode County num 0 8
    67 12 nyear Year year year num 0 8
    68 12 nyear YearPM25Avg year year num 0 8
     6712 year Year year year num 0 8
     68#12 nyear YearPM25Avg year year num 0 8
    6969#13 valid avalid null valid num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/airq/_PM25_ESC.cfg

    r12680 r13220  
    55# Date        By          Description
    66# ----------  ----------  -------------------------------------------------
    7 # 07/05/11    Paul        Air Quality Module
     7# 07/05/11    Paul        PM2.5 - Days /person-days Above Regulatory Standard
    88# 01/19/14    P Leo       Mostly name changes and note can be set up for local or prod
    99#==============================================================================
     
    2323d saspath E:\ibisq\sasData\final\
    2424d saspop E:\ibisq\sasData\final\
    25 d sasdata daily_pm25
     25d sasdata airq_pm25_exceed
    2626d saspopdata popibiscnty90_15_11oct2016
    2727d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    28 r data_where 1999<=Year<=2014
    29 r pop_where 1999<=Year<=2014
     28r data_where 1999<=Year<=2015
     29r pop_where 1999<=Year<=2015
    3030r sasstdpop morstd
    3131##################################################################################
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/birth/_BirthEPHT13.cfg

    r12040 r13220  
    2828d saspath E:\ibisq\sasData\final
    2929d saspop E:\ibisq\sasData\final\
    30 d sasdata birth90_14ibis
     30d sasdata birth90_15ibis
    3131d saspopdata popibiscnty90_15_11oct2016
    3232d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/birth/_BirthEPHT14.cfg

    r12040 r13220  
    2828d saspath E:\ibisq\sasData\final
    2929d saspop E:\ibisq\sasData\final\
    30 d sasdata birth90_14ibis
     30d sasdata birth90_15ibis
    3131d saspopdata popibiscnty90_15_11oct2016
    3232d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/birthdefects/BirthDefects.cfg

    r12040 r13220  
    1717d saspop E:\ibisq\sasData\final\
    1818d sasdata birthdefects06_11
    19 d saspopdata birth90_14ibis
     19d saspopdata birth90_15ibis
    2020d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2121#r sas_bin sas&-memsize&0
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/birthdefects/_BirthDefects.cfg

    r12040 r13220  
    1717d saspop E:\ibisq\sasData\final\
    1818d sasdata birthdefects06_11
    19 d saspopdata birth90_14ibis
     19d saspopdata birth90_15ibis
    2020d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2121#r sas_bin sas&-memsize&0
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/childlead/_childlead.cfg

    r12040 r13220  
    66# ----------  --------  -------------------------------------------------
    77# 08/23/2010  Brian     Initial New Mexico Childhood Lead Testing for EPHT.
    8 # 10/09/2013  Brian             Data updates, cohorts 2006-2009
    9 # 08/10/2016  Tony              Data updates, cohorts 2006-2012
    10 #
     8# 10/09/2013  Brian     Data updates, cohorts 2006-2009
     9# 08/10/2016  Tony      Data updates, cohorts 2006-2012
     10# 02/23/2017  Lois      Removed NMRes from popwhere, cleaned out some old stuff
    1111#==============================================================================
    1212
     
    1919d saspop E:\ibisq\sasData\final\
    2020d sasdata childlead
     21d saspopdata birth90_15ibis
     22d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2123r data_where 2006<=bcyear<=2012
    22 d saspopdata birth90_14ibis
    23 #d saspopdata birth90_11geosecure
    2424r pop_where 2006<=year<=2012&and&NMRes=1
    25 d sasstdpop morstd
    26 r pop_where stdyr=2000
    2725d sascdata temp
    28 #d sas_bin C:\SASServer9.1.3\sas\sas.exe
    29 #d sas_bin "C:\Program&Files\SAS\SASFoundation\9.2\sas.exe"
    30 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    31 #r sas_bin sas&-memsize&0
    3226####################################################################
    3327d response_head_content XMLResponse.head
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/childlead/_childlead6in1.cfg

    r12040 r13220  
    8686
    87876 null GeoProxy null ProxyVar num 10 4
    88 6 HealthRegion GeoRegion null NMRegion num 0 8
     88#6 HealthRegion GeoRegion null NMRegion num 0 8
    89896 Cnty GeoCnty fipscode NM&Counties num 0 8
    9090
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/childlead/_childleadtested6in1.cfg

    r12040 r13220  
    87876 null GeoProxy null ProxyVar num 10 4
    88886 Cnty GeoCnty fipscode NM&Counties num 0 8
    89 #6 HealthRegion GeoRegion null NMRegion num 0 8
     896 HealthRegion GeoRegion null NMRegion num 0 8
    9090
    9191#7 stdyr stdpop null Standard&Population num 7 8
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/hidd/_HIDD.cfg

    r12680 r13220  
    1616# 6/18/2010   Brian     Adapt HIDD developments to EPHT
    1717# 4/22/2013   Brian     Adapt HIDD-EPHT to developments in ibph-view and related nesting problems
    18 # 9/23/2013   Brian(brd)Current data through 2014 
     18# 9/23/2013   Brian(brd)Current data through 2014
     19# 1/24/2017   Brian(brd)Current data through 2015
    1920#
    2021#==============================================================================
     
    2526d saspath E:\ibisq\sasData\final\
    2627d saspop E:\ibisq\sasData\final\
    27 d sasdata hiddepht2014
     28d sasdata hiddepht2015
    2829d saspopdata popibiscnty90_15_11oct2016
    2930d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" -MEMMAXSZ 5G -MEMCACHE 4 -MEMLIB
    3031#r sas_bin sas&-memsize&0
    31 r pop_where 1999<=year<=2014
    32 r data_where 1999<=admit_year<=2014
     32r pop_where 1999<=year<=2015
     33r data_where 1999<=admit_year<=2015
    3334d sasstdpop morstd
    3435r pop_where stdyr=2000
     
    8687
    87883 null AgeGrpProxy null Age&Proxy num 10 4
    88 3 agegrp2_a AgeGrp2 agegrp4 Age num 0 8
     893 agegrp2_a AgeGrp2 agegrp2 Age num 0 8
    89903 agegrp4_a AgeGrp4 agegrp4 Age num 0 8
    90913 agegrp7_a AgeGrp7 agegrp7 Age num 0 8
     
    94953 agegrp18_a AgeGrp18 agegrp18 Age num 0 8
    95963 agegrp35_a AgeGrp35 agegrp35 Age num 0 8
    96 3 agework_a AgeWork null Age&Occupational num 0 8
     973 agework_a AgeWork agework Age&Occupational num 0 8
    9798
    98994 sex Sex Sex Sex num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/infmort/_InfMort14.cfg

    r12680 r13220  
    2020d saspop E:\ibisq\sasData\final\
    2121r sasdata death99_14ibis_std
    22 d saspopdata birth90_14ibis
     22d saspopdata birth90_15ibis
    2323d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2424#r sas_bin sas&-memsize&0
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/pcc/_pcc_co.cfg

    r12040 r13220  
    2424d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2525r sas_bin sas&-memsize&0
    26 r pop_where 2008<=year<=2015
    27 r data_where 2008<=year<=2015
     26r pop_where 2008<=year<=2016
     27r data_where 2008<=year<=2016
    2828r sasstdpop morstd
    2929####################################################################
     
    7979
    80802 null GeoProxy null GeographicAreaSpecified num 10 8
    81 2 fipscode GeoCnty fipscode ResidentialCounty num 0 8
     812 fips GeoCnty fipscode ResidentialCounty num 0 8
    82822 region GeoRegion region LocalHealthDistrict num 0 8
    8383 
     
    86863 agework AgeWork agework AgeatExposure num 0 8
    87873 agegrp4 AgeGrp4 agegrp4 AgeatExposure num 0 8
    88 3 agegrp13 AgeGrp13 agegrp13 AgeatExposure num 0 8
     88#3 agegrp13 AgeGrp13 agegrp13 AgeatExposure num 0 8
    89893 agegrp18 AgeGrp18 agegrp18 AgeatExposure num 0 8
    90903 agegrp35 AgeGrp35 agegrp35 AgeatExposure num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/acs/ACSPercent.def

    r11779 r13220  
    1111OPTION SPOOL;
    1212
     13        /*
    1314        proc setinit; run;
     15        */
    1416       
    1517        data tmp; set tmp;
     
    2022                percent stderr;
    2123                run;
     24        proc print data=tmp; title1 '===================='; title2 'tmp'; run;
    2225        proc summary data=poptmp;
    2326                var popcount;
  • adopters/nm/trunk/src/main/backend_qModules/acs/ACSPercentHH.def

    r11779 r13220  
    1111OPTION SPOOL;
    1212
     13        title1 '==========================';
    1314        data popnew;
    1415                set tmp;
     
    1617                ?cross2? %cross2%
    1718                run;
     19        proc print data=popnew; title2 'popnew'; run;
    1820        data tmp;
    1921                set tmp;
     
    2426                percent stderr;
    2527                run;
    26         proc summary data=popnew;
     28        proc print data=tmp; title2 'tmp'; run;
     29        proc summary data=popnew nway;
    2730                var TotHUnitEst;
    2831                class %cross1% %cross2% ;
    2932                output out=pop sum=popnum;
    3033                run;
     34        proc print data=pop; title2 'pop'; run;
    3135        proc sql;
    3236                create table rate as
     
    3741                ;
    3842                quit;
     43        proc print data=rate; title2 'rate'; run;
    3944        data tmp; set rate;
    4045                drop _TYPE_ _FREQ_ ;
     
    6772        run;
    6873       
    69         proc print data=tmp;
    70           title 'final tmp';
    71         run;
     74        proc print data=tmp; title2 'final tmp'; run;
    7275
    7376--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/birth23/_Birth15.cfg

    r12094 r13220  
    93934 bwtgrp InfBirthWt null InfantBirthWeight num 0 8
    94944 nobrn InfMultBirth null MultipleBirth num 0 8
     954 nobrn InfMultBirth2 null MultipleBirth num 0 8
    95964 bocat InfBirthOrder null BirthOrder num 0 8
    96974 gagegrp InfGestAgeGrp null GestationalAge num 0 8
  • adopters/nm/trunk/src/main/backend_qModules/birth23/_BirthSarea13.cfg

    r12094 r13220  
    1616d workpath E:\ibisq\workpath
    1717#############################################################################
    18 
    1918d saspath E:\ibisq\sasData\final
    2019d saspop E:\ibisq\sasData\final\
  • adopters/nm/trunk/src/main/backend_qModules/hidd/HIDD15.cfg

    r12680 r13220  
    55# Date        By         Description
    66# ----------  ---------  -------------------------------------------------
    7 # 12/15/2016  BrianW     updated HIDD data with modes for accomdating 2015 ICD-10_CMs 
     7# 12/15/20110  BrianW    updated HIDD data with modes for accomdating 2015 ICD-10_CMs 
    88# 10/17/2014  BrianW     updated HIDD data, dates and some notes 
    99# 04/10/2012  LoisH      pointed to new SAS version, added -memsize 0 system option
    1010# 8/31/2010   Brian      Refinements throughout query module based on reviews by DOH_Epis and friends
    11 # 6/9/2010    Brian      Multiple years, payer, status added and EPHT indicators modified
     11# 10/9/2010    Brian      Multiple years, payer, status added and EPHT indicators modified
    1212#                        to reflect primary versus secondary diagnosis detections
    1313# 4/7/2010    Brian      Add more EPHT indicators and Procedures, AHRQ CCS 231 and NCHS 55
     
    6363#        3 -- Groupable variable (Continuous, need regrouping by cgi,)
    6464#        4 -- Grouped variable (keep the name space)
    65 #        6 -- Multiple columns
     65#        10 -- Multiple columns
    6666#        7 -- Variable in standard population dataset
    6767#        8 -- Indicating variable (To be used with type2=3)
     
    91914 null DiagProxy null Diag&Proxy char 10 8
    92924 FLDMDC FLDMDC null First&Listed&Diagnosis&Categories num 0 8
     934 c21non NCHS21 null Diag&NCHS&21&Reasons num 0 8
     944 c50non NCHS50Non null Diag&NCHS&50 num 0 8
     954 c50inj NCHS50Inj null Injury&Diag&NCHS&50 num 0 8
     964 c113non NCHS113Non null Diag&NCHS&113 num 0 8
     974 c113inj NCHS113Inj null Injury&Diag&NCHS&113 num 0 8
    9398#4 MDC MDC null Major&Diagnostic&Categories num 0 8
    94 #4 c21non NCHS21 null Diag&NCHS&21&Reasons num 0 8
    9599#4 inj_cau Inj_cau null Injury&Diag&STIPDA&22&Causes num 0 8
    96100#4 intent InjIntent null Injury&Intent&--&STIPDA num 0 8
    97 #4 c50non NCHS50Non null Diag&NCHS&50 num 0 8
    98 #4 c50inj NCHS50Inj null Injury&Diag&NCHS&50 num 0 8
    99101#4 c50ae NCHS50AE null Diag&NCHS&50&AE num 0 8
    100 #4 c56non NCHS56 null Diag&NCHS&21&Reasons num 0 8
    101 #4 c113non NCHS113Non null Diag&NCHS&113 num 0 8
    102 #4 c113inj NCHS113Inj null Injury&Diag&NCHS&113 num 0 8
     102#4 c510non NCHS510 null Diag&NCHS&21&Reasons num 0 8
    103103#4 c113ae NCHS113AE null Diag&NCHS&113&AE num 0 8
    104104
    105 #4 null HealthIndicatorProxy null Health&Indicator&Proxy char 10 8
    106 #4 asthmadx ASTHMA null Asthma&Primary&Diagnosis num 0 8
    107 #4 CO CO null CO&All&Diagnosis num 0 8
    108 #4 MIdx MI null MI&Primary&Diagnosis&First&Occurence num 0 8
     1054 null HealthIndicatorProxy null Health&Indicator&Proxy char 10 8
     1064 asthmadx ASTHMA null Asthma&Primary&Diagnosis num 0 8
     1074 CO CO null CO&All&Diagnosis num 0 8
     1084 COPD COPD null Chronic&Pulmonary&Disease&Diagnosis num 0 8
     1094 Heatdx Heatdx null Heat&Related&Primary&Diagnosis num 0 8
     1104 MIdx MI null MI&Primary&Diagnosis&First&Occurence num 0 8
    109111#4 MI_Odx MI_Odx null MI&Primary&Diagnosis&Repeat num 0 8
    110 #4 CerebVdx CerebVdx null Cerebral&Vasular&Primary&Diagnosis num 0 8
    111 #4 CVdx CVdx null Cardio&Vascular&Primary&Diagnosis num 0 8
     1124 CerebVdx CerebVdx null Cerebral&Vasular&Primary&Diagnosis num 0 8
     1134 CVdx CVdx null Cardio&Vascular&Primary&Diagnosis num 0 8
     1144 Alz Alz null Alzheimer&Any&Diagnosis num 0 8
     1154 Par Par null Parkinson&Any&Diagnosis num 0 8
     1164 Hun Hun null Hunington&Any&Diagnosis num 0 8
     1174 ALS ALS null ALS&Any&Diagnosis num 0 8
     1184 MS MS null MS&Any&Diagnosis num 0 8
    112119#4 Resp Resp null Respiratory&Diseases&Primary&Diagnosis num 0 8
    113120#4 ChronResp ChronResp null Chronic&Respiratory&Primary&Diagnosis num 0 8
    114 #4 COPD COPD null Chronic&Pulmonary&Disease&Diagnosis num 0 8
    115121#4 Diabetes Diabetes null Diabetes&Primary&Diagnosis num 0 8
    116122#4 Nephdx Nephdx null Nephritis&Primary&Diagnosis num 0 8
    117123#4 Renal Renal null Renal&Primary&Diagnosis num 0 8
    118124#4 Kidney Kidney null Kidney&Primary&Diagnosis num 0 8
    119 #4 Heatdx Heatdx null Heat&Related&Primary&Diagnosis num 0 8
    120125#4 Electrolyte Electrolyte null Electrolyte&Primary&Diagnosis num 0 8
    121 #4 Alz Alz null Alzheimer&Any&Diagnosis num 0 8
    122 #4 Par Par null Parkinson&Any&Diagnosis num 0 8
    123 #4 Hun Hun null Hunington&Any&Diagnosis num 0 8
    124 #4 ALS ALS null ALS&Any&Diagnosis num 0 8
    125 #4 MS MS null MS&Any&Diagnosis num 0 8
    126126#4 Internal Internal null Internal&causes&Diagnoses num 0 8
    127127
     
    138138#4 Burns Burns null Burn&confined&to&eye&and&adnexa&Diagnosis num 0 8
    139139
    140 #5 null UserQProxy null Diag&Proxy char 10 8
    141 
    1421405 null UserQDXProxy null UserQDX&Proxy char 10 8
    1431415 PrimaryDiagnosis Diag9 null Diag&ICD-9&Codes char 3 8
    144 #5 UserCode Diag9 null Diag&ICD-9&Codes char 3 8
    145  
    146 6 null DiagA null Any&diagnosis&codes char 5 5 
    147 6 PrimaryDiagnosis DiagA null Primary&diagnosis&codes char 1 5
    148 6 Diagnosis2 DiagA null Secondary&diagnosis&codes&1 char 1 5 
    149 6 Diagnosis3 DiagA null Secondary&diagnosis&codes&2 char 1 5   
    150 6 Diagnosis4 DiagA null Secondary&diagnosis&codes&3 char 1 5 
    151 6 Diagnosis5 DiagA null Secondary&diagnosis&codes&4 char 1 5 
    152 6 Diagnosis6 DiagA null Secondary&diagnosis&codes&5 char 1 5 
    153 6 Diagnosis7 DiagA null Secondary&diagnosis&codes&6 char 1 5 
    154 6 Diagnosis8 DiagA null Secondary&diagnosis&codes&7 char 1 5 
    155 6 Diagnosis9 DiagA null Secondary&diagnosis&codes&8 char 1 5 
    156 
     142
     14310 null DiagA null Any&diagnosis&codes char 5 8
     14410 PrimaryDiagnosis DiagA null Primary&diagnosis&codes char 1 8
     14510 Diagnosis2 DiagA null Secondary&diagnosis&codes&2 char 1 8 
     14610 Diagnosis3 DiagA null Secondary&diagnosis&codes&3 char 1 8   
     14710 Diagnosis4 DiagA null Secondary&diagnosis&codes&4 char 1 8 
     14810 Diagnosis5 DiagA null Secondary&diagnosis&codes&5 char 1 8 
     14910 Diagnosis6 DiagA null Secondary&diagnosis&codes&10 char 1 8 
     15010 Diagnosis7 DiagA null Secondary&diagnosis&codes&7 char 1 8 
     15110 Diagnosis8 DiagA null Secondary&diagnosis&codes&8 char 1 8 
     15210 Diagnosis9 DiagA null Secondary&diagnosis&codes&9 char 1 8   
     15310 Diagnosis10 DiagA null Secondary&diagnosis&codes&10 char 1 8 
     15410 Diagnosis11 DiagA null Secondary&diagnosis&codes&11 char 1 8   
     15510 Diagnosis12 DiagA null Secondary&diagnosis&codes&12 char 1 8   
     15610 Diagnosis13 DiagA null Secondary&diagnosis&codes&13 char 1 8   
     15710 Diagnosis14 DiagA null Secondary&diagnosis&codes&14 char 1 8   
     15810 Diagnosis15 DiagA null Secondary&diagnosis&codes&15 char 1 8   
     15910 Diagnosis16 DiagA null Secondary&diagnosis&codes&110 char 1 8   
     16010 Diagnosis17 DiagA null Secondary&diagnosis&codes&17 char 1 8   
     16110 Diagnosis18 DiagA null Secondary&diagnosis&codes&18 char 1 8 
     162
     1637 null UserQDXProxy null UserQDX&Proxy char 10 8
     1647 PrimaryDiagnosis Diag10 null Diag&ICD-9&Codes char 3 8
     165
     1668 null DiagA10 null Any&diagnosis&codes char 5 8
     1678 PrimaryDiagnosis DiagA10 null Primary&diagnosis&codes char 1 8
     1688 Diagnosis2 DiagA10 null Secondary&diagnosis&codes&2 char 1 8 
     1698 Diagnosis3 DiagA10 null Secondary&diagnosis&codes&3 char 1 8   
     1708 Diagnosis4 DiagA10 null Secondary&diagnosis&codes&4 char 1 8 
     1718 Diagnosis5 DiagA10 null Secondary&diagnosis&codes&5 char 1 8 
     1728 Diagnosis8 DiagA10 null Secondary&diagnosis&codes&8 char 1 8 
     1738 Diagnosis7 DiagA10 null Secondary&diagnosis&codes&7 char 1 8 
     1748 Diagnosis8 DiagA10 null Secondary&diagnosis&codes&8 char 1 8 
     1758 Diagnosis9 DiagA10 null Secondary&diagnosis&codes&9 char 1 8   
     1768 Diagnosis10 DiagA10 null Secondary&diagnosis&codes&10 char 1 8 
     1778 Diagnosis11 DiagA10 null Secondary&diagnosis&codes&11 char 1 8   
     1788 Diagnosis12 DiagA10 null Secondary&diagnosis&codes&12 char 1 8   
     1798 Diagnosis13 DiagA10 null Secondary&diagnosis&codes&13 char 1 8   
     1808 Diagnosis14 DiagA10 null Secondary&diagnosis&codes&14 char 1 8   
     1818 Diagnosis15 DiagA10 null Secondary&diagnosis&codes&15 char 1 8   
     1828 Diagnosis18 DiagA10 null Secondary&diagnosis&codes&18 char 1 8   
     1838 Diagnosis17 DiagA10 null Secondary&diagnosis&codes&17 char 1 8   
     1848 Diagnosis18 DiagA10 null Secondary&diagnosis&codes&18 char 1 8 
    157185
    158186#5 null UserQEProxy null UserQE&Proxy char 10 8
     
    1681965 UserProc Proc9 null Proc&ICD-9&Codes char 3 8
    169197
    170 6 null GeoProxy null ProxyVar num 10 4
    171 6 fip GeoCnty fipscode NM&Counties num 0 8
    172 6 HealthRegion GeoRegion region NMRegion num 0 8
    173 #6 fipscode GeoCnty fipscode CntyFIPS num 0 8
    174 
    175 7 stdyr stdpop null Standard&Population num 7 8
    176 
    177 8 PriPayer PriPayer null Primary&Payer&Category num 0 8
    178 
    179 9 Status Status null Patient&Discharge&Status num 0 8
    180 
    181 10 licensetypeid LicenseType null Primary&Payer&Category num 0 8
    182 
    183 
    184 #5 raceth RacEth DOHraceth NMRacEth num 0 8
     19810 null GeoProxy null ProxyVar num 10 4
     19910 fip GeoCnty fipscode NM&Counties num 0 8
     20010 HealthRegion GeoRegion region NMRegion num 0 8
     201#10 fipscode GeoCnty fipscode CntyFIPS num 0 8
     202
     20311 stdyr stdpop null Standard&Population num 7 8
     204
     20512 PriPayer PriPayer null Primary&Payer&Category num 0 8
     206
     20713 Status Status null Patient&Discharge&Status num 0 8
     208
     20914 licensetypeid LicenseType null Primary&Payer&Category num 0 8
     210
     211#15 raceth RacEth DOHraceth NMRacEth num 0 8
    185212# The popcount variable is only referenced in the .DEF files ====================
    186213
  • adopters/nm/trunk/src/main/backend_qModules/pcc/pcc_co.cfg

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

    r12040 r13220  
    11# This CFG file uses the new dataset, but points to the older version of the
    22# race/ethnicity variable.
    3 #==============================================================================
     3#===========================================================================
    44# IBIS-Q Configuration File
    55
     
    1313# 12/15/2011  Lois      Mod for new Intercensal dataset
    1414# 09/14/2010  Lois      No modification needed for 2009 data
    15 # 06/08/2010  Lois      Added agegrp4ML
    16 # 03/12/2010  Lois      Added 2008, plus preliminary 2009, 2010 (equal to 2008)
    17 # 05/04/2009  Lois      Added 2007, changed year dimension to Year90_, added BEBR revised data, 4/24/09
    18 # 03/18/2009  Lois      Added 90-99 pop years, changed pop dimension for 00_06
    19 # 02/11/2008  Lois      Initial New Mexico version, adapted from UT.
    20 #==============================================================================
     15#===========================================================================
    2116
    2217#value name_path value_path   
     
    4439r sas 0
    4540r test 0
    46 #############################################################################
     41############################################################################
    4742#value name_sas name_html name_pop prompt type1 type2 length   
    48 #============================================================================
     43#===========================================================================
    4944#value =any value, place holder only
    50 # name_sas  = SAS variable name in the numerator data set (birth data set)
    51 # name_html = html name that specified under <DIMENSION> <NAME> in Module XML file
    52 # name_pop  = SAS variable name in denominator data set (population data set)
     45# name_sas  = SAS var name in the numerator data set (birth data set)
     46# name_html = <DIMENSION> <NAME> in dimension.xml file
     47# name_pop  = SAS var name in denominator data set (population data set)
    5348# prompt    = Place holder only, could by any character string.
    54 # type1     = CGI data type for SAS variable type (see comment lines 48 & 49)
    55 # type2     = CGI data type for CGI regrouping purpose (see comment lines 51-59)
    56 # length    = used to indicate the variable length in SAS dataset
     49# type1     = see comment lines below
     50# type1     = see comment lines below
     51# length    = the variable length (bytes) in SAS dataset
    5752#
    5853# type1= num -- SAS data type is numeric
     
    6863#        9 -- Disable variable (To avoid conflict)
    6964#       10 –  Proxy variable
    70 #============================================================================
     65#==========================================================================
    7166#value name_sas name_html name_pop prompt type1 type2 length
    7267
     
    93888 region GeoRegion null NMRegion num 0 8
    9489
    95 # The popcount variable is only referenced in the .DEF files ====================
     90# The popcount variable is only referenced in the .DEF files ==============
    9691
    9792
  • adopters/nm/trunk/src/main/backend_qModules/pop/_PopTract15.cfg

    r12040 r13220  
    1111# 07/01/2013  Lois      Using new race coding for dohraceth
    1212# 08/21/2012  Lois      Added 2011 county data
    13 # 12/15/2011  Lois      Mod for new Intercensal dataset
    14 # 09/14/2010  Lois      No modification needed for 2009 data
    15 # 06/08/2010  Lois      Added agegrp4ML
    16 # 03/12/2010  Lois      Added 2008, plus preliminary 2009, 2010 (equal to 2008)
    17 # 05/04/2009  Lois      Added 2007, changed year dimension to Year90_, added BEBR revised data, 4/24/09
    18 # 03/18/2009  Lois      Added 90-99 pop years, changed pop dimension for 00_06
    19 # 02/11/2008  Lois      Initial New Mexico version, adapted from UT.
    2013#==============================================================================
    2114
     
    94879 urbanrur GeoUrbanRur null UrbanRuralCounties num 0 8
    9588
    96 # The popcount variable is only referenced in the .DEF files ====================
     89# The popcount variable is only referenced in the .DEF files ==============
    9790
    9891
  • adopters/nm/trunk/src/main/backend_qModules/trauma/NM_Count_data_frame.def

    r11779 r13220  
    105105                        output out=pop sum=popcount;
    106106                run;
    107                 proc sql;
    108                         create table rate as
    109                         select tmp.*, pop.*
    110                         from tmp, pop
    111                         where
    112                         ?popcross1? tmp.%cross1%=pop.%popcross1%;
    113                         ?popcross2? tmp.%cross2%=pop.%popcross2%; 
    114                 quit;
     107                data pop;
     108                        set pop;
     109                        rename
     110                        ?popcross1? %popcross1%=%cross1%
     111                        ?popcross2? %popcross2%=%cross2%
     112                        ;
     113                        drop _TYPE_ _FREQ_ ;
     114                        run;
     115                proc sort data=pop;
     116                        ?popcross1? by %cross1%;
     117                        ?popcross2? by %cross2%;
     118                run;
     119                proc sort data=tmp;
     120                        ?popcross1? by %cross1%;
     121                        ?popcross2? by %cross2%;
     122                run;
     123                proc print data=pop noobs; title2 '3. POP - pop dataset'; run;
     124                data rate;
     125                        merge tmp pop;
     126                        ?popcross1? by %cross1%;
     127                        ?popcross2? by %cross2%;
     128                run;
    115129        %end;
    116130
     
    121135                        output out=pop sum=popcount;
    122136                run;
    123                 proc sql;
    124                         create table rate as
    125                         select tmp.*, pop.*
    126                         from tmp, pop
    127                         where tmp.%cross1%=pop.%popcross1% and
    128                         tmp.%cross2%=pop.%popcross2%;
    129                 quit;
     137                data pop;
     138                        set pop;
     139                        rename %popcross1%=%cross1%  %popcross2%=%cross2% ;
     140                        run;
     141                proc sort data=pop;
     142                        by %cross1% %cross2%;
     143                run;
     144                proc sort data=tmp;
     145                        by %cross1% %cross2%;
     146                run;
     147                data rate;
     148                        merge tmp pop;
     149                        by %cross1% %cross2%
     150                        ;
     151                run;
    130152        %end;
    131153        %mend;
    132154        %popcross;
    133 
     155        proc print data=rate noobs;  title2 '6. RATE - tmp merged with pop dataset'; run;
     156       
    134157 ********************** 4. tmp, again ****************************;
    135158 * Create the output variables for the IBIS xml/map file.         ;
     
    186209                if ((0<n<4) and (popcount<5000)) then do;
    187210                        n = .A;
    188                         rateper = .A;
    189                         LL = put('**', 8.0);
    190                         UL = put('**', 8.0);
    191211                end;
    192212        proc print data=tmp noobs;  title2 '6. TMP - final dataset to pass to IBIS View app';
  • adopters/nm/trunk/src/main/backend_qModules/trauma/_Trauma13.cfg

    r12040 r13220  
    1414d saspath E:\ibisq\sasData\final\
    1515d saspop E:\ibisq\sasData\final\
    16 r sasdata trauma05_13
     16r sasdata trauma05_15
    1717d saspopdata popibiscnty90_15_11oct2016
    1818d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
     
    6060#Value SAS_Numerator_Var Dimension SAS_Denominator_Var Label type1 type2 length
    6161       
     621 year Year year YearofEDEncounter num 0 8
     631 month Month null MonthofEDEncounter num 0 8
     64
    62653 null AgeGrpProxy null Age&Group num 10 8
    63663 agegrp2 AgeGrp2 agegrp2 Age&at&Death num 0 8
     
    71743 agegrp19 AgeGrp19 agegrp19 Age&at&Death num 0 8
    72753 agegrp35 AgeGrp35 agegrp35 Age&at&Death num 0 8
    73          
     76
    74774 null InjMechProxy null null num 10 8
    75 4 mechanism Mechanism null null num 0 8
     784 injcaus InjCause null null num 0 8
     792 intent InjIntent null InjuryIntention num 0 8
     80
     816 pripayer PriPayer null num 0 8
    7682
    77834 sex Sex sex Sex num 0 8
    7884
    79 6 null GeoProxy null null num 10 8
    80 6 fipscode GeoCnty fipscode Residential&County num 0 8
    81 6 pripayer PriPayer null num 0 8
     855 DOHRaceth RacEth DOHRaceth Race num 0 8
     86
     876 null GeoProxy null GeographicAreaSpecified num 10 8
     886 fipscode GeoCnty fipscode ResidentialCounty num 0 8
     896 region GeoRegion region LocalHealthDistrict num 0 8
     906 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
     917 NMRes NMRes null NM&Resident&Births num 0 8
    8292
    8393#~~~~~~~~~~~~~~~~~~~ END OF CFG FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • adopters/nm/trunk/src/main/backend_qModules/tribal/mort/_TribalMort13.cfg

    r12680 r13220  
    1818d saspop E:\ibisq\sasData\final
    1919r sasdata tribalmortardi99_13
    20 d saspopdata poptribal2010census08_13
     20d saspopdata poptribal2010census07_13
    2121d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2222#r sas_bin sas&-memsize&0
    2323r pop_where 2007<=year<=2013
    24 r data_where 2007<=year<=2013
     24r data_where 2007<=year<=2013&and&1<=TribalArea<=26
    2525r sasstdpop morstd
    2626####################################################################
Note: See TracChangeset for help on using the changeset viewer.