Changeset 21775 in main


Ignore:
Timestamp:
10/13/20 13:10:40 (2 weeks ago)
Author:
LoisHaggard_NM
Message:

NMBIS Backend QModules

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0
Files:
3 deleted
9 edited

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/CrudeRateNM_AnnZERO.def

    r19939 r21775  
    139139  if number=. then n=0; else n=number;
    140140  rate=n/popnum;
    141   rateper=rate*100;
     141  PctPersons=rate*100;
    142142  stderr=sqrt(rate*(1-rate)/popnum)*100;
    143143  if n=0 then stderr=sqrt((3/popnum)*(1-(3/popnum))/popnum)*100;
    144   t1=(rateper-(1.96*stderr));
     144  t1=(PctPersons-(1.96*stderr));
    145145  if (t1<0) then t1=0;
    146146  LL=put(t1, 8.2);
    147   UL=put((rateper+(1.96*stderr)), 8.2);
     147  UL=put((PctPersons+(1.96*stderr)), 8.2);
    148148  LL=compress(LL);
    149149  UL=compress(UL);
     
    159159/*************************************************/
    160160
    161   rse=(stderr/rateper);
    162   if rse>.3 then redflag=1; *statistical stability – 1 red flag;
    163   if rse>.5 then redflag=2; *statistical stability - 2 red flags;
    164   if stderr=. then redflag=2; *no variance, n=1;
    165 keep %cross1% %cross2% n popnum rate rateper LL UL rse redflag;
     161        if n>0 then do;
     162                rse=(stderr/PctPersons);
     163                redflag=put('', $12.);
     164                if rse>.3 then redflag=put('Unstable', $12.);
     165                if rse>.5 then redflag=put('VeryUnstable', $12.);
     166                if stderr=. then redflag=put('Unstable', $12.);
     167        end;
     168        if n<=0 then redflag=put('Unstable', $12.);
     169
     170keep %cross1% %cross2% n popnum rate PctPersons LL UL rse redflag;
    166171proc print data=tmp; title2 'TMP AGAIN';
    167172run;
     
    176181/*********************************************
    177182
     183
    178184data tmp;
    179   set tmp;
    180   if ((0<n<4) and (1<=popnum<5000)) then do;
    181   n = .A;
    182   rate = .A;
    183 end;
     185        set tmp;
     186        if ((0<n<4) and (.<popcount<5000)) then do;
     187                rateper = .A;
     188                n = .A;
     189                popcount = .A;
     190                LL = put('**', 8.0);
     191                UL = put('**', 8.0);
     192                redflag = put('Suppressed', $12.);
     193        end;
     194if popcount=. then redflag=put('', $12.);
     195
     196
    184197*/
    185198proc print data=tmp; title2 'FINAL'; run;
     
    188201
    189202--------BoNdArY--------
    190 f out_variable rateper
     203f out_variable PctPersons
    191204# definition for output file
    192205f xml_out_map_file XMLRateNumerDenomLCLUCL.map
     
    196209--------BoNdArY--------
    197210f out_detail lbl_not_used__see_xml_out_map_file
    198   rateper 15.3
     211  PctPersons 15.3
    199212  n 15.0
    200213  popnum 15.0
     
    2062191 suppressed_variables 2
    207220n
    208 rateper
    209 --------BoNdArY--------
     221PctPersons
     222--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/XMLCount.map

    r19939 r21775  
    1 1 Count VALUE
    2 2 Count RELIABILITY_FLAG
     11 MEASURE Count
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/XMLRateNumerDenomLCLUCL.map

    r19939 r21775  
    1 1 Rate VALUE
    2 2 Rate NUMERATOR
    3 3 Rate DENOMINATOR
    4 4 Rate LOWER_CONFIDENCE_LIMIT
    5 5 Rate UPPER_CONFIDENCE_LIMIT
    6 6 Rate RELIABILITY_FLAG
     11 MEASURE PctPersons
     22 ANCILLARY_VALUE Numerator
     33 ANCILLARY_VALUE Denominator
     44 ANCILLARY_VALUE LowerConfidenceLimit
     55 ANCILLARY_VALUE UpperConfidenceLimit
     66 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/_EPHT/childlead/_childlead6in1.cfg

    r21581 r21775  
    2020r data_where 2009<=t_year<=2019
    2121d saspopdata popibiscnty90_18_28jun2019
    22 r pop_where 2009<=year<=2018&and&AGEGRP35<7
     22r pop_where 2009<=year<=2019&and&AGEGRP35<7
    2323d sasstdpop morstd
    2424r pop_where stdyr=2000
  • adopters/nm/trunk/src/main/backend_qModules/3.0/yrrs/SurveyCrudeRateCNTY.def

    r19939 r21775  
    1818#################################################
    1919# definition for output file
    20 f xml_out_map_file XMLPercentNumerDenomLCLUCL.map
     20f xml_out_map_file XMLPct.map
    2121--------BoNdArY--------
    2222f out_detail lbl_not_used__see_xml_out_map_file 
  • adopters/nm/trunk/src/main/backend_qModules/3.0/yrrs/SurveyCrudeRateCNTY.sas

    r19939 r21775  
    289289        set tmp6;
    290290
    291         if 0<percent<.50 then RSE=(StdErr/percent);
    292         if .50<=percent<1 then RSE=(StdErr/(1-percent));
    293 
    294         redflag=put('-', $14.);
    295         if rse>.3 then redflag=put('Unstable', $14.);
    296         if rse>.5 then redflag=put('Very Unstable', $14.);
    297         if denom=1 then redflag=put('Unstable', $14.);
     291        if 0<mean<.50 then RSE=(StdErr/mean);
     292        if .50<=mean<1 then RSE=(StdErr/(1-mean));
     293
     294        redflag=put('', $16.);
     295        if rse>.3 then redflag=put('Unstable', $16.);
     296        if rse>.5 then redflag=put('VeryUnstable', $16.);
     297        if SampleN=1 then redflag=put('Unstable', $16.);
    298298
    299299        if (%cross1%=-1) then %cross1%=.;
     
    325325                n = .A;
    326326                denom = .A;
    327                 redflag=put('Not Reportable', $14.);
     327                redflag=put('SurveySuppressed', $14.);
    328328        end;
    329329        proc print data=tmp noobs; title3 'final tmp: Convert values for cell suppression';
  • adopters/nm/trunk/src/main/backend_qModules/3.0/yrrs/SurveyCrudeRateSTWIDE.def

    r19939 r21775  
    1818#################################################
    1919# definition for output file
    20 f xml_out_map_file XMLPercentNumerDenomLCLUCL.map
     20f xml_out_map_file XMLPct.map
    2121--------BoNdArY--------
    2222f out_detail lbl_not_used__see_xml_out_map_file 
  • adopters/nm/trunk/src/main/backend_qModules/3.0/yrrs/SurveyCrudeRateSTWIDE.sas

    r19939 r21775  
    283283        set tmp6;
    284284
    285         if 0<percent<.50 then RSE=(StdErr/percent);
    286         if .50<=percent<1 then RSE=(StdErr/(1-percent));
    287 
    288         redflag=put('-', $14.);
    289         if rse>.3 then redflag=put('Unstable', $14.);
    290         if rse>.5 then redflag=put('Very Unstable', $14.);
    291         if denom=1 then redflag=put('Unstable', $14.);
     285        if 0<mean<.50 then RSE=(StdErr/mean);
     286        if .50<=mean<1 then RSE=(StdErr/(1-mean));
     287
     288        redflag=put('', $16.);
     289        if rse>.3 then redflag=put('Unstable', $16.);
     290        if rse>.5 then redflag=put('VeryUnstable', $16.);
     291        if SampleN=1 then redflag=put('Unstable', $16.);
    292292
    293293        if (%cross1%=-1) then %cross1%=.;
     
    319319                n = .A;
    320320                denom = .A;
    321                 redflag=put('Not Reportable', $14.);
     321                redflag=put('SurveySuppressed', $14.);
    322322        end;
    323323        proc print data=tmp noobs; title3 'final tmp: Convert values for cell suppression';
  • adopters/nm/trunk/src/main/backend_qModules/3.0/yrrs/_YRRS17.cfg

    r20049 r21775  
    1010
    1111#value name_path value_path   
    12 d homepath E:\ibisq\qModules30\yrrs23
     12d homepath E:\ibisq\qModules30\yrrs
    1313d workpath E:\ibisq\workpath\
    1414####################################################################
     
    5656#value name_sas name_html name_pop prompt type1 type2   
    5757#0 null FocusLevel null FocusLevel num 0 8
    58 # ******** crossvars ********   
     58# ******** crossvars ********
    59591 year Year null Year num 0 8
    60601 sex SurvDemoSex null Sex num 0 8
     
    66661 homeless SurvDemoHomeless null UnstableHousHomeless num 0 8
    67671 foreign SurvDemoFrgnBrn null BornOutsideUSA num 0 8
    68 # ******** crossvars GEO ********   
     68# ******** crossvars GEO ********
    69693 null GeoProxy null GeoProxy num 10 8
    70703 cnty GeoCnty null County num 0 8
     
    72723 urbanrur GeoUrbanRur null UrbanRuralCounties num 0 8
    73733 cdc Statewide null StatewideNM num 0 8
    74 # ******** crossvars RESILIENCY ********   
     74# ******** crossvars RESILIENCY ********
    75755 null ResiliencyProxy null ResiliencyProxy num 10 8
    76765 grades ResGrades null SchoolGrades num 0 8
     
    88885 peercare ResPeerCare null FriendReallyCaresAboutMe num 0 8
    89895 college ResCollege null ContinueMyEducationAfterHighSchool num 0 8
    90 # ******** Indicators RESILIENCY ********   
     90# ******** Indicators RESILIENCY ********
    919111 grades2 ResGrades2 null SchoolGrades num 0 8
    929211 prsclwk2 ResPrSclWk2 null ParentBelievesIllBeASuccess num 0 8
     
    10310311 peercare2 ResPeerCare2 null FriendReallyCaresAboutMe num 0 8
    10410411 college2 ResCollege2 null ContinueMyEducationAfterHighSchool num 0 8
    105 # ******** Indicators ALCOHOL ********   
     105# ******** Indicators ALCOHOL ********
    10610613 drnk30 AlcDrnk30 null CurrentDrinking num 0 8
    10710713 binge AlcBinge null BingeDrinking num 0 8
    10810813 drnk13 AlcDrnk13 null FirstDrankAlcoholBeforeAge13 num 0 8
    10910913 drnkscl AlcDrnkScl null DrankAlcoholOnSchoolProperty num 0 8
    110 # ******** Indicators DRUGS ********   
     110# ******** Indicators DRUGS ********
    11111115 mari30 DrugMari30 null CurrentMarijuanaUse num 0 8
    11211215 mari13 DrugMari13 null FirstUsedMarijuanaBeforeAge13 num 0 8
     
    12512515 injlife DrugInjLife null EverInjectedIllegalDrugs num 0 8
    12612615 drgscl DrugDrgScl null OfferedDrugsOnSchoolProperty num 0 8
    127 # ******** Indicators TOBACCO ********   
     127# ******** Indicators TOBACCO ********
    12812817 cigevr TobCigEvr null EverTriedCigaretteSmoking num 0 8
    12912917 cig13 TobCig13 null FirstSmokedCigarettesBeforeAge13 num 0 8
     
    14214217 vape30 TobVape30 null CurrentVapeUse num 0 8
    14314317 envsmoke TobEnvSmoke null InRoomSmoker7Days num 0 8
    144 # ******** Indicators NUTRITION ********   
     144# ******** Indicators NUTRITION ********
    14514521 fiveaday NutrFiveaDay null FiveOrMoreServingsFruitOrVegPerDay num 0 8
    14614621 soda1 SodaDaily null DailySodaConsumption num 0 8
    14714721 qnbk7day NutrBrkfstWeekYes null DailySodaConsumption num 0 8
    14814821 nobk NutrBrkfstWeekNo null DailySodaConsumption num 0 8
    149 # ******** Indicators PHYS ACTIVITY ********   
     149# ******** Indicators PHYS ACTIVITY ********
    15015023 pa7 PhysPA7 null PhysicallyActive7DaysPerWeek num 0 8
    15115123 pa5 PhysPA5 null PhysicallyActive5DaysPerWeek num 0 8
     
    15615623 pe0 PhysPE0 null DidNotAttendPEClassesInAnAverageSchoolWeek num 0 8
    15715723 qndlype PhysDlyPE null AttendedPEClassesDaily num 0 8
    158 # ******** Indicators BODY WEIGHT ********   
     158# ******** Indicators BODY WEIGHT ********
    15915925 owtobese BodyOwtObese null OverweightOrObese num 0 8
    16016025 qnowt BodyOwt null Overweight num 0 8
    16116125 qnobese BodyObese null Obese num 0 8
    162 # ******** Indicators MENTAL HEALTH ********   
     162# ******** Indicators MENTAL HEALTH ********
    16316331 nssi MentNSSI null Non-SuicidalSelfInjury num 0 8
    16416431 sad MentSad null SadnessOrHopelessness num 0 8
     
    16716731 suiatt MentSuiAtt null AttemptedSuicide num 0 8
    16816831 suiinj MentSuiInj null InjuredInASuicideAttempt num 0 8
    169 # ******** Indicators SEXUAL BEH ********   
     169# ******** Indicators SEXUAL BEH ********
    17017041 sexact SexuSexAct null SexuallyActive num 0 8
    17117141 sex13 SexuSex13 null FirstHadSexualIntercourseBeforeAge13 num 0 8
     
    17817841 sexgndr1 SexuSexGndr1 null EverSexPartnersWereSameSex num 0 8
    17917941 sexsame SexuSexSame null SexualContactWithSomeoneSameSexOnceLifetime num 0 8
    180 # ******** Indicators INJURY ********   
     180# ******** Indicators INJURY ********
    18118151 helmet InjHelmet null WoreABicycleHelmet num 0 8
    18218251 seatbelt InjSeatBelt null WoreASeatbelt num 0 8
     
    19819851 dateforce InjDateForce null SexualDatingViolenceAmongThoseWhoDated num 0 8
    19919951 dateforce1 InjDateForce1 null SexualDatingViolence num 0 8
    200 # ******** Indicators OTHER ********   
     200# ******** Indicators OTHER ********
    20120171 asthevr OthAsthEvr null EverToldHasAsthma num 0 8
    20220271 asthcurr OthAsthCurr null HasAsthmaNow num 0 8
Note: See TracChangeset for help on using the changeset viewer.