Changeset 13265 in main


Ignore:
Timestamp:
02/28/17 16:56:18 (5 years ago)
Author:
Lois Haggard
Message:

nm backend qModules update ACS and pop density

Location:
adopters/nm/trunk/src/main/backend_qModules
Files:
4 added
7 deleted
12 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules

    • Property svn:ignore
      •  

        old new  
        22deleted
        33ken
         4paul
  • adopters/nm/trunk/src/main/backend_qModules/_EPHT/cancer

    • Property svn:ignore set to
      old
  • adopters/nm/trunk/src/main/backend_qModules/acs/ACSAverage.def

    r11779 r13265  
    2020                average stderr count popnum;
    2121                run;
     22        proc print data=tmp; title1 '===================='; title2 'tmp'; run;
    2223               
    2324        data tmp; set tmp;
  • adopters/nm/trunk/src/main/backend_qModules/acs/ACSPercent.def

    r13220 r13265  
    2828                output out=pop sum=popnum;
    2929                run;
     30        data pop; set pop; format %cross1% 11.0; if %cross1%=. then %cross1%=35000;
     31        proc print data=pop; title2 'pop'; run;
    3032        proc sql;
    3133                create table rate as
  • adopters/nm/trunk/src/main/backend_qModules/acs/ACSPercentNoPopEst.def

    r11779 r13265  
    1111OPTION SPOOL;
    1212
    13         proc setinit; run;
     13        *proc setinit;
    1414       
    1515        data tmp; set tmp;
     
    2020                percent stderr;
    2121                run;
     22        proc print data=tmp; title2 'tmp'; run;
    2223        proc summary data=poptmp;
    2324                var popcount;
     
    2526                output out=pop sum=popnum;
    2627                run;
     28        data pop; set pop; format %cross1% 11.0; if %cross1%=. then %cross1%=35000;
     29        proc print data=pop; title2 'pop'; run;
    2730        proc sql;
    2831                create table rate as
  • adopters/nm/trunk/src/main/backend_qModules/acs/_ACSCnty15.cfg

    r12680 r13265  
    1717d saspopdata popibiscnty90_15_11oct2016
    1818d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    19 d data_where 1<=fipscode<=61
     19d data_where 1<=fipscode<=35000
    2020d pop_where 2009<=year<=2013
    2121d sascdata temp
  • adopters/nm/trunk/src/main/backend_qModules/acs/_ACSSarea15.cfg

    r12680 r13265  
    1717d saspopdata popibissarea90_15_11oct2016
    1818d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    19 d data_where sarea134&ne&.
     19d data_where 1<=sarea134<=109&or&sarea134=35000
    2020d pop_where 2009<=year<=2013
    2121d sascdata temp
  • adopters/nm/trunk/src/main/backend_qModules/pop/Density.def

    r11649 r13265  
    33#########################################
    44--------BoNdArY--------
    5 1 script
     51 script
     6OPTIONS MPRINT MLOGIC SYMBOLGEN NONUMBER NODATE PAGESIZE=4000;
     7OPTION SPOOL;
    68
    7 proc summary data=tmp;
    8  var popcount area;
    9  class %cross1%
    10 ?cross2? %cross2%
    11 ;
    12  output out=tmp sum(popcount)=count sum(Area)=area;
    13  run;
    14 proc print data=tmp;
    15 run;
     9 ************************** 1. TMP ******************************;
     10 * The dataset 'tmp' is the numerator dataset that has been read ;
     11 * in already by ibis-q. Any filters have already been applied.  ;
     12 * The proc summary counts deaths by cross1 and cross2.          ;
     13 ****************************************************************;
     14        proc summary data=tmp;
     15                var popcount;
     16                class %cross1%;
     17                output out=tmp sum=count;
     18        proc sort data=tmp; by %cross1%;
     19                run;
     20        proc print data=tmp noobs;
     21                title1 '---------------------------------';
     22                title2 '1. TMP - numerator dataset';
     23                run;
    1624
    17 data tmp;
    18         set tmp;
    19         density=count/area;
    20         n=count;
     25************************** 2. POPTMP ******************************;
     26        proc summary data=pop.landarea;
     27                var LandArea;
     28                class %cross1%;
     29                output out=pop sum=area;
    2130        run;
     31        proc sql;
     32                create table rate as
     33                select tmp.*, pop.*
     34                from tmp, pop
     35                where
     36                tmp.%cross1%=pop.%cross1%;
     37        quit;
     38
     39************************** 3. FINALTMP ******************************;
     40
     41        data tmp;
     42                set rate;
     43                density=count/area;
     44                n=count;
     45                run;
     46
    2247--------BoNdArY--------
    2348f out_variable count
    2449#################################################
    2550# definition for output file
    26 f xml_out_map_file XMLCountAreaDensity.map
     51f xml_out_map_file XMLDensityCountArea.map
    2752--------BoNdArY--------
    2853f out_detail lbl_not_used__see_xml_out_map_file
  • adopters/nm/trunk/src/main/backend_qModules/pop/_PopCnty15.cfg

    r12040 r13265  
    1010# 09/17/2013  Lois      Added 2012 gps data
    1111# 07/01/2013  Lois      Using new race coding for dohraceth
    12 # 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
    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.
    2012#==============================================================================
    2113
     
    2719d saspop E:\ibisq\sasData\final\
    2820d sasdata popibiscnty90_15_11oct2016
    29 d saspopdata none
     21d saspopdata landarea
    3022d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    3123d sasstdpop morstd
     
    9284
    93856 null GeoProxy null ProxyVar num 10 4
    94 7 fipscode GeoCnty null CntyFIPS num 0 8
    95 8 region GeoRegion null NMRegion num 0 8
    96 9 urbanrur GeoUrbanRur null UrbanRuralCounties num 0 8
     867 fipscode GeoCnty fipscode CntyFIPS num 0 8
     878 region GeoRegion region NMRegion num 0 8
     889 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8
    9789
    9890#~~~~~~~~~~~~~~~~~~~ END OF CFG FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  • adopters/nm/trunk/src/main/backend_qModules/pop/_PopSarea15.cfg

    r13220 r13265  
    2222#d saspop E:\ibisq\sasData\final\
    2323d sasdata popibissarea90_15_11oct2016
    24 d saspopdata none
     24d saspopdata landarea
    2525d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2626d sasstdpop morstd
  • adopters/nm/trunk/src/main/backend_qModules/pop/_PopTract15.cfg

    r13220 r13265  
    2020#d saspop E:\ibisq\sasData\final\
    2121d sasdata popibistrct90_15_11oct2016
    22 d saspopdata none
     22d saspopdata landarea
    2323d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2424d sasstdpop morstd
  • adopters/nm/trunk/src/main/backend_qModules/tribal

    • Property svn:ignore set to
      _NotUsed
Note: See TracChangeset for help on using the changeset viewer.