Changeset 24370 in main
- Timestamp:
- 12/23/21 11:40:16 (8 months ago)
- Location:
- adopters/nm/trunk/src/main/backend_qModules/2.3
- Files:
-
- 3 added
- 8 deleted
- 38 edited
Legend:
- Unmodified
- Added
- Removed
-
adopters/nm/trunk/src/main/backend_qModules/2.3/_EPHT/ed/_ED0818.cfg
r20394 r24370 22 22 d saspath E:\ibisq\sasData\final\ 23 23 d saspop E:\ibisq\sasData\final\ 24 r sasdata nm_ed_0818 25 d saspopdata popibiscnty90_18_28jun2019 24 25 r sasdata nm_ed_0819 26 d saspopdata popibiscnty90_19_20oct2020 27 26 28 #d saspopdata popibissarea90_15_11oct2016 27 29 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" 28 30 #r sas_bin sas&-memsize&0 31 29 32 r pop_where 2008<=year<=2018 30 33 r data_where 2008<=year<=2018 -
adopters/nm/trunk/src/main/backend_qModules/2.3/hidd/_HIDD18.cfg
r22137 r24370 11 11 d workpath E:\ibisq\workpath 12 12 #################################################################### 13 d saspath E:\ibisq\sasData\final \14 d saspop E:\ibisq\sasData\final \13 d saspath E:\ibisq\sasData\final 14 d saspop E:\ibisq\sasData\final 15 15 16 16 d sasdata hiddkiss08_18 … … 41 41 #value =any value, place holder only 42 42 # name_sas = SAS variable name in the numerator data set (birth data set) 43 # name_html = html name that specified under<DIMENSION> <NAME> in Module XML file43 # name_html = html name: <DIMENSION> <NAME> in Module XML file 44 44 # name_pop = SAS variable name in denominator data set (population data set) 45 # prompt = Place holder only, could by any character string. (I used x to pad the line)45 # prompt = Place holder only, could by any character string. 46 46 # type1 = CGI data type for SAS variable type (see comment lines 48 & 49) 47 47 # type2 = CGI data type for CGI regrouping purpose (see comment lines 51-59) … … 165 165 166 166 10 null GeoProxy null ProxyVar num 10 4 167 10 fipsc odeGeoCnty fipscode NMCounties num 0 8167 10 fipscnty GeoCnty fipscode NMCounties num 0 8 168 168 10 Region GeoRegion region NMRegion num 0 8 169 169 10 urbanrur GeoUrbanRur UrbanRur UrbanRuralCounties num 0 8 … … 173 173 14 licensetyp SysFacilityType null PrimaryPayerCategory num 0 8 174 174 175 # The popcount variable is only referenced in the .DEF files ==================== 176 177 175 # The popcount variable is only referenced in the .DEF files ================== -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepi23/NM_CountMoWkPersYrs.def
r18931 r24370 110 110 create table numbers as 111 111 select tmp.*, pop.* 112 from tmp ,pop113 where112 from tmp left join pop 113 on 114 114 ?popcross1? tmp.%cross1%=pop.%popcross1%; 115 115 ?popcross2? tmp.%cross2%=pop.%popcross2%; … … 126 126 create table numbers as 127 127 select tmp.*, pop.* 128 from tmp ,pop129 wheretmp.%cross1%=pop.%popcross1% and128 from tmp left join pop 129 on tmp.%cross1%=pop.%popcross1% and 130 130 tmp.%cross2%=pop.%popcross2%; 131 131 quit; … … 142 142 data rate; 143 143 set numbers; 144 if 1<=eventmonth<=12 then popcount=(popcount/12);145 if 1<=mmwr_week<=53 then popcount=(popcount/52);146 144 rate=count/popcount; 147 145 if count>0 then do; -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepi23/_IDEpi.cfg
r18931 r24370 61 61 #value name_sas name_html name_pop prompt type1 type2 length 62 62 63 10 nullDisease null Event num 0 863 10 disease Disease null Event num 0 8 64 64 10 event Event null Event num 0 8 65 65 10 event HepBAcuteChronic null Acute&vs&Chronic&Cases num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_CaseFatalityAACOVID.def
r21187 r24370 28 28 proc summary data=tmp; 29 29 var percentvar; 30 class agegrp 5 %cross1%30 class agegrp35 %cross1% 31 31 ?cross2? %cross2% 32 32 ; 33 33 output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum; 34 proc sort data=tmp out=sorted; by %cross1% 34 run; 35 run; 36 data agecases; 37 set tmp; 38 agecases=.; 39 if agegrp35 in (1:5) then agecases=1; 40 if agegrp35 in (6:18) then agecases=2; 41 if agegrp35 in (19:23) then agecases=3; 42 if agegrp35 in (24 25) then agecases=4; 43 if agegrp35 in (26 27) then agecases=5; 44 if agegrp35 in (28:30) then agecases=6; 45 if agegrp35 in (31 32) then agecases=7; 46 if agegrp35 in (33 34) then agecases=8; 47 if agegrp35 in (35) then agecases=9; 48 run; 49 proc summary data=agecases; 50 class agecases %cross1% 35 51 ?cross2? %cross2% 36 agegrp5; 37 run; 38 run; 52 ; 53 output out=tmp (drop=_TYPE_ _FREQ_) sum(count)= sum(totalnum)=; 54 run; 55 data tmp; 56 set tmp; 57 stdwgt=.; 58 if agecases=1 then stdwgt=0.016; *0 - 4 Years; 59 if agecases=2 then stdwgt=0.057; *5 - 17 Years; 60 if agecases=3 then stdwgt=0.215; *18 - 29 Years; 61 if agecases=4 then stdwgt=0.171; *30 - 39 Years; 62 if agecases=5 then stdwgt=0.159; *40 - 49 Years; 63 if agecases=6 then stdwgt=0.218; *50 - 64 Years; 64 if agecases=7 then stdwgt=0.080; *65 - 74 Years; 65 if agecases=8 then stdwgt=0.048; *75 - 84 Years; 66 if agecases=9 then stdwgt=0.037; *85+ Years; 67 run; 39 68 proc sort data=tmp out=sorted; 40 by %cross1% %cross2% age grp5;69 by %cross1% %cross2% agecases; 41 70 run; 42 71 proc print data=sorted noobs; … … 59 88 retain count 0; 60 89 do 61 age grp5= 1 to 5 by 1, 99;90 agecases= 1 to 9 by 1; 62 91 output; 63 92 end; … … 92 121 by %cross1% 93 122 ?cross2? %cross2% 94 age grp5;123 agecases; 95 124 run; 96 125 proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run; … … 98 127 data tmp; 99 128 merge new_frame sorted; *must list frame dataset first, then tmp; 100 by %cross1% %cross2% age grp5;129 by %cross1% %cross2% agecases; 101 130 run; 102 131 proc print data=tmp noobs; … … 108 137 ************************************************************************************; 109 138 ****** Special Population Distribution for COVID Case Fatality Rates ******; 139 * This was replaced in August 2020 with the new age var and wgts. ; 110 140 * 0-17 116,620 0.0549344 ; 111 141 * 18-44 894,974 0.4215820 ; … … 119 149 if %cross1%=. then %cross1%=-1; 120 150 ?cross2? if %cross2%=. then %cross2%=-1; 121 if agegrp5 = 1 then stdwgt = 0.0549344;122 if agegrp5 = 2 then stdwgt = 0.4215820;123 if agegrp5 = 3 then stdwgt = 0.3234462;124 if agegrp5 = 4 then stdwgt = 0.0925034;125 if agegrp5 = 5 then stdwgt = 0.1075339;126 151 proc print data=numbers noobs; 127 152 title2 '4. NUMBERS'; … … 133 158 data agespecific; 134 159 set numbers; 135 if age grp5^=.;160 if agecases^=.; 136 161 r=count/totalnum; 137 162 ratewgt=r*stdwgt; *weighted age-specific proportion; … … 152 177 run; 153 178 proc print data=aarate noobs; 154 title2 '5. AARATE - summed across weighted age group cross-products to get AA rate and';155 title3 ' rate variance within each cross-by var';179 title2 '5. AARATE - summed across weighted age group cross-products to get '; 180 title3 'AA rate and rate variance within each cross-by var'; 156 181 run; 157 182 … … 202 227 *no variance, n=0, rse=div by zero; 203 228 if count<=0 then redflag=put('Unstable', $12.); 204 if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;229 if totalnum=. then redflag=put('', $12.); *no value attribute for missing crossby values; 205 230 run; 206 231 … … 236 261 f out_variable rateper 237 262 # definition for output file 238 f xml_out_map_file XML PctDesirableLow.map263 f xml_out_map_file XMLRateNumerDenomLCLUCL.map 239 264 --------BoNdArY-------- 240 265 f out_detail lbl_not_used__see_xml_out_map_file -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_CaseFatalityCOVID.def
r21187 r24370 234 234 f out_variable rateper 235 235 # definition for output file 236 f xml_out_map_file XML PctDesirableLow.map236 f xml_out_map_file XMLRateNumerDenomLCLUCL.map 237 237 --------BoNdArY-------- 238 238 f out_detail lbl_not_used__see_xml_out_map_file -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/NM_RateCrudeCOVID.def
r21194 r24370 1 #NM_RateCrude MoWkPersYrs100K.def1 #NM_RateCrudeCOVID.def 2 2 #For use with COVID dataset 3 3 #Less restrictive cell suppression … … 72 72 * data, matching up the appropriate values of the cross vars. ; 73 73 *****************************************************************; 74 data poptmp; format %popcross1% %popcross2% 15.; set poptmp; run;75 74 %let flag=0; 76 75 ?popcross1? %let flag=1; … … 93 92 94 93 %if &flag=1 %then %do; 94 data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 95 95 proc summary data=poptmp; 96 96 var popcount; … … 110 110 111 111 %if &flag=2 %then %do; 112 data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 112 113 proc summary data=poptmp; 113 114 var popcount; -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/_COVID19Cnty.cfg
r21187 r24370 14 14 d saspath E:\ibisq\sasData\final\ 15 15 d saspop E:\ibisq\sasData\final\ 16 r sasdata covid_ibis 16 17 r sasdata covid_ibis_cases 17 18 d saspopdata popibiscnty90_18_28jun2019 18 19 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" … … 87 88 20 null GeoProxy fipscode Geography num 10 8 88 89 20 fipscnty GeoCnty fipscode ResidentialCounty num 0 8 90 20 fipscnty GeoCntyRank fipscode ResidentialCounty num 0 8 89 91 20 region GeoRegion region HealthRegion num 0 8 90 92 20 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/_COVID19CntyTests.cfg
r21187 r24370 9 9 10 10 #value name_path value_path 11 d homepath E:\ibisq\qModules 30\idepi\11 d homepath E:\ibisq\qModules\idepiPGL\ 12 12 d workpath E:\ibisq\workpath 13 13 #################################################################### … … 25 25 d response_tail_content XMLResponse.tail 26 26 ##################################################################### 27 r form 3027 r form 22 28 28 r output xml 29 29 r func 1 -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_CaseFatalityAACOVID.def
r21187 r24370 28 28 proc summary data=tmp; 29 29 var percentvar; 30 class agegrp 5 %cross1%30 class agegrp35 %cross1% 31 31 ?cross2? %cross2% 32 32 ; 33 33 output out=tmp (drop=_TYPE_ _FREQ_) sum=count n=totalnum; 34 proc sort data=tmp out=sorted; by %cross1% 34 run; 35 run; 36 data agecases; 37 set tmp; 38 agecases=.; 39 if agegrp35 in (1:5) then agecases=1; 40 if agegrp35 in (6:18) then agecases=2; 41 if agegrp35 in (19:23) then agecases=3; 42 if agegrp35 in (24 25) then agecases=4; 43 if agegrp35 in (26 27) then agecases=5; 44 if agegrp35 in (28:30) then agecases=6; 45 if agegrp35 in (31 32) then agecases=7; 46 if agegrp35 in (33 34) then agecases=8; 47 if agegrp35 in (35) then agecases=9; 48 run; 49 proc summary data=agecases; 50 class agecases %cross1% 35 51 ?cross2? %cross2% 36 agegrp5; 37 run; 38 run; 52 ; 53 output out=tmp (drop=_TYPE_ _FREQ_) sum(count)= sum(totalnum)=; 54 run; 55 data tmp; 56 set tmp; 57 stdwgt=.; 58 if agecases=1 then stdwgt=0.016; *0 - 4 Years; 59 if agecases=2 then stdwgt=0.057; *5 - 17 Years; 60 if agecases=3 then stdwgt=0.215; *18 - 29 Years; 61 if agecases=4 then stdwgt=0.171; *30 - 39 Years; 62 if agecases=5 then stdwgt=0.159; *40 - 49 Years; 63 if agecases=6 then stdwgt=0.218; *50 - 64 Years; 64 if agecases=7 then stdwgt=0.080; *65 - 74 Years; 65 if agecases=8 then stdwgt=0.048; *75 - 84 Years; 66 if agecases=9 then stdwgt=0.037; *85+ Years; 67 run; 39 68 proc sort data=tmp out=sorted; 40 by %cross1% %cross2% age grp5;69 by %cross1% %cross2% agecases; 41 70 run; 42 71 proc print data=sorted noobs; … … 59 88 retain count 0; 60 89 do 61 age grp5= 1 to 5 by 1, 99;90 agecases= 1 to 9 by 1; 62 91 output; 63 92 end; … … 92 121 by %cross1% 93 122 ?cross2? %cross2% 94 age grp5;123 agecases; 95 124 run; 96 125 proc print data=new_frame noobs; title2 'new_frame, sorted with nodupkey'; run; … … 98 127 data tmp; 99 128 merge new_frame sorted; *must list frame dataset first, then tmp; 100 by %cross1% %cross2% age grp5;129 by %cross1% %cross2% agecases; 101 130 run; 102 131 proc print data=tmp noobs; … … 108 137 ************************************************************************************; 109 138 ****** Special Population Distribution for COVID Case Fatality Rates ******; 139 * This was replaced in August 2020 with the new age var and wgts. ; 110 140 * 0-17 116,620 0.0549344 ; 111 141 * 18-44 894,974 0.4215820 ; … … 119 149 if %cross1%=. then %cross1%=-1; 120 150 ?cross2? if %cross2%=. then %cross2%=-1; 121 if agegrp5 = 1 then stdwgt = 0.0549344;122 if agegrp5 = 2 then stdwgt = 0.4215820;123 if agegrp5 = 3 then stdwgt = 0.3234462;124 if agegrp5 = 4 then stdwgt = 0.0925034;125 if agegrp5 = 5 then stdwgt = 0.1075339;126 151 proc print data=numbers noobs; 127 152 title2 '4. NUMBERS'; … … 133 158 data agespecific; 134 159 set numbers; 135 if age grp5^=.;160 if agecases^=.; 136 161 r=count/totalnum; 137 162 ratewgt=r*stdwgt; *weighted age-specific proportion; … … 152 177 run; 153 178 proc print data=aarate noobs; 154 title2 '5. AARATE - summed across weighted age group cross-products to get AA rate and';155 title3 ' rate variance within each cross-by var';179 title2 '5. AARATE - summed across weighted age group cross-products to get '; 180 title3 'AA rate and rate variance within each cross-by var'; 156 181 run; 157 182 … … 202 227 *no variance, n=0, rse=div by zero; 203 228 if count<=0 then redflag=put('Unstable', $12.); 204 if popcount=. then redflag=put('', $12.); *no value attribute for missing crossby values;229 if totalnum=. then redflag=put('', $12.); *no value attribute for missing crossby values; 205 230 run; 206 231 -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_Rate100.def
r21187 r24370 1 #NM_Rate Crude1K_data_frame.def1 #NM_Rate100.def 2 2 #Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp) 3 3 #Uses the IBIS-Q data_frame for cross1 and cross2 … … 36 36 37 37 *********************** 2. data_frame **************************; 38 * df_%cross1%%cross2% is a dataset created by IBIS-Q. ;38 * df_%cross1%%cross2% is a dataset created by IBIS-Q. ; 39 39 * It consists of %cross1% and %cross2% (if the user specified ; 40 40 * %cross2%) and a variable named "count" that is set to "0". ; 41 41 * The results of the proc summary must be merged with the ; 42 * df_%cross1%%cross2% dataset. ;42 * df_%cross1%%cross2% dataset. ; 43 43 ****************************************************************; 44 44 data frame; … … 52 52 run; 53 53 54 data new;54 data tmp; 55 55 merge frame sorted; *must list frame dataset first, then tmp; 56 56 by %cross1% -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_Rate100ZIP.def
r21187 r24370 52 52 run; 53 53 54 data new;54 data tmp; 55 55 merge frame sorted; *must list frame dataset first, then tmp; 56 56 by %cross1% -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/NM_RateCrudeCOVID.def
r21187 r24370 72 72 * data, matching up the appropriate values of the cross vars. ; 73 73 *****************************************************************; 74 data poptmp; format %popcross1% %popcross2% 15.; set poptmp; run;75 74 %let flag=0; 76 75 ?popcross1? %let flag=1; … … 93 92 94 93 %if &flag=1 %then %do; 94 data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 95 95 proc summary data=poptmp; 96 96 var popcount; … … 110 110 111 111 %if &flag=2 %then %do; 112 data poptmp; format %popcross1% %popcross2% 15.0; set poptmp; run; 112 113 proc summary data=poptmp; 113 114 var popcount; -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/_COVID19Cnty.cfg
r21187 r24370 14 14 d saspath E:\ibisq\sasData\final\ 15 15 d saspop E:\ibisq\sasData\final\ 16 r sasdata covid_ibis 16 17 r sasdata covid_ibis_cases 17 18 d saspopdata popibiscnty90_18_28jun2019 19 18 20 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" 19 21 r data_where 1<=fipscnty<=97 … … 87 89 20 null GeoProxy fipscode Geography num 10 8 88 90 20 fipscnty GeoCnty fipscode ResidentialCounty num 0 8 91 20 fipscnty GeoCntyRank fipscode ResidentialCounty num 0 8 89 92 20 region GeoRegion region HealthRegion num 0 8 90 93 20 urbanrur GeoUrbanRur urbanrur UrbanRuralCounties num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/idepiPGL/fromV3.0ForCovidFiles/_COVID19Sarea.cfg
r21187 r24370 14 14 d saspath E:\ibisq\sasData\final\ 15 15 d saspop E:\ibisq\sasData\final\ 16 16 17 r sasdata covid_sarea 17 18 d saspopdata popibissarea90_18_28jun2019 19 18 20 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" 19 21 #r data_where mmwr_week^=0 -
adopters/nm/trunk/src/main/backend_qModules/2.3/infmort23/_InfMortSecure18.cfg
r19153 r24370 7 7 # Date By Description 8 8 # ---------- --------- ------------------------------------------------- 9 # 11/09/2020 Lois H Added 2019 data 9 10 # 09/04/2019 Lois H Added 2018 data 10 11 # 08/02/2018 Lois H Added 2017 data … … 22 23 d saspop E:\ibisq\sasData\final 23 24 24 d sasdata death99_17geo_18 ngeo_ibis25 d saspopdata birth90_17geo_18 ungeo25 d sasdata death99_17geo_18_19ngeo 26 d saspopdata birth90_17geo_18_19ngeo 26 27 #remember, use birth data for pop data!! 27 28 28 29 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" 29 30 30 r data_where (1999<=year<=201 8&and&nmres=1&and&agepop=1)31 r pop_where (1999<=year<=201 8)31 r data_where (1999<=year<=2019&and&nmres=1&and&agepop=1) 32 r pop_where (1999<=year<=2019) 32 33 33 34 #################################################################### -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_Count_ARDI_data_frame.def
r11779 r24370 1 1 #NM_Count_ARDI_data_frame.def 2 2 #Counts records that have been filtered by IBIS-Q (data=tmp) 3 #Numerator is sum of alcohol-attributable fraction (aaf 2) values instead of "x" var3 #Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var 4 4 #Uses the IBIS-Q data_frame for cross1 and cross2 5 5 #NM_ = New Mexico cell suppression version … … 18 18 * in already by ibis-q. Any filters have already been applied. ; 19 19 * Proc summary counts number of deaths by cross1 and cross2. ; 20 * "aaf 2" the attrib fraction variable, must be in the dataset. ;20 * "aaf3" the attrib fraction variable, must be in the dataset. ; 21 21 ****************************************************************; 22 22 proc summary data=tmp; 23 23 format count 18.6; 24 var aaf 2;24 var aaf3; 25 25 class %cross1% 26 26 ?cross2? %cross2% … … 188 188 data tmp; 189 189 set tmp; 190 if ((0<n<4) and ( popcount<5000)) then do;190 if ((0<n<4) and (.<popcount<5000)) then do; 191 191 n = .A; 192 192 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_3YrAvg_df.def
r17280 r24370 2 2 #Calculates age-adjusted rates for 3-year moving averages for 3 3 # records that have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 # values instead of "x" var 6 6 #Uses the IBIS-Q data_frame for cross1 … … 21 21 * in already by ibis-q. Any filters have already been applied. ; 22 22 * The proc summary counts deaths by agepop, cross1, and cross2. ; 23 * "aaf 2" the attrib fraction variable, must be in the dataset. ;23 * "aaf3" the attrib fraction variable, must be in the dataset. ; 24 24 * spvar1 is the first year that data are available for the ; 25 25 * dataset. The spvar1 value is set in the Module.xml file. ; … … 29 29 proc summary data=tmp nway; 30 30 format count 15.6; 31 var aaf 2;31 var aaf3; 32 32 class agepop %cross1% 33 33 ?cross2? %cross2% … … 305 305 data tmp; 306 306 set tmp; 307 if ((0<n<4) and ( popcount3<5000)) then do;307 if ((0<n<4) and (.<popcount3<5000)) then do; 308 308 n = .A; 309 309 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_5YrAvg_df.def
r17280 r24370 2 2 #Calculates age-adjusted rates for 5-year moving averages for 3 3 # records that have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 # values instead of "x" var 6 6 #Uses the IBIS-Q data_frame for cross1 … … 21 21 * in already by ibis-q. Any filters have already been applied. ; 22 22 * The proc summary counts deaths by agepop, cross1, and cross2. ; 23 * "aaf 2" the attrib fraction variable, must be in the dataset. ;23 * "aaf3" the attrib fraction variable, must be in the dataset. ; 24 24 * spvar1 is the first year that data are available for the ; 25 25 * dataset. The spvar1 value is set in the Module.xml file. ; … … 29 29 proc summary data=tmp nway; 30 30 format count 15.6; 31 var aaf 2;31 var aaf3; 32 32 class agepop %cross1% 33 33 ?cross2? %cross2% … … 305 305 data tmp; 306 306 set tmp; 307 if ((0<n<4) and ( popcount5<5000)) then do;307 if ((0<n<4) and (.<popcount5<5000)) then do; 308 308 n = .A; 309 309 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_data_frame.def
r17280 r24370 2 2 #Calculates directly age-adjusted rates for records that 3 3 # have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 #Uses the IBIS-Q data_frame for cross1 and cross2 6 6 #Uses an "agepop_frame" so all agepop groups are always included/represented … … 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 proc summary data=tmp; 25 25 format count 15.6; 26 var aaf 2;26 var aaf3; 27 27 class agepop %cross1% 28 28 ?cross2? %cross2% … … 275 275 data tmp; 276 276 set tmp; 277 if ((0<n<4) and ( popcount<5000)) then do;277 if ((0<n<4) and (.<popcount<5000)) then do; 278 278 n = .A; 279 279 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_ARDI_data_frame_legis.def
r17669 r24370 51 51 ***********************************************************************************; 52 52 proc summary data=tmp; 53 var aaf 2;53 var aaf3; 54 54 class &STDVAR %cross1% 55 55 ?cross2? %cross2% … … 289 289 data tmp; 290 290 set rate; 291 if popcount=. and (0<n<4) then delete; *if unknown row is only suppressed row; 292 else if ((0<n<4) and (popcount<5000)) then do; 291 else if ((0<n<4) and (.<popcount<5000)) then do; 293 292 n = .A; 294 293 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateAA100K_data_frame.def
r17280 r24370 291 291 n = .A; 292 292 rateper = .A; 293 popcount = .A; 293 294 LL = put('**', 8.0); 294 295 UL = put('**', 8.0); … … 322 323 n 323 324 rateper 324 --------BoNdArY-------- 325 popcount 326 --------BoNdArY-------- -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_3YrAvg_df.def
r17280 r24370 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 %let begyear=%spvar1%; … … 26 26 proc summary data=tmp; 27 27 format count 15.6; 28 var aaf 2;28 var aaf3; 29 29 class %cross1% 30 30 ?cross2? %cross2% … … 203 203 data tmp; 204 204 set tmp; 205 if ((0<n<4) and ( popcount3<5000)) then do;205 if ((0<n<4) and (.<popcount3<5000)) then do; 206 206 n = .A; 207 207 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_5YrAvg_df.def
r17280 r24370 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 %let begyear=%spvar1%; … … 26 26 proc summary data=tmp; 27 27 format count 15.6; 28 var aaf 2;28 var aaf3; 29 29 class %cross1% 30 30 ?cross2? %cross2% … … 203 203 data tmp; 204 204 set tmp; 205 if ((0<n<4) and ( popcount5<5000)) then do;205 if ((0<n<4) and (.<popcount5<5000)) then do; 206 206 n = .A; 207 207 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_ARDI_data_frame.def
r17280 r24370 1 1 #NM_RateCrude100K_ARDI_data_frame.def 2 2 #Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp) 3 #Numerator is sum of alcohol-attributable fraction (aaf 2) values instead of "x" var3 #Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var 4 4 #Uses the IBIS-Q data_frame for cross1 and cross2 5 5 #NM_ = New Mexico cell suppression version … … 18 18 * in already by ibis-q. Any filters have already been applied. ; 19 19 * Proc summary counts number of deaths by cross1 and cross2. ; 20 * The variable "aaf 2" must be in the dataset. ;20 * The variable "aaf3" must be in the dataset. ; 21 21 ****************************************************************; 22 22 proc summary data=tmp; 23 23 format count 15.6; 24 var aaf 2;24 var aaf3; 25 25 class %cross1% 26 26 ?cross2? %cross2% … … 187 187 data tmp; 188 188 set tmp; 189 if ((0<n<4) and ( popcount<5000)) then do;189 if ((0<n<4) and (.<popcount<5000)) then do; 190 190 n = .A; 191 191 rateper = .A; -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/NM_RateCrude100K_data_frame.def
r19153 r24370 10 10 --------BoNdArY-------- 11 11 1 script 12 OPTIONS MPRINT MLOGIC SYMBOLGENNONUMBER NODATE PAGESIZE=4000;12 OPTIONS MPRINT MLOGIC MLOGICNEST SYMBOLGEN MPRINTNEST MEXECNOTE NONUMBER NODATE PAGESIZE=4000; 13 13 OPTION SPOOL; 14 14 … … 79 79 if fipscode in (88 99) and count in (0 1 2 3) then delete; 80 80 run; 81 %end; 81 %end; 82 82 %mend unkncnty; 83 83 %unkncnty; … … 204 204 n = .A; 205 205 rateper = .A; 206 popcount = .A; 206 207 LL = put('**', 8.0); 207 208 UL = put('**', 8.0); … … 234 235 ********************************************************************; 235 236 --------BoNdArY-------- 236 1 suppressed_variables 2237 1 suppressed_variables 5 237 238 rateper 238 239 n 239 --------BoNdArY-------- 240 popcount 241 LL 242 UL 243 --------BoNdArY-------- -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_3YrAvg_df.def
r17280 r24370 2 2 #Calculates age-adjusted rates for 3-year moving averages for 3 3 # records that have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 # values instead of "x" var 6 6 #Uses the IBIS-Q data_frame for cross1 … … 21 21 * in already by ibis-q. Any filters have already been applied. ; 22 22 * The proc summary counts deaths by agepop, cross1, and cross2. ; 23 * "aaf 2" the attrib fraction variable, must be in the dataset. ;23 * "aaf3" the attrib fraction variable, must be in the dataset. ; 24 24 * spvar1 is the first year that data are available for the ; 25 25 * dataset. The spvar1 value is set in the Module.xml file. ; … … 29 29 proc summary data=tmp nway; 30 30 format count 15.6; 31 var aaf 2;31 var aaf3; 32 32 class agepop %cross1% 33 33 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_5YrAvg_df.def
r17280 r24370 2 2 #Calculates age-adjusted rates for 5-year moving averages for 3 3 # records that have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 # values instead of "x" var 6 6 #Uses the IBIS-Q data_frame for cross1 … … 21 21 * in already by ibis-q. Any filters have already been applied. ; 22 22 * The proc summary counts deaths by agepop, cross1, and cross2. ; 23 * "aaf 2" the attrib fraction variable, must be in the dataset. ;23 * "aaf3" the attrib fraction variable, must be in the dataset. ; 24 24 * spvar1 is the first year that data are available for the ; 25 25 * dataset. The spvar1 value is set in the Module.xml file. ; … … 29 29 proc summary data=tmp nway; 30 30 format count 15.6; 31 var aaf 2;31 var aaf3; 32 32 class agepop %cross1% 33 33 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateAA100K_ARDI_data_frame.def
r17280 r24370 2 2 #Calculates directly age-adjusted rates for records that 3 3 # have been filtered by IBIS-Q (data=tmp) 4 #Numerator is sum of alcohol-attributable fraction (aaf 2)4 #Numerator is sum of alcohol-attributable fraction (aaf3) 5 5 #Uses the IBIS-Q data_frame for cross1 and cross2 6 6 #Uses an "agepop_frame" so all agepop groups are always included/represented … … 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 proc summary data=tmp; 25 25 format count 15.6; 26 var aaf 2;26 var aaf3; 27 27 class agepop %cross1% 28 28 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_3YrAvg_df.def
r17280 r24370 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 %let begyear=%spvar1%; … … 26 26 proc summary data=tmp; 27 27 format count 15.6; 28 var aaf 2;28 var aaf3; 29 29 class %cross1% 30 30 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_5YrAvg_df.def
r17280 r24370 20 20 * in already by ibis-q. Any filters have already been applied. ; 21 21 * The proc summary counts deaths by agepop, cross1, and cross2. ; 22 * "aaf 2" the attrib fraction variable, must be in the dataset. ;22 * "aaf3" the attrib fraction variable, must be in the dataset. ; 23 23 ****************************************************************; 24 24 %let begyear=%spvar1%; … … 26 26 proc summary data=tmp; 27 27 format count 15.6; 28 var aaf 2;28 var aaf3; 29 29 class %cross1% 30 30 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/S_ND_RateCrude100K_ARDI_data_frame.def
r17280 r24370 1 1 #S_ND_RateCrude100K_ARDI_data_frame.def 2 2 #Calculates crude rates for records that have been filtered by IBIS-Q (data=tmp) 3 #Numerator is sum of alcohol-attributable fraction (aaf 2) values instead of "x" var3 #Numerator is sum of alcohol-attributable fraction (aaf3) values instead of "x" var 4 4 #Uses the IBIS-Q data_frame for cross1 and cross2 5 5 #S_ND_ = Secure, No-Dagger version … … 19 19 * in already by ibis-q. Any filters have already been applied. ; 20 20 * Proc summary counts number of deaths by cross1 and cross2. ; 21 * The variable "aaf 2" must be in the dataset. ;21 * The variable "aaf3" must be in the dataset. ; 22 22 ****************************************************************; 23 23 proc summary data=tmp; 24 24 format count 15.6; 25 var aaf 2;25 var aaf3; 26 26 class %cross1% 27 27 ?cross2? %cross2% -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_Mort18.cfg
r19153 r24370 5 5 # Date By Description 6 6 # ---------- --------- ------------------------------------------------- 7 # 11/09/2020 Lois H added 2019 7 8 # 08/02/2018 Lois H added 2018 8 9 # 08/02/2018 Lois H added 2017 … … 19 20 20 21 r sasdata death99_17geo_18ngeo_ibis 21 d saspopdata popibiscnty90_1 8_28jun201922 d saspopdata popibiscnty90_19_20oct2020 22 23 23 24 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe" -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortLegis17.cfg
r20394 r24370 34 34 r cross1 AgeGrpProxy 35 35 r cross2 none 36 r popcross1 none 37 r popcross2 none 36 38 r spvar1 none 37 39 #r pass_through none … … 82 84 2 NCHS50 ICDNCHS15LCD null 15NMleadingcauses num 0 8 83 85 2 NCHS113 ICDNCHS113 null NCHS113causes num 0 8 84 2 aaf 2_3a_cat CauseAlcohol null AlcoholRelated num 0 886 2 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8 85 87 2 drug_od CauseDrug null DrugOverdose num 0 8 86 88 2 drug_od2 CauseDrug2 null DrugOverdose num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSDH17.cfg
r20394 r24370 42 42 r cross1 AgeGrpProxy 43 43 r cross2 none 44 r popcross1 none 45 r popcross2 none 44 46 r spvar1 none 45 47 #r pass_through none … … 93 95 2 NCHS50 ICDNCHS50 null NCHS50leadingcauses num 0 8 94 96 2 NCHS113 ICDNCHS113 null NCHS113causes num 0 8 95 2 aaf 2_3a_cat CauseAlcohol null AlcoholRelated num 0 897 2 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8 96 98 2 drug_OD2 CauseDrug null DrugOverdose num 0 8 97 99 2 injwork CauseWork null Workrelated num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSarea17.cfg
r18931 r24370 19 19 d saspop E:\ibisq\sasData\final\ 20 20 21 r sasdata death99_17geo_ ibis21 r sasdata death99_17geo_18_19ngeo 22 22 d saspopdata popibissarea90_18_28jun2019 23 23 … … 88 88 2 nchs50 ICDNCHS15LCD null 15NMleadingcauses num 0 8 89 89 2 nchs113 ICDNCHS113 null NCHS113causes num 0 8 90 2 aaf 2_3a_cat CauseAlcohol null AlcoholRelated num 0 890 2 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8 91 91 2 drug_od CauseDrug null DrugOverdose num 0 8 92 92 2 drug_od2 CauseDrug2 null DrugOverdose num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSareaSecure17.cfg
r18931 r24370 88 88 2 NCHS50 ICDNCHS15LCD null 15NMleadingcauses num 0 8 89 89 2 NCHS113 ICDNCHS113 null NCHS113causes num 0 8 90 2 aaf 2_3a_cat CauseAlcohol null AlcoholRelated num 0 890 2 aaf3_3a_cat CauseAlcohol null AlcoholRelated num 0 8 91 91 2 drug_od CauseDrug null DrugOverdose num 0 8 92 92 2 drug_od2 CauseDrug2 null DrugOverdose num 0 8 -
adopters/nm/trunk/src/main/backend_qModules/2.3/mort23/_MortSecure18.cfg
r19153 r24370 5 5 # Date By Description 6 6 # ---------- --------- ------------------------------------------------- 7 # 11/09/2020 Lois H added 2019 7 8 # 08/02/2018 Lois H added 2017 8 9 # 07/25/2017 Lois H added 2016 data and denominators … … 19 20 20 21 r sasdata death99_17geo_18ngeo_ibis 21 d saspopdata popibiscnty90_1 8_28jun201922 d saspopdata popibiscnty90_19_20oct2020 22 23 23 24 d sas_bin "C:\Program&Files\SASHome\SASFoundation\9.4\sas.exe"
Note: See TracChangeset
for help on using the changeset viewer.