Changeset 21733 in main


Ignore:
Timestamp:
10/06/20 14:39:37 (3 weeks ago)
Author:
LoisHaggard_NM
Message:

backend qModules files ACS - interim commit

Location:
adopters/nm/trunk/src/main/backend_qModules/3.0/acs
Files:
5 added
2 deleted
7 edited
4 moved

Legend:

Unmodified
Added
Removed
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/Count.def

    r21732 r21733  
    4242                if stderr=. then redflag=put('Unstable', $12.);
    4343        end;
    44         if count<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero
     44        if count<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero;
     45        run;
     46        proc print data=rate noobs; title2 'rate'; run;
     47
     48        data tmp;
     49                set rate;
    4550                if %cross1%=35000 then %cross1%=.;
    46                 if %cross1%=1000 then delete;
    47         run;
    48        
    49         proc print data=tmp; title2 'final tmp'; run;
     51                if %cross1%=1000 then %cross1%=.;
     52                run;
     53        proc print data=tmp noobs; title2 'final tmp'; run;
    5054
    5155--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/Median.def

    r21732 r21733  
    3939        if median>0 then do;
    4040                rse=(stderr/median);
    41                 redflag=put('-', $14.);
    42                 if rse>.3 then redflag=put('Unstable', $14.);
    43                 if rse>.5 then redflag=put('Very Unstable', $14.);
    44                 if stderr=. then redflag=put('Unstable', $14.);
     41                redflag=put('', $12.);
     42                if rse>.3 then redflag=put('Unstable', $12.);
     43                if rse>.5 then redflag=put('VeryUnstable', $12.);
     44                if stderr=. then redflag=put('Unstable', $12.);
    4545        end;
    46         if median<=0 then redflag=put('Unstable', $14.);  *no variance, n=0, rse=div by zero;
    47        
    48         if %cross1%=35000 then %cross1%=.;
     46        if median<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero;
    4947        run;
    50        
    51         proc print data=tmp; title2 'final tmp'; run;
     48        proc print data=rate noobs; title2 'rate'; run;
     49
     50        data tmp;
     51                set rate;
     52                if %cross1%=35000 then %cross1%=.;
     53                if %cross1%=1000 then %cross1%=.;
     54                run;
     55        proc print data=tmp noobs; title2 'final tmp'; run;
    5256
    5357--------BoNdArY--------
     
    5761--------BoNdArY--------
    5862f out_detail lbl_not_used__see_xml_out_map_file
    59   median 15.2
    60   LCL 15.0
    61   UCL 15.0
    62   redflag 15.0
     63  median 15.1
     64  LCL 15.1
     65  UCL 15.1
     66  redflag 12.0
    6367--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/PctDesirableLow.def

    r20677 r21733  
    6161 *****************************************************************;
    6262        if count>0 then do;
    63                 rse=(stderr/rateper);
     63                rse=(stderr/percent);
    6464                redflag=put('', $12.);
    6565                if rse>.3 then redflag=put('Unstable', $12.);
     
    6868        end;
    6969        if count<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero;
     70        if %cross1%=1000 then redflag=put('', $12.); *no footnote;
    7071        run;
    7172        proc print data=rate noobs; title2 'rate'; run;
     
    7374        data tmp;
    7475                set rate;
    75                 if %cross1%=35000 then %cross1%=.;
    76                 if %cross1%=1000 then delete;
    7776                run;
    7877        proc print data=tmp noobs; title2 'final tmp'; run;
     
    8483--------BoNdArY--------
    8584f out_detail lbl_not_used__see_xml_out_map_file
    86   percent 15.4
     85  percent 15.1
     86  LCL 15.1
     87  UCL 15.1
    8788  n 15.0
    8889  popnum 15.0
    89   LCL 15.4
    90   UCL 15.4
    91   redflag 15.0
     90  redflag 12.0
    9291--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/Percent.def

    r21732 r21733  
    6868        end;
    6969        if count<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero;
     70        if %cross1%=1000 then redflag=put('', $12.); *no footnote;
    7071        run;
    7172        proc print data=rate noobs; title2 'rate'; run;
     
    7374        data tmp;
    7475                set rate;
    75                 if %cross1%=35000 then %cross1%=.;
    76                 if %cross1%=1000 then delete;
    7776                run;
    7877        proc print data=tmp noobs; title2 'final tmp'; run;
     
    8483--------BoNdArY--------
    8584f out_detail lbl_not_used__see_xml_out_map_file
    86   percent 15.4
     85  percent 15.1
     86  LCL 15.1
     87  UCL 15.1
    8788  n 15.0
    8889  popnum 15.0
    89   LCL 15.4
    90   UCL 15.4
    91   redflag 15.0
     90  redflag 12.0
    9291--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/PercentACSDenom.def

    r21732 r21733  
    3030                var %spvar3%;
    3131                class %cross1% %cross2% ;
    32                 output out=pop sum=popnum;
     32                output out=pop (drop=_TYPE_ _FREQ_) sum=popnum;
    3333                run;
    3434        data pop; set pop; format %cross1% 11.0; if %cross1%=. then %cross1%=35000;
     
    4444        proc print data=rate; title2 'rate'; run;
    4545        data tmp; set rate;
    46                 drop _TYPE_ _FREQ_ ;
    4746                count=(percent/100)*popnum;
    4847                t1=(percent-(1.96*stderr));
     
    6564        if count>0 then do;
    6665                rse=(stderr/percent);
    67                 redflag=put('-', $14.);
    68                 if rse>.3 then redflag=put('Unstable', $14.);
    69                 if rse>.5 then redflag=put('Very Unstable', $14.);
    70                 if stderr=. then redflag=put('Unstable', $14.);
     66                redflag=put('', $12.);
     67                if rse>.3 then redflag=put('Unstable', $12.);
     68                if rse>.5 then redflag=put('VeryUnstable', $12.);
     69                if stderr=. then redflag=put('Unstable', $12.);
    7170        end;
    72         if count<=0 then redflag=put('Unstable', $14.);  *no variance, n=0, rse=div by zero;
    73 
    74         if %cross1%=35000 then %cross1%=.;
    75         if %cross1%=1000 then delete;
    76        
     71        if count<=0 then redflag=put('Unstable', $12.);   *no variance, n=0, rse=div by zero;
     72        if %cross1%=1000 then redflag=put('', $12.); *no footnote;
    7773        run;
    78        
    79         proc print data=tmp; title2 'final tmp'; run;
     74        proc print data=tmp noobs; title2 'final tmp'; run;
    8075
    8176--------BoNdArY--------
     
    8580--------BoNdArY--------
    8681f out_detail lbl_not_used__see_xml_out_map_file
    87   percent 15.4
     82  percent 15.1
     83  LCL 15.1
     84  UCL 15.1
    8885  n 15.0
    8986  popnum 15.0
    90   LCL 15.4
    91   UCL 15.4
    92   redflag 15.0
     87  redflag 12.0
    9388--------BoNdArY--------
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/XMLCount.map

    r20677 r21733  
    222 ANCILLARY_VALUE LowerConfidenceLimit
    333 ANCILLARY_VALUE UpperConfidenceLimit
    4 4 VALUE_ATTRIBUTE Code
     44 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/XMLMedian.map

    r20677 r21733  
    111 MEASURE Median
    2 2 ANCILLARY_VALUE Numerator
    3 3 ANCILLARY_VALUE Denominator
    4 4 ANCILLARY_VALUE LowerConfidenceLimit
    5 5 ANCILLARY_VALUE UpperConfidenceLimit
    6 6 VALUE_ATTRIBUTE Code
     22 ANCILLARY_VALUE LowerConfidenceLimit
     33 ANCILLARY_VALUE UpperConfidenceLimit
     44 ANCILLARY_VALUE Numerator
     55 ANCILLARY_VALUE Denominator
     66 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/XMLPct.map

    r20677 r21733  
    111 MEASURE Pct
    2 2 ANCILLARY_VALUE Numerator
    3 3 ANCILLARY_VALUE Denominator
    4 4 ANCILLARY_VALUE LowerConfidenceLimit
    5 5 ANCILLARY_VALUE UpperConfidenceLimit
    6 6 VALUE_ATTRIBUTE Code
     22 ANCILLARY_VALUE LowerConfidenceLimit
     33 ANCILLARY_VALUE UpperConfidenceLimit
     44 ANCILLARY_VALUE Numerator
     55 ANCILLARY_VALUE Denominator
     66 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/XMLPctDesirableHigh.map

    r20677 r21733  
    111 MEASURE PctDesirableHigh
    2 2 ANCILLARY_VALUE Numerator
    3 3 ANCILLARY_VALUE Denominator
    4 4 ANCILLARY_VALUE LowerConfidenceLimit
    5 5 ANCILLARY_VALUE UpperConfidenceLimit
    6 6 VALUE_ATTRIBUTE Code
     22 ANCILLARY_VALUE LowerConfidenceLimit
     33 ANCILLARY_VALUE UpperConfidenceLimit
     44 ANCILLARY_VALUE Numerator
     55 ANCILLARY_VALUE Denominator
     66 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/XMLPctDesirableLow.map

    r20677 r21733  
    111 MEASURE PctDesirableLow
    2 2 ANCILLARY_VALUE Numerator
    3 3 ANCILLARY_VALUE Denominator
    4 4 ANCILLARY_VALUE LowerConfidenceLimit
    5 5 ANCILLARY_VALUE UpperConfidenceLimit
    6 6 VALUE_ATTRIBUTE Code
     22 ANCILLARY_VALUE LowerConfidenceLimit
     33 ANCILLARY_VALUE UpperConfidenceLimit
     44 ANCILLARY_VALUE Numerator
     55 ANCILLARY_VALUE Denominator
     66 VALUE_ATTRIBUTE_NAME
  • adopters/nm/trunk/src/main/backend_qModules/3.0/acs/_ACSCnty18.cfg

    r20633 r21733  
    1919d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
    2020d data_where fipscode&ne&.
    21 #mid-point year of ACS dataset
     21#I amd using mid-point year of ACS dataset for pop est
    2222d pop_where 2010<=year<=2016
    2323d sascdata temp
Note: See TracChangeset for help on using the changeset viewer.