SAS Support Communities

thank you ... View more

yes ... View more

Hi Reeza: Thank you for your response.   Essentially I am trying to run a multivariable direct standardization. The strata are maternal race/ethnicity * maternal age group: ex. White <20year       Black <20year       Hispanic <20year       White 20to24year       Black 20to24year       Hispanic 20to24year       White 25to29year       Black 25to29year       Hispanic 25to29year etc       Thank you for your time and insights!       ... View more

NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) Licensed to TX DEPARTMENT OF STATE HEALTH SERVICES, Site 70206481. NOTE: This session is executing on the X64_8PRO platform. 　 　 NOTE: Updated analytical products: SAS/STAT 14.1 SAS/ETS 14.1 SAS/OR 14.1 SAS/IML 14.1 SAS/QC 14.1 NOTE: Additional host information: X64_8PRO WIN 6.2.9200 Workstation NOTE: SAS initialization used: real time 1.56 seconds cpu time 1.14 seconds 1 ** NAME: DirectStandardCombo.SAS; 2 ** PURPOSE: DIRECT STANDARDIZATION FOR COUNTY CLUSTER**; 3 4 5 title1 "County Cluster Concern "; 6 title2 "Direct Standardization (County2= Referent Population) for Defect: 6 ! Adjusted by Maternal Age & Race/Ethnicity"; 7 8 ************************************; 9 ** CREATE DATA FOR STANDARDIZATION **; 10 ************************************; 11 12 **** INPUT COUNTY1 (AREA OF CLUSTER CONCERN) DATA *****; 13 data County1; 14 County='County1'; 15 input Mom_RaceEthnic $ Mom_Age $ Cases 11. LiveBirths 11.; 16 datalines; NOTE: The data set WORK.COUNTY1 has 24 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 　 41 ; 42 43 title3 'Area of Geographic Clustering Concern: County1'; 44 proc print data=County1; NOTE: Writing HTML Body file: sashtml.htm 45 run; NOTE: There were 24 observations read from the data set WORK.COUNTY1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.89 seconds cpu time 0.37 seconds 　 46 47 48 **** INPUT COUNTY2 (REFERENT/STANDARD POPULATION) DATA *****; 49 data County2_REF; 50 County='County2'; 51 input Mom_RaceEthnic $ Mom_Age $ Cases 11. LiveBirths 11.; 52 datalines; NOTE: The data set WORK.COUNTY2_REF has 24 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 　 77 ; 78 79 title3 'Standardized/Referent Population: County2'; 80 proc print data=County2_REF; 81 run; NOTE: There were 24 observations read from the data set WORK.COUNTY2_REF. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.03 seconds 　 82 title3; 83 84 ************************************; 85 ** SORT DATA TO RUN ANALYSIS **; 86 ************************************; 87 88 proc sort data=County1; 89 by Mom_RaceEthnic Mom_Age ; 90 run; NOTE: There were 24 observations read from the data set WORK.COUNTY1. NOTE: The data set WORK.COUNTY1 has 24 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 　 91 92 proc sort data=County2_REF; 93 by Mom_RaceEthnic Mom_Age ; 94 run; NOTE: There were 24 observations read from the data set WORK.COUNTY2_REF. NOTE: The data set WORK.COUNTY2_REF has 24 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 　 95 96 ************************************; 97 ** RUN DIRECT STANDARDIZATION **; 98 ************************************; 99 100 ods graphics on ; 101 PROC STDRATE data=County1 REFDATA=County2_REF 102 METHOD=direct 103 STAT=rate(mult=10000) 104 EFFECT=ratio 105 ; 106 population group = County event = Cases total= LiveBirths; 107 reference total=LiveBirths; 108 STRATA Mom_RaceEthnic Mom_Age/effect; 109 run; NOTE: With only one group in the DATA= data set, the GROUP= option in the POPULATION statement is not used. NOTE: PROCEDURE STDRATE used (Total process time): real time 1.26 seconds cpu time 0.31 seconds 　 110 ods graphics off; 111 112 113 **************************************************; 114 **************************************************; 115 ** END DIRECT STANDARDIZATION **; 116 **************************************************; 117 **************************************************; ... View more