Changeset 20952 in main


Ignore:
Timestamp:
07/05/20 14:02:03 (4 weeks ago)
Author:
LoisHaggard_NM
Message:

nm backend qModules 3.0 birth

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/birth
Files:
7 edited

Legend:

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

    r20663 r20952  
    126126                        select tmp.*, pop.*
    127127                        from tmp left join pop
    128                         on tmp.%cross1%=pop.%popcross1% and
     128                        on
     129                        tmp.%cross1%=pop.%popcross1% and
    129130                        tmp.%cross2%=pop.%popcross2%;
    130131                quit;
     
    188189        data tmp;
    189190                set tmp;
    190                 if ((0<n<4) and (popcount<5000)) then do;
     191                if ((0<n<4) and (.<popcount<5000)) then do;
    191192                        n = .A;
    192193
    193                 *Only one value attribute is allowed - so if suppressed, overwrite unstable;
    194                 *This also puts ** in record code column for suppressed rows, and adds footnote;
     194                        *Only one value attribute is allowed - so if suppressed, overwrite unstable;
     195                        *This also puts ** in record code column for suppressed rows, and adds footnote;
    195196                        redflag = put('Suppressed', $12.);
    196197                end;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/NM_PctDesirableLow_5YrAvg.def

    r20663 r20952  
    186186        data numbers;
    187187                set numbers;
    188                 run;   
     188                run;
    189189        proc print data=numbers noobs;
    190190                title2 '4. NUMBERS dataset with lag variables replacing count and totalnum';
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/NM_Rate1K.def

    r20663 r20952  
    1313OPTIONS MPRINT MLOGIC SYMBOLGEN NONUMBER NODATE PAGESIZE=4000;
    1414OPTION SPOOL;
     15
     16        *this is to get the value of the last year for the YearGrp3Yrs dimension value.;
     17        proc freq data=tmp noprint; tables year / list out=years; run;
     18        proc print data=years; run;
     19        data lastyear; set years; by year; if first.year then YearGrp3Yrs=year; keep YearGrp3Yrs; run;
     20        proc print data=lastyear; run;
    1521
    1622 ************************** 1. TMP ******************************;
     
    127133                        select tmp.*, pop.*
    128134                        from tmp left join pop
    129                         on tmp.%cross1%=pop.%popcross1% and
     135                        on
     136                        tmp.%cross1%=pop.%popcross1% and
    130137                        tmp.%cross2%=pop.%popcross2%;
    131138                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/NM_RateBirth1KGirls.def

    r20663 r20952  
    127127                        select tmp.*, pop.*
    128128                        from tmp left join pop
    129                         on tmp.%cross1%=pop.%popcross1% and
     129                        on
     130                        tmp.%cross1%=pop.%popcross1% and
    130131                        tmp.%cross2%=pop.%popcross2%;
    131132                quit;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/NM_RateBirth1KGirls_5YrAvg.def

    r20663 r20952  
    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%;
    113                         ?popcross2? tmp.%cross2%=pop.%popcross2%;  
     113                        ?popcross2? tmp.%cross2%=pop.%popcross2%;
    114114                quit;
    115115        %end;
     
    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;
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/_Birth18.cfg

    r20797 r20952  
    82822 year YearRangeAll year Year num 0 8
    83832 year YearSDH year Year num 0 8
    84 2 year YearAMCHP year Year num 0 8
    85842 year Year9 year Year num 3 8
    8685## MOTHER CHARACTERISTICS #######################   
  • adopters/nm/trunk/src/main/backend_qModules/3.0/birth/_BirthLegis17.cfg

    r20797 r20952  
    75751 null YearProxy year Year num 10 8
    76762 year Year year Year num 0 8
    77 #YearGrp3Yrs and YearGrp5Yrs for moving year aggregates
    78 #YearGrp3 and YearGrp5 and YearRangeAll for Sarea year aggregates
    79 1 year YearGrp5Yrs year YearofDeath num 0 8
    80 1 year YearGrp5Legis year Year num 3 8
    81 2 year YearRangeAll year Year num 0 8
     771 year YearGrp5 year Year num 3 8
    82782 year Year9 year Year num 3 8
    8379## MOTHER CHARACTERISTICS #######################   
    84801 null AgeGrpProxy null AgeGroup num 10 8
    85813 mage Mage null MothersAge num 1 8
    86 3 magegrp MomAgeGrp magegrp MothersAge num 0 8
    87 3 magegrp2 MomAgeGrp2 magegrp2 MothersAge num 0 8
     823 magegrp AgeGrp10MomAge magegrp MothersAge num 0 8
     833 magegrp2 AgeGrp6MomAge magegrp2 MothersAge num 0 8
    88843 medugrp Edu1 null MothersEducation num 0 8
    89853 fedugrp FatherEdu null FathersEducation num 0 8
Note: See TracChangeset for help on using the changeset viewer.