Data Validation Syntax - MHEC Secure Data Web Home



ENROLLMENT INFORMATION SYSTEM (EIS)MHEC Internal Validation CodeSTATA Syntax CodePosted 10/03/2019Data Validation SyntaxThe following Stata code is used to validate all file submissions. Additional validation testing may be completed contingent upon the results of this baseline code. New validation steps may be added over time as the scope of the collection changes.*file population**run distribution and compare to prior year**review for population increases and decreases of more than 10%**cross check counts of fice vs sic to ensure sic is correctly constructed*table ficetable sictable degreetab fice firstime*validate FICE-SIC alignment**does the sic expected for the fice match**does every fice have a sic*gen sicfice=.replace sicfice=1 if fice==143600& sic==260700replace sicfice=1 if fice==205700& sic==110100replace sicfice=1 if fice==205800& sic==110200replace sicfice=1 if fice==206100& sic==111300replace sicfice=1 if fice==206200& sic==120600replace sicfice=1 if fice==206300& sic==111250replace sicfice=1 if fice==206400& sic==111000replace sicfice=1 if fice==206500& sic==263300replace sicfice=1 if fice==206700& sic==261200replace sicfice=1 if fice==206800& sic==121400replace sicfice=1 if fice==207100& sic==111700replace sicfice=1 if fice==207200& sic==121800replace sicfice=1 if fice==207300& sic==262000replace sicfice=1 if fice==207400& sic==112100replace sicfice=1 if fice==207500& sic==112200replace sicfice=1 if fice==207600& sic==262300replace sicfice=1 if fice==207700& sic==262500replace sicfice=1 if fice==207800& sic==262600replace sicfice=1 if fice==208000& sic==262700replace sicfice=1 if fice==208300& sic==143000replace sicfice=1 if fice==208600& sic==263100replace sicfice=1 if fice==208900& sic==113600replace sicfice=1 if fice==209100& sic==123900replace sicfice=1 if fice==209200& sic==263700replace sicfice=1 if fice==209500& sic==154000replace sicfice=1 if fice==209900& sic==124200replace sicfice=1 if fice==210200& sic==124400replace sicfice=1 if fice==210300& sic==124700replace sicfice=1 if fice==210400& sic==124500replace sicfice=1 if fice==210500& sic==124600replace sicfice=1 if fice==210600& sic==124800replace sicfice=1 if fice==210700& sic==265000replace sicfice=1 if fice==210800& sic==265200replace sicfice=1 if fice==210900& sic==265400replace sicfice=1 if fice==465000& sic==111100replace sicfice=1 if fice==691100& sic==112970replace sicfice=1 if fice==817500& sic==112400replace sicfice=1 if fice==830800& sic==110900replace sicfice=1 if fice==1001400& sic==111900replace sicfice=1 if fice==1164400& sic==124900replace sicfice=1 if fice==2073900& sic==115470replace sicfice=1 if fice==3100700& sic==110770tab sicfice*Duplicate Check**this must be done first as variables will be constructed throughout validation that will*alter results when looking for duplicates across all variables*sort fice idn*dups on all variables*duplicates tag, generate(dups) /*duplicates in data set, data set duplicates on all elements are errors*/tab dups*dups on ssn only**validate counts are same on idn, tssn and tssn2 to make sure idn is correctly converted**id may appear multiple times if student concurrent enrolled in more than one FICE*duplicates tag idn, generate (dupssn) /*not an error, student attending multiple fice*/duplicates tag tssn, generate (duptssn)/*not an error, student attending multiple fice*/duplicates tag tssn2, generate (duptssn2)/*not an error, student attending multiple fice*/tab dupssntab duptssntab duptssn2*count unique populations**first instance of each unit record within an fice is marked as unique, additional instances as duplciate**add to excel tab and cross check against prior year totals**eis should be one row per idn per fice, duplicates are errors**counts should be the same on idn, tssn, tssn2*sort fice idnegen idn_unique=tag(fice idn)sort fice tssnegen tssn_unique=tag(fice tssn)sort fice tssn2egen tssn2_unique=tag(fice tssn2)label define counts 1 "unique" 0 "duplicate"label values idn_unique tssn_unique tssn2_unique countstab idn_uniquetab tssn_uniquetab tssn2_unique*validate individual values in data elements**********************************************************************************valid fice, 1 valid, -9 not valid*gen vfice=.replace vfice=1 if fice==143600 | fice==205700 | fice==205800 | fice==206100 | fice==206200 | fice==206300 | fice==206400 | ///fice==206500 | fice==206700 | fice==206800 | fice==207100 | ///fice==207200 | fice==207300 | fice==207400 | fice==207500 | fice==207600 | fice==207700 | ///fice==207800 | fice==208000 | fice==208600 | fice==208700 | fice==208900 | ///fice==209100 | fice==209200 | fice==209500 | fice==209600 | fice==209900 | fice==210200 | fice==210300 | ///fice==210400 | fice==210500 | fice==210600 | fice==210700 | fice==210800 | fice==210900 | fice==465000 | ///fice== 691100 | fice==795900 | fice==817500 | fice==830800 | fice==1001400 | fice==1164400 | fice== 2073900 | ///fice==208300 | fice==2127900 | fice==2314800 | fice==2578400 | fice==3100700 | fice==3455500 | fice==90795900 | fice==99765900mvdecode vfice, mv(-9)tab vfice /*valid fice, 1 valid, -9 not valid*/tab fice if vfice==-9 /*list of invalid fice numbers*/*********************************************************************************valid sic, 1 valid, -9 not valid*gen vsic=.replace vsic=1 if sic==110100 | sic==110200 | sic==110770 | sic==110900 | sic==111000 | ///sic==111100| sic==111250| sic==111300 | sic==111700 | sic==111900 | sic==112100 | ///sic==112200 | sic==112400| sic==112970 | sic==113600 | sic==115470| sic==120600 | ///sic==121400 | sic==121800| sic==123900| sic==124200 | sic==124400| sic==124500 | ///sic==124600 | sic==124700 | sic==124800| sic==124900 | sic==124960 | sic==124965 | ///sic==143000 | sic==154000 | sic==260400 | sic==260410 | sic==260469 | sic==260537| ///sic==260700 | sic==262000 | sic==262050 | sic==262230 | sic==262300| sic==262487| ///sic==262500| sic==262570 | sic==262600| sic==262650 | sic==262700 | sic==262767 | ///sic==263100 | sic==263124 | sic==263200| sic==263300| sic==263500 | sic==263700| ///sic==263915 | sic==264100| sic==264150 | sic==264182| sic==264187 | sic==264300 | ///sic==265000| sic==261200| sic==265100 | sic==265200 | sic==265300| sic==265400| ///sic==265420| sic==265600 | sic==261575| sic==263575| sic==260500 | sic==261150| ///sic==261450| sic==110800| sic==111500 | sic==111600 | sic==112800| sic==112900| ///sic==112950 | sic==260250 mvdecode vsic, mv(-9)tab vsic, missing /*1 valid, -9 not valid*/tab sic if vsic==-9 /*list of invalid sic numbers*/*********************************************************************************Validate collection term and year**select correct term and year from list below**valid collection term, 1 is valid, 2 is not valid*gen vct = .*select one of the following*replace vct = 1 if coltm == 4replace vct = 2 if coltm !=4replace vct = 1 if coltm == 3replace vct = 2 if coltm !=3replace vct = 1 if coltm == 2replace vct = 2 if coltm !=2replace vct = 1 if coltm == 1replace vct = 2 if coltm !=1tab vct /*1 is valid, 2 is not valid*/tab fice if vct==2 /*1 is valid, 2 is not valid*/*********************************************************************************valid collection year, 1 is valid, 2 is not valid**change year as needed*gen vcy = .*select one of the following*replace vcy = 1 if colyr == 2018replace vcy = 2 if colyr != 2018replace vcy = 1 if colyr == 2019replace vcy = 2 if colyr != 2019replace vcy = 1 if colyr == 2020replace vcy = 2 if colyr != 2020tab vcy /*1 is valid, 2 is not valid*/tab fice if vcy==2 /*1 is valid, 2 is not valid*/*********************************************************************************sex, 1 valid, 2 not valid*gen vsex=.replace vsex=1 if sex==1| sex==2| sex==3| sex==4replace vsex=2 if sex>=5 | sex==. | sex<1 tab sextab vsex /*1 is valid, 2 not valid*/tab fice if vsex==2 /*1 is valid, 2 not valid*/*********************************************************************************citizenship, 1 valid, 2 not valid*gen vcit=.replace vcit=1 if citizen==1|citizen==2replace vcit=2 if citizen<1 | citizen>2 | citizen==.tab vcit /*1 is valid, 2 not valid*/tab citizentab fice if vcit==2 /*1 is valid, 2 not valid*/*********************************************************************************race/ethnicity, 1 valid, 2 not valid*encode hispanic, gen (hislat)gen vhisp=.replace vhisp=1 if hislat==1 | hislat==2 |hislat==.replace vhisp=2 if hislat!=1 & hislat!=2 & hislat!=.mvencode hislat, mv(9)tab hispanictab hislattab vhisp /*1 is valid, 2 not valid*/tab fice if vhisp==2 /*1 is valid, 2 not valid*/gen vrwhite=.replace vrwhite=1 if rwhite==1 |rwhite==.replace vrwhite=2 if rwhite!=1 & rwhite!=.tab vrwhite /*1 is valid, 2 not valid*/tab fice if vrwhite==2 /*1 is valid, 2 not valid*/gen vrblack=.replace vrblack=1 if rblack==2|rblack==.replace vrblack=2 if rblack!=2 & rblack!=.tab vrblack /*1 is valid, 2 not valid*/tab fice if vrblack==2 /*1 is valid, 2 not valid*/gen vrasian=.replace vrasian=1 if rasian==3 |rasian==.replace vrasian=2 if rasian!=3 & rasian!=.tab vrasian /*1 is valid, 2 not valid*/tab fice if vrasian==2 /*1 is valid, 2 not valid*/gen vamer=.replace vamer=1 if raian==4 |raian==.replace vamer=2 if raian!=4 & raian!=.tab vamer /*1 is valid, 2 not valid*/tab fice if vamer==2 /*1 is valid, 2 not valid*/gen vhawi=.replace vhawi=1 if rnhpi==5 |rnhpi==.replace vhawi=2 if rnhpi!=5 & rnhpi!=.tab vhawi /*1 is valid, 2 not valid*/tab fice if vhawi==2 /*1 is valid, 2 not valid*/*********************************************************************************birthdt - must be 8 digits with at least a valid 4 digit year + 0000 or can be 00000000 if unknown**considering birthdt between 1900 and 2017 valid, tagging unknowns as 3**1 and 4 valid, 2 and 3 not valid**review frequency distribution at fice level for 3 (unknown birthdate)*gen vbirth=.replace vbirth=1 if birthdt >=19170000 & birthdt <=20100000 /*valid*/replace vbirth=2 if birthdt <19170000 & birthdt!=0 /*not valid*/replace vbirth=2 if birthdt >20100000 & birthdt!=0 /* not valid*/replace vbirth=3 if birthdt==. /*not valid*/replace vbirth=4 if birthdt==0 /*review*/tab vbirthtab fice vbirth if vbirth>=2 /*not valid or requires review*/*********************************************************************************1 valid, 2 & 3 not valid*gen vmilstat=.replace vmilstat=1 if milstat>=1 & milstat <=5replace vmilstat=2 if milstat==. /*not valid*/replace vmilstat=3 if milstat>5 /*not valid*/replace vmilstat=3 if milstat<1 /*not valid*/tab milstattab vmilstat /*1 is valid, 2 & 3 not valid*/tab fice if vmilstat>=2 /*1 is valid, 2 & 3 not valid*/*********************************************************************************validate last name**1 valid, 2 not valid, 9 missing last name*gen vlast=.replace vlast=1 if lname>="a" |lname>="A" replace vlast=2 if lname==""replace vlast=2 if lname=="."mvencode vlast, mv(9)tab vlasttab fice if vlast==2|vlast==9*validate first name**1 valid, 2 not valid, 9 missing firs tname*gen vfirst=.replace vfirst=1 if fname>="a" |fname>="A" replace vfirst=2 if fname==""replace vfirst=2 if fname=="."mvencode vfirst, mv(9)tab vfirsttab fice if vfirst==2|vfirst==9*validate mname name**1 valid, 2 not valid, 9 missing middle name*gen vmname=.replace vmname=1 if mname>="a" |mname>="A" replace vmname=1 if mname==""replace vmname=2 if mname=="."replace vmname=2 if mname=="-"mvencode vmname, mv(9)tab vmnametab fice if vmname==2|vmname==9*validate suffix name**1 valid, 2 not valid, 9 missing suffix*gen vsuff=.replace vsuff=1 if gsuff=="Jr" |gsuff=="JR" |gsuff=="SR"|gsuff=="Sr"| gsuff=="jr"replace vsuff=1 if gsuff=="Jr." |gsuff=="JR." |gsuff=="SR."|gsuff=="Sr."|gsuff=="sr."replace vsuff=1 if gsuff=="jr" | gsuff=="sr"replace vsuff=1 if gsuff=="II"|gsuff=="ii" | gsuff=="I"|gsuff=="i"|gsuff=="VI"replace vsuff=1 if gsuff=="III"|gsuff=="iii"|gsuff=="IV"|gsuff=="iv"|gsuff=="V"|gsuff=="v"|gsuff=="XI"|gsuff=="X"replace vsuff=1 if gsuff=="3rd"| gsuff=="2nd"| gsuff=="1st"| gsuff=="IX"replace vsuff=1 if gsuff=="Junior"| gsuff=="junior"| gsuff=="jr."| gsuff=="ll" | gsuff=="lll"replace vsuff=1 if gsuff==""replace vsuff=2 if gsuff=="."replace vsuff=2 if gsuff!="" & vsuff!=1mvencode vsuff, mv(9)tab vsufftab fice if vsuff==2|vsuff==9*********************************************************************************first-time flag**1 valid, 2 not valid*gen vftflag=.replace vftflag=1 if firstime>=0 & firstime<=5replace vftflag=2 if firstime<0|firstime>5|firstime==.tab firstimetab vftflagtab fice if vftflag==2*********************************************************************************fsfrez flag**1 valid, 2 not valid, 9 is blank*gen vfsfrez=.replace vfsfrez=1 if fsfrez==1replace vfsfrez=2 if fsfrez >1 & fsfrez !=.replace vfsfrez=2 if fsfrez <1 & fsfrez !=.mvencode vfsfrez, mv(9)tab fsfreztab vfsfreztab fice if vfsfrez==2tab fice if vfsfrez==9*********************************************************************************validate term attendance aka enrollment status - fulltime or parttime**1 valid, 2 not valid*gen vtattend=.replace vtattend=1 if tattend==1replace vtattend=1 if tattend==2replace vtattend=2 if tattend>2replace vtattend=2 if tattend<1tab vtattendtab fice if vtattend==2tab tattend*********************************************************************************validate term level aligns to degree (ugrad 1st, 2nd, 3rd, 4th years or 7 unclassified / grad 5 or 6 or 8=unclassified)**1=correct coding, 2 to 6=incorrect coding when cross reconciling term level against degree sought and firsst time*gen vtlevel=.replace vtlevel=1 if (degree>=10 & degree<=47) & (tlevel==1| tlevel==2| tlevel==3|tlevel==04 | tlevel==7)& firstime!=0 /*ugrad with ugrad*/replace vtlevel=1 if (degree>=50 & degree<=97) & (tlevel==5|tlevel==6|tlevel==8) /*grad with grad*/replace vtlevel=1 if (degree==0 & tlevel==7) /*unknown ugrad*/replace vtlevel=1 if (degree==0 & tlevel==8) /*unknown grad*/replace vtlevel=1 if degree==47 & tlevel==7 & firstime==0 /*dual enrollment*/replace vtlevel=2 if (degree>=10 & degree<=47) & (tlevel==5|tlevel==6|tlevel==8)/*ugrad degree with grad level*/replace vtlevel=3 if (degree>=50 & degree<=97) & (tlevel==1| tlevel==2|tlevel==3|tlevel==4|tlevel==7) /*grad degree with ugrad level*/replace vtlevel=4 if degree==0 & (tlevel==1|tlevel==2|tlevel==3|tlevel==4|tlevel==5|tlevel==6) /*unknown degree with anything but unknown level*/replace vtlevel=5 if tlevel==.replace vtlevel=6 if degree==47 & tlevel!=7 & firstime==0 /*dual enrollment with wrong level*/tab vtleveltab vtlevel if vtlevel!=1tab fice if vtlevel!=1tab fice vtlevel*********************************************************************************term native credit hours attempted**Must not be blank. Warning if 0.00.**review for distributions of 0 and <1*gen vftermcr=.replace vftermcr=1 if tcrhra>=1replace vftermcr=3 if tcrhra==. /*blank when value required*/replace vftermcr=2 if tcrhra==0 /*0 credits*/replace vftermcr=4 if tcrhra<1 & tcrhra>0 /*less than 1 credit but not blank or 0*/tab vftermcrtab fice vftermcr if vftermcr!=1********************************************************************************tab fice if firstime==1|firstime==5*high school code**codes 1 and 3=correct, code 2 & 6 =incorrect, code 4 is blank when value expected*gen vcbsc=.replace vcbsc=1 if firstime==1 & (cbsc>=210000 & cbsc<=219600)replace vcbsc=1 if firstime==5 & (cbsc>=210000 & cbsc<=219600)replace vcbsc=1 if (firstime==2|firstime==3|firstime==4) & cbsc==.replace vcbsc=1 if (firstime==0) & cbsc==.*coding for out of state hs*replace vcbsc=1 if firstime==1 & cbsc<=209999 & cbsc!=.replace vcbsc=1 if firstime==1 & cbsc>=219502 & cbsc!=.replace vcbsc=1 if firstime==5 & cbsc<=209999 & cbsc!=.replace vcbsc=1 if firstime==5 & cbsc>=219502 & cbsc!=.replace vcbsc=2 if (firstime==2|firstime==3|firstime==4) & cbsc!=. /*value when blank expected*/replace vcbsc=4 if firstime==1 & cbsc==. /*blank when value expected*/replace vcbsc=4 if firstime==5 & cbsc==. /*blank when value expected*/replace vcbsc=6 if (firstime==0 & degree==47) & cbsc!=. /*value when blank expected*/tab vcbsctab vcbsc if vcbsc>1tab fice vcbsc if vcbsc>1tab fice if vcbsc==4*check for distributions of unknown HS*gen vcbsc1=.replace vcbsc1=9 if firstime==1 & (cbsc==219100|cbsc==219120|cbsc==219150)replace vcbsc1=9 if firstime==5 & (cbsc==219100|cbsc==219120|cbsc==219150)tab fice vcbsc1*********************************************************************************high school graduation date*/*The four digit year YYYYMMDDIf day is unknown, use YYYYMM00If month and day are unknown, use YYYY0000If all are unknown, use blankReport for first-time Undergraduate students and Undergraduate transfer (First-time flag= 1 or 5)Leave blank for concurrent high school students, continuing undergraduate students,continuing Undergraduate students, and Graduate students (First-time Flag= 0, 2, 3 or 4).*/*estimating valid hs grad year as greater than 1920**1=correct coding, 2 to 6 =incorrect coding) gen vhsgdate=.replace vhsgdate=1 if firstime==1 & hsgyr>=19200000 & hsgyr!=.replace vhsgdate=1 if firstime==5 & hsgyr>=19200000 & hsgyr!=.replace vhsgdate=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & hsgyr==.replace vhsgdate=2 if firstime==1 & hsgyr<=19190000 & hsgyr!=. /*bad date*/replace vhsgdate=2 if firstime==5 & hsgyr<=19190000 & hsgyr!=. /*bad date*/replace vhsgdate=3 if firstime==1 & hsgyr==. /*missing*/replace vhsgdate=4 if firstime==5 & hsgyr==. /*missing*/replace vhsgdate=5 if (firstime==2|firstime==3|firstime==4) & hsgyr!=. /*populated when blank expected*/replace vhsgdate=6 if (firstime==0 & degree==47) & hsgyr!=. /*dual enroll populated when blank expected*/tab vhsgdatetab vhsgdate if vhsgdate!=1tab fice vhsgdate if vhsgdate>1tab fice if vhsgdate==3|vhsgdate==4*********************************************************************************high school gpa*/*Blank if not known or not usedUse a 4.0 scaleReport for first-time undergraduate students or undergraduate transfer students (First-time flag = 1 or 5)Leave blank for concurrent high school students, continuing undergraduate students, and graduate students (First-time Flag= 0, 2, 3 or 4). If the high school uses another scale, convert to 4.0 scale.*/*1 = correct coding, 2 to 6=incorrect coding*gen vhsgpa=.replace vhsgpa=1 if firstime==1 & (hsgpa >=0 & hsgpa <5)replace vhsgpa=1 if firstime==5 & (hsgpa >0 & hsgpa <5)replace vhsgpa=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & hsgpa==.replace vhsgpa=3 if firstime==1 & hsgpa==. /*blank when value expected*/replace vhsgpa=4 if firstime==5 & hsgpa==. /*blank when value expected*/replace vhsgpa=2 if firstime==1 & hsgpa >=5 & hsgpa!=.replace vhsgpa=2 if firstime==1 & hsgpa <.99 & hsgpa!=.replace vhsgpa=2 if firstime==5 & hsgpa >=5 & hsgpa!=.replace vhsgpa=2 if firstime==5 & hsgpa <.99 & hsgpa!=.replace vhsgpa=5 if (firstime==2|firstime==3|firstime==4) & hsgpa!=. /*value when should be blank*/replace vhsgpa=6 if (firstime==0 & degree==47) & hsgpa!=. /*value when should be blank*/tab vhsgpatab vhsgpa if vhsgpa!=1tab fice vhsgpa if vhsgpa>1tab fice if vhsgpa==3|vhsgpa==4*********************************************************************************admissions test flag*/*Report for first-time undergraduate students or undergraduate transfer students (First-time flag = 1 or 5)Leave blank for concurrent high school students, continuing undergraduates students and graduate students (First-time Flag= 0, 2, 3 or 4)*/*code=1 is correct, code = 2 to 7= incorrect* gen vadmfl=.replace vadmfl=1 if firstime==1 & (admfl==0|admfl==1|admfl==2|admfl==3|admfl==4|admfl==5|admfl==6)replace vadmfl=1 if firstime==5 & (admfl==0|admfl==1|admfl==2|admfl==3|admfl==4|admfl==5|admfl==6)replace vadmfl=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & admfl==.replace vadmfl=2 if firstime==1 & admfl >6replace vadmfl=2 if firstime==1 & admfl <0replace vadmfl=3 if firstime==1 & admfl==.replace vadmfl=4 if firstime==5 & admfl >6replace vadmfl=4 if firstime==5 & admfl <0replace vadmfl=5 if firstime==5 & admfl==.replace vadmfl=6 if (firstime==2|firstime==3|firstime==4) & admfl!=.replace vadmfl=7 if (firstime==0&degree==47) & admfl!=.tab admfltab vadmfltab fice vadmfl if vadmfl>1*********************************************************************************admissions exempt flag*/*Only required for first-time undergraduate students. Required only from 4 year public institutions (except UMB, UMUC).blank = not admission exempted student or N/A1 = admission exempted studentReport for first-time undergraduate students (First-time flag = 1)*/*construct control variable for condition*gen applies=.replace applies=1 if segment>=2 & fice!=1164400 & fice!=210400tab appliestab fice if segment>=2tab fice applies*value of 1 = correct, value of 2 & 3=incorrect*gen vexempt=.replace vexempt=1 if firstime==1 & (exempt==1|exempt==.) & applies==1replace vexempt=1 if (firstime==2|firstime==3|firstime==4|firstime==0|firstime==5) & exempt==.replace vexempt=1 if firstime==1 & exempt==. & applies!=1replace vexempt=2 if firstime==1 & exempt<=0replace vexempt=2 if firstime==1 & exempt>=2 & exempt!=.replace vexempt=2 if firstime==1 & exempt==1 & applies!=1replace vexempt=3 if (firstime==2|firstime==3|firstime==4|firstime==0|firstime==5) & exempt!=.tab exempttab vexempttab fice vexempt if vexempt >1*********************************************************************************SAT subject scores between 200 and 800*gen vsatm=.gen vsatv=.gen vsatw=.gen vsatm16=.gen vsatv16=.replace vsatm=1 if (satmath>=200 & satmath<=800)| satmath==. replace vsatv=1 if (satverb>=200 & satverb<=800)| satverb==. replace vsatw=1 if (satwrit>=200 & satwrit<=800) | satwrit==.replace vsatm16=1 if (satmat16>=200 & satmat16<=800) | satmat16==.replace vsatv16=1 if (satebr16>=200 & satebr16<=800) | satebr16==.tab vsatmtab vsatvtab vsatwtab vsatm16tab vsatv16*********************************************************************************act test scores 1 to 36*gen vactm=.gen vacte=.gen vactr=.gen vacts=.gen vactc=.replace vactm=1 if (actmath>=1 & actmath<=36)| actmath==. replace vacte=1 if (actread>=1 & actread<=36)| actread==. replace vactr=1 if (actengl>=1 & actengl<=36) | actengl==.replace vacts=1 if (actscir>=1 & actscir<=36) | actscir==.replace vactc=1 if (actcomp>=1 & actcomp<=36) | actcomp==.tab vactmtab vactetab vactrtab vactstab vactc****************************************************************************************code for students who need a test************gen test=.replace test=1 if admfl==1 /*sat*/replace test=2 if admfl==2 /*act*/replace test=3 if admfl==3 /*sat or act*/replace test=4 if admfl>3 /*test but not ACT/SAT*/replace test=4 if admfl==0 /*no test*/replace test=4 if admfl==. /*someone who doesn't get tested*/tab testtab test if test!=4*sum all values across all test to determine if any test scores are present*egen gottest = rowtotal(satmath satverb satwrit actmath actengl actread actscir actcomp satmat16 satebr16)tab fice if gottest!=0tab fice if test==4 & gottest!=0 /*don't need test and have one*/tab fice if test!=4 & gottest==0 /*need test and don't have one*/tab fice if test!=4 & gottest==0 & exempt!=1 /*need test and don't have one and not exempt*/*********************************************************************************has ACT/SAT and should not*/*Either SAT or ACT required for first-time undergraduate students and undergraduate transfer students (first-time flag set to 1 or 5).*/gen notest=.replace notest=2 if firstime==2 & ///(satmath!=.|satverb!=.|satwrit!=.|actmath!=.|actengl!=.|actread!=.|actscir!=.|actcomp!=.) /*don't need test and have one*/replace notest=1 if firstime==2 & ///(satmath==.&satverb==.&satwrit==.&actmath==.&actengl==.&actread==.&actscir==.&actcomp==.) /*don't need test and don't have one*/ replace notest=2 if firstime==0 & ///(satmath!=.|satverb!=.|satwrit!=.|actmath!=.|actengl!=.|actread!=.|actscir!=.|actcomp!=.) /*don't need test and have one*/replace notest=1 if firstime==0 & ///(satmath==.&satverb==.&satwrit==.&actmath==.&actengl==.&actread==.&actscir==.&actcomp==.)/*don't need test and don't have one*/ replace notest=2 if firstime==3 & ///(satmath!=.|satverb!=.|satwrit!=.|actmath!=.|actengl!=.|actread!=.|actscir!=.|actcomp!=.) /*don't need test and have one*/replace notest=1 if firstime==3 & ///(satmath==.&satverb==.&satwrit==.&actmath==.&actengl==.&actread==.&actscir==.&actcomp==.)/*don't need test and don't have one*/ replace notest=2 if firstime==4 & ///(satmath!=.|satverb!=.|satwrit!=.|actmath!=.|actengl!=.|actread!=.|actscir!=.|actcomp!=.) /*don't need test and have one*/replace notest=1 if firstime==4 & ///(satmath==.&satverb==.&satwrit==.&actmath==.&actengl==.&actread==.&actscir==.&actcomp==.)/*don't need test and don't have one*/replace notest=3 if firstime==1|firstime==5 /*these are evaluated above for testing*/tab notesttab fice notest if notest==2********************************************************************************/*for all remedial testing*//*Report for first-time undergraduate students or undergraduate transfer students (First-time flag = 1 or 5)*//*1=correct code, 2 & 3 = blanks when value expected but blank allowed, 4 & 5 = value populated when blank expected, 6=bad value entered*/*math remedial*gen vremm=.replace vremm=1 if firstime==1 & (mathra>=1 & mathra<=3)replace vremm=1 if firstime==5 & (mathra>=1 & mathra<=3)replace vremm=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & mathra==.replace vremm=2 if firstime==1 & mathra==.replace vremm=3 if firstime==5 & mathra==.replace vremm=4 if (firstime==2|firstime==3|firstime==4) & mathra!=.replace vremm=5 if (firstime==0 & degree==47) & mathra!=.replace vremm=6 if firstime==1 & mathra<1 & mathra!=.replace vremm=6 if firstime==5 & mathra<1 & mathra!=. replace vremm=6 if firstime==1 & mathra>3 & mathra!=.replace vremm=6 if firstime==5 & mathra>3 & mathra!=.tab vremmtab vremm if vremm==2|vremm==3*english remedial*gen vreme=.replace vreme=1 if firstime==1 & (englra>=1 & englra<=3)replace vreme=1 if firstime==5 & (englra>=1 & englra<=3)replace vreme=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & englra==.replace vreme=2 if firstime==1 & englra==.replace vreme=3 if firstime==5 & englra==.replace vreme=4 if (firstime==2|firstime==3|firstime==4) & englra!=.replace vreme=5 if (firstime==0 & degree==47) & englra!=.replace vreme=6 if firstime==1 & englra<1 & englra!=.replace vreme=6 if firstime==5 & englra<1 & englra!=.replace vreme=6 if firstime==1 & englra>3 & englra!=.replace vreme=6 if firstime==5 & englra>3 & englra!=.tab vremetab vreme if vreme==2|vreme==3*reading remedial*gen vremr=.replace vremr=1 if firstime==1 & (readra>=1 & readra<=3)replace vremr=1 if firstime==5 & (readra>=1 & readra<=3)replace vremr=1 if (firstime==2|firstime==3|firstime==4|firstime==0) & readra==.replace vremr=2 if firstime==1 & readra==.replace vremr=3 if firstime==5 & readra==.replace vremr=4 if (firstime==2|firstime==3|firstime==4) & readra!=.replace vremr=5 if (firstime==0 & degree==47) & readra!=.replace vremr=6 if firstime==1 & readra<1 & readra!=.replace vremr=6 if firstime==5 & readra<1 & readra!=.replace vremr=6 if firstime==1 & readra>3 & readra!=.replace vremr=6 if firstime==5 & readra>3 & readra!=.tab vremrtab vremr if vremr==2|vremr==3tab vremmtab fice vremm if vremm!=1table fice vremm if vremm==2|vremm==3tab vremetab fice vreme if vreme!=1table fice vreme if vreme==2|vreme==3tab vremrtab fice vremr if vremr!=1table fice vremr if vremr==2|vremr==3*********************************************************************************Program Taxonomy*valid program taxomony*/*program taxonomy is 4 digits; however, leading 0 is dropped so validate all leading 0 pt as 3 digit codes; excel truncates last two digits from cell so the 3 remaining are 0### even though 0 is not in cell*/*step 1: convert to string*rename program program_origtostring program_orig, gen(ptax)*step 2: parse code to remove last two digits from ptax to retain only first 3 or 4 of program taxonomy**so, start with the first number and keep 2 digits*gen program_taxonomy=substr(ptax, 1, length(ptax)-2)*finally, destring to reinstate numbers for validation both degree code and program taxonomy*destring program_taxonomy, replacegen vtax=.replace vtax=1 if program_taxonomy==100 |program_taxonomy==101 | program_taxonomy==102 | program_taxonomy==103 | program_taxonomy==104 | program_taxonomy==105 | program_taxonomy==106 | ///program_taxonomy==107 | program_taxonomy==108 | program_taxonomy==109 | program_taxonomy==110 | program_taxonomy==111 | program_taxonomy==112 | program_taxonomy==113 | ///program_taxonomy==114 | program_taxonomy==115 | program_taxonomy==116 | program_taxonomy==117 | program_taxonomy==199 | ///program_taxonomy==200 | program_taxonomy==201 | program_taxonomy==202 | program_taxonomy==203 | program_taxonomy==204 | program_taxonomy==205 | program_taxonomy==206 | program_taxonomy==299 | ///program_taxonomy==300 | program_taxonomy==301 | program_taxonomy==302 | program_taxonomy==303 | program_taxonomy==304 | program_taxonomy==305 | program_taxonomy==306 | program_taxonomy==307 | ///program_taxonomy==308 | program_taxonomy==309 | program_taxonomy==310 | program_taxonomy==311 | program_taxonomy==312 | program_taxonomy==313 | program_taxonomy==314 | program_taxonomy==399 | ///program_taxonomy==400 | program_taxonomy==401 | program_taxonomy==402 | program_taxonomy==403 | program_taxonomy==404 | program_taxonomy==405 | program_taxonomy==406 | program_taxonomy==407 | ///program_taxonomy==408 | program_taxonomy==409 | program_taxonomy==410 | program_taxonomy==411 | program_taxonomy==412 | program_taxonomy==413 | program_taxonomy==414 | program_taxonomy==415 | ///program_taxonomy==416 | program_taxonomy==417 | program_taxonomy==418 | program_taxonomy==419 | program_taxonomy==420 | program_taxonomy==421 | program_taxonomy==422 | program_taxonomy==423 | ///program_taxonomy==424 | program_taxonomy==425 | program_taxonomy==426 | program_taxonomy==427 | program_taxonomy==499 | ///program_taxonomy==500 | program_taxonomy==501 | program_taxonomy==502 | program_taxonomy==503 | program_taxonomy==504 | program_taxonomy==505 | program_taxonomy==506 | program_taxonomy==507replace vtax=1 if program_taxonomy==508 | program_taxonomy==509 | program_taxonomy==510 | program_taxonomy==511 | program_taxonomy==512 | program_taxonomy==513 | program_taxonomy==514 | program_taxonomy==515 | ///program_taxonomy==516 | program_taxonomy==517 | program_taxonomy==599 | ///program_taxonomy==600 | program_taxonomy==601 | program_taxonomy==602 | program_taxonomy==603 | program_taxonomy==604 | program_taxonomy==605 | program_taxonomy==699 | ///program_taxonomy==700 | program_taxonomy==701 | program_taxonomy==702 | program_taxonomy==703 | program_taxonomy==704 | program_taxonomy==705 | program_taxonomy==799 | ///program_taxonomy==800 |program_taxonomy==801 | program_taxonomy==802 | program_taxonomy==803 | program_taxonomy==804 | ///program_taxonomy==805 | program_taxonomy==806 | program_taxonomy==807 | program_taxonomy==808 | ///program_taxonomy==809 | program_taxonomy==810 | program_taxonomy==811 | ///program_taxonomy==812 | program_taxonomy==813 | program_taxonomy==814 | program_taxonomy==815 | ///program_taxonomy==816 | program_taxonomy==817 | program_taxonomy==818 | program_taxonomy==819 | ///program_taxonomy==820 | program_taxonomy==821 | program_taxonomy==822 | program_taxonomy==823 | program_taxonomy==824 | ///program_taxonomy==825 | program_taxonomy==826 | program_taxonomy==827 | program_taxonomy==828 | ///program_taxonomy==829 | program_taxonomy==830 | program_taxonomy==831 | program_taxonomy==832 | ///program_taxonomy==833 | program_taxonomy==834 | program_taxonomy==835 | program_taxonomy==836 | ///program_taxonomy==837 | program_taxonomy==838 | program_taxonomy==839 | program_taxonomy==899 replace vtax=1 if program_taxonomy==900 |program_taxonomy==901 | program_taxonomy==902 | ///program_taxonomy==903 | program_taxonomy==904 | program_taxonomy==905 | program_taxonomy==906 | ///program_taxonomy==907 | program_taxonomy==908 | program_taxonomy==909 | program_taxonomy==910 | ///program_taxonomy==911 | program_taxonomy==912 | program_taxonomy==913 | program_taxonomy==914 | ///program_taxonomy==915 | program_taxonomy==916 | program_taxonomy==917 | program_taxonomy==918 | ///program_taxonomy==919 | program_taxonomy==920 | program_taxonomy==921 | program_taxonomy==922 | ///program_taxonomy==923 | program_taxonomy==924 | program_taxonomy==925 | program_taxonomy==999 | ///program_taxonomy==1000 |program_taxonomy==1001 | program_taxonomy==1002 | program_taxonomy==1003 | program_taxonomy==1004 | ///program_taxonomy==1005 | program_taxonomy==1006 | program_taxonomy==1007 | program_taxonomy==1008 | ///program_taxonomy==1009 | program_taxonomy==1010 | program_taxonomy==1011 | program_taxonomy==1099replace vtax=1 if program_taxonomy==1100 |program_taxonomy==1101 | program_taxonomy==1102 | ///program_taxonomy==1103 | program_taxonomy==1104 | program_taxonomy==1105 | program_taxonomy==1106 | ///program_taxonomy==1107 | program_taxonomy==1108 | program_taxonomy==1109 | program_taxonomy==1110 | ///program_taxonomy==1111 | program_taxonomy==1112 | program_taxonomy==1113 | ///program_taxonomy==1114 | program_taxonomy==1115 | program_taxonomy==1116 | program_taxonomy==1199 | program_taxonomy==1201 | ///program_taxonomy==1200 |program_taxonomy==1202 | program_taxonomy==1203 | program_taxonomy==1204 | program_taxonomy==1205 | program_taxonomy==1206 | ///program_taxonomy==1207 | program_taxonomy==1208 | program_taxonomy==1209 | program_taxonomy==1210 | ///program_taxonomy==1211 | program_taxonomy==1212 | program_taxonomy==1213 | program_taxonomy==1214 | ///program_taxonomy==1215 | program_taxonomy==1216 | program_taxonomy==1217 | program_taxonomy==1218 | ///program_taxonomy==1219 | program_taxonomy==1220 | program_taxonomy==1221 | program_taxonomy==1222 | ///program_taxonomy==1223 | program_taxonomy==1224 | program_taxonomy==1225 | program_taxonomy==1299 | ///program_taxonomy==1300 |program_taxonomy==1301 | program_taxonomy==1302 | program_taxonomy==1303 | program_taxonomy==1304 | ///program_taxonomy==1305 | program_taxonomy==1306 | program_taxonomy==1307 | program_taxonomy==1399replace vtax=1 if program_taxonomy==1400 |program_taxonomy==1401 | program_taxonomy==1499 | ///program_taxonomy==1500 |program_taxonomy==1501 | program_taxonomy==1502 | program_taxonomy==1503 | ///program_taxonomy==1504 | program_taxonomy==1505 | program_taxonomy==1506 | program_taxonomy==1507 | ///program_taxonomy==1508 | program_taxonomy==1509 | program_taxonomy==1510 | program_taxonomy==1599 | ///program_taxonomy==1600 |program_taxonomy==1601 | program_taxonomy==1699 | ///program_taxonomy==1700 |program_taxonomy==1701 | program_taxonomy==1702 | program_taxonomy==1703 | program_taxonomy==1799 | ///program_taxonomy==1800 |program_taxonomy==1801 | program_taxonomy==1802 | program_taxonomy==1803 | program_taxonomy==1899replace vtax=1 if program_taxonomy==1900 |program_taxonomy==1901 | program_taxonomy==1902 | program_taxonomy==1903 | program_taxonomy==1904 | program_taxonomy==1905 | ///program_taxonomy==1906 | program_taxonomy==1907 | program_taxonomy==1908 | program_taxonomy==1909 | ///program_taxonomy==1910 | program_taxonomy==1911 | program_taxonomy==1912 | program_taxonomy==1913 | ///program_taxonomy==1914 | program_taxonomy==1915 | program_taxonomy==1916 | program_taxonomy==1917 | ///program_taxonomy==1918 | program_taxonomy==1919 | program_taxonomy==1920 | program_taxonomy==1999 | ///program_taxonomy==2000 |program_taxonomy==2001 | program_taxonomy==2002 | program_taxonomy==2003 | ///program_taxonomy==2004 | program_taxonomy==2005 | program_taxonomy==2006 | program_taxonomy==2007 | ///program_taxonomy==2008 | program_taxonomy==2009 | program_taxonomy==2010 | program_taxonomy==2099 | ///program_taxonomy==2100 |program_taxonomy==2101 | program_taxonomy==2102 | program_taxonomy==2103 | ///program_taxonomy==2104 | program_taxonomy==2105 | program_taxonomy==2106 | program_taxonomy==2199replace vtax=1 if program_taxonomy==2200 |program_taxonomy==2201 | program_taxonomy==2202 | program_taxonomy==2203 | program_taxonomy==2204 | ///program_taxonomy==2205 | program_taxonomy==2206 | program_taxonomy==2207 | program_taxonomy==2208 | ///program_taxonomy==2209 | program_taxonomy==2210 | program_taxonomy==2211 | program_taxonomy==2212 | ///program_taxonomy==2213 | program_taxonomy==2214 | program_taxonomy==2215 | program_taxonomy==2299 | program_taxonomy==2301 | ///program_taxonomy==2300 |program_taxonomy==2302 | program_taxonomy==2303 | program_taxonomy==2304 | program_taxonomy==2399replace vtax=1 if program_taxonomy==4900 |program_taxonomy==4901 | program_taxonomy==4902 | program_taxonomy==4903 | program_taxonomy==4904 | program_taxonomy==4910 | ///program_taxonomy==4920 | program_taxonomy==4930 | program_taxonomy==4940 | program_taxonomy==4950 | ///program_taxonomy==4960 | program_taxonomy==4970 | program_taxonomy==4980 | program_taxonomy==4999 | ///program_taxonomy==5000 |program_taxonomy==5001 | program_taxonomy==5002 | program_taxonomy==5003 | ///program_taxonomy==5004 | program_taxonomy==5005 | program_taxonomy==5006 | program_taxonomy==5007 | program_taxonomy==5008 | ///program_taxonomy==5009 | program_taxonomy==5010 | program_taxonomy==5011 | program_taxonomy==5012 | program_taxonomy==5099replace vtax=1 if program_taxonomy==5100 |program_taxonomy==5101 | program_taxonomy==5102 | ///program_taxonomy==5103 | program_taxonomy==5104 | program_taxonomy==5105 | program_taxonomy==5199 | ///program_taxonomy==5200 |program_taxonomy==5201 | program_taxonomy==5202 | ///program_taxonomy==5203 | program_taxonomy==5204 | program_taxonomy==5205 | program_taxonomy==5206 | ///program_taxonomy==5207 | program_taxonomy==5208 | program_taxonomy==5209 | program_taxonomy==5210 | ///program_taxonomy==5211 | program_taxonomy==5212 | program_taxonomy==5213 | program_taxonomy==5214 | program_taxonomy==5215 | ///program_taxonomy==5216 | program_taxonomy==5217 | program_taxonomy==5218 | program_taxonomy==5219 | program_taxonomy==5299replace vtax=1 if program_taxonomy==5300 |program_taxonomy==5301 | program_taxonomy==5302 | program_taxonomy==5303 | ///program_taxonomy==5304 | program_taxonomy==5305 | program_taxonomy==5306 | program_taxonomy==5307 | program_taxonomy==5308 | ///program_taxonomy==5309 | program_taxonomy==5310 | program_taxonomy==5311 | program_taxonomy==5312 | program_taxonomy==5313 | ///program_taxonomy==5314 | program_taxonomy==5315 | program_taxonomy==5316 | program_taxonomy==5317 | program_taxonomy==5399 | ///program_taxonomy==5400 |program_taxonomy==5401 | program_taxonomy==5402 | program_taxonomy==5403 | program_taxonomy==5404 | ///program_taxonomy==5405 | program_taxonomy==5406 | program_taxonomy==5407 | program_taxonomy==5408 | program_taxonomy==5499 | ///program_taxonomy==5501 | program_taxonomy==5502 | program_taxonomy==5503 | program_taxonomy==5292 | ///program_taxonomy==5504 | program_taxonomy==5505 | program_taxonomy==5506 | program_taxonomy==5507 | program_taxonomy==5508 | program_taxonomy==5599 | program_taxonomy==5601 | program_taxonomy==9099replace vtax=2 if (program_taxonomy>=118 | program_taxonomy<=198)& ///(program_taxonomy>=207 | program_taxonomy<=298)&(program_taxonomy>=315 | program_taxonomy<=398)&(program_taxonomy>=428 | program_taxonomy<=498) & ///(program_taxonomy>=518 | program_taxonomy<=598) &(program_taxonomy>=606 | program_taxonomy<=698) &(program_taxonomy>=706 | program_taxonomy<=798) & ///(program_taxonomy>=840 | program_taxonomy<=898) & (program_taxonomy>=926 | program_taxonomy<=998) &(program_taxonomy>=1012 | program_taxonomy<=1098) & ///(program_taxonomy>= 1117 | program_taxonomy<=1198) &(program_taxonomy>=1226 | program_taxonomy<=1298) &(program_taxonomy>=1308 | program_taxonomy<=1398) & ///(program_taxonomy>=1402 | program_taxonomy<=1498) &(program_taxonomy>=1511 | program_taxonomy<=1598) &(program_taxonomy>=1602 | program_taxonomy<=1698) & ///(program_taxonomy>=1704 | program_taxonomy<=1798) &(program_taxonomy>=1804 | program_taxonomy<=1898) &(program_taxonomy>=1921 | program_taxonomy<=1998) & ///(program_taxonomy>=2011 | program_taxonomy<=2098) &(program_taxonomy>=2107 | program_taxonomy<=2198) &(program_taxonomy>=2216 | program_taxonomy<=2298) & ///(program_taxonomy>=2305 | program_taxonomy<=2398) &(program_taxonomy>=4981 | program_taxonomy<=4998) &(program_taxonomy>=5013 | program_taxonomy<=5098) & ///(program_taxonomy>=5106 | program_taxonomy<=5198) &(program_taxonomy>=5120 | program_taxonomy<=5298) &(program_taxonomy>=5318 | program_taxonomy<=5398) & ///(program_taxonomy>=5409 | program_taxonomy<=5498) &(program_taxonomy>=5509 | program_taxonomy<=5598) &(program_taxonomy>=5602 | program_taxonomy<=9098) & program_taxonomy>=9100 mvencode vtax, mv(9)tab vtaxtab fice vtax if vtax==2tab fice program_taxonomy if vtax==9tab fice program_taxonomy if vtax==2*********************************************************************************degree sought****valid degree sought for EIS**test degree code against firstime code**1=correct, 2=incorrect*gen vdegree=.replace vdegree=1 if (degree==10 | degree==20 | degree==30 | degree==40) & (firstime==1|firstime==2|firstime==5) replace vdegree=1 if (degree==50 | degree==60| degree== 65|degree== 70) & (firstime==3| firstime==4)replace vdegree=1 if (degree==81| degree==85| degree==86|degree==87 ) & (firstime==3| firstime==4)replace vdegree=1 if firstime==0 & degree==47replace vdegree=1 if (firstime==1|firstime==2|firstime==5) & degree==47replace vdegree=1 if degree==0replace vdegree=2 if degree ==.replace vdegree=2 if firstime==0 & degree!=47 replace vdegree=2 if (firstime==3|firstime==4) & degree==47replace vdegree=2 if (degree==10 | degree==20 | degree==30 | degree==40) & (firstime==3| firstime==4) replace vdegree=2 if (degree==50 | degree==60| degree== 65|degree== 70) & (firstime==1|firstime==2|firstime==5|firstime==0)replace vdegree=2 if (degree==81| degree==85| degree==86|degree==87) & (firstime==1|firstime==2|firstime==5|firstime==0) tab vdegreetab fice vdegree if vdegree!=1tab fice if vdegree==2 & (firstime==3| firstime==4) tab fice if vdegree==2 & (firstime==1|firstime==2|firstime==5) tab fice if vdegree==2 & firstime==0tab fice if vdegree==2 & degree==.tab fice degree if vdegree==2 & (firstime==3| firstime==4) tab fice degree if vdegree==2 & (firstime==1|firstime==2|firstime==5) tab fice degree if vdegree==2 & firstime==0tab fice degree if vdegree==2 & degree==.*********************************************************************************Distance Education*1=correct, 2=incorrect*gen vdisted=.replace vdisted=1 if decrse==1|decrse==2|decrse==3replace vdisted=2 if decrse==0| decrse>=4| decrse==.tab vdistedtab fice if vdisted==2*do distance ed students have a location**report only for decrse==1**1=correct, 2=incorrect*gen vdeloc=.mvencode deloc, mv(9)replace vdeloc=1 if decrse==1 & (deloc==1 | deloc==2| deloc==3 |deloc==4)replace vdeloc=1 if decrse==2 & deloc==9replace vdeloc=1 if decrse==3 & deloc==9 replace vdeloc=1 if decrse==4 & deloc==9replace vdeloc=2 if decrse>1 & deloc!=9replace vdeloc=3 if decrse==1 & deloc==9 /*"blank" for decrse=1 is not valid*/tab vdeloctab fice if vdeloc==3tab deloc *tab for bad values*tab deloc if vdeloc==2tab fice if vdeloc==2*********************************************************************************zip codes*format %05.0f apzipcd*lowest possible zip code is 00501 and highest is 99950*gen vapzipcd=.replace vapzipcd=1 if apzipcd>=00501 & apzipcd<=99950replace vapzipcd=3 if apzipcd==00000replace vapzipcd=2 if (apzipcd>99950 & apzipcd<99999)replace vapzipcd=2 if apzipcd<00501 & apzipcd!=0replace vapzipcd=4 if apzipcd==99999tab vapzipcdtab vapzipcd if vapzipcd>1tab fice vapzipcd if vapzipcd>1tab fice vapzipcd if (vapzipcd==3 | vapzipcd==4) & citizen==1 /*00000 or 99999*/tab fice vapzipcd if (vapzipcd==3 | vapzipcd==4) & (georg >100 & georg <=224) /*00000 or 99999*/tab fice vapzipcdtab fice vapzipcd if citizen==1 /*00000 or 99999*/tab fice vapzipcd if(georg >100 & georg <=224) /*00000 or 99999*/format %04.0f apzip4gen vapzip4=.replace vapzip4=1 if apzip4>=1 & apzip4<=9999replace vapzip4=1 if apzip4==0replace vapzip4=1 if apzip4==.replace vapzip4=2 if apzip4>9999 & apzip4!=.replace vapzip4=2 if apzip4<1 & apzip4!=.tab vapzip4tab fice if vapzip4==2********************************************************************************format %05.0f curzipcdgen vcurzipcd=.replace vcurzipcd=1 if curzipcd>=00501 & curzipcd<=99950replace vcurzipcd=3 if curzipcd==00000replace vcurzipcd=4 if curzipcd==99999replace vcurzipcd=2 if (curzipcd>99950 & curzipcd<99999)replace vcurzipcd=2 if curzipcd<00501 & curzipcd!=0tab vcurzipcdtab vcurzipcd if vcurzipcd!=1tab fice vcurzipcd if vcurzipcd==2 | vcurzipcd==3 | vcurzipcd==4tab fice vcurzipcd if (vcurzipcd==3 | vcurzipcd==4) & citizen==1tab fice vcurzipcd if (vcurzipcd==3 | vcurzipcd==4) & (georg >100 & georg <=224)tab fice vcurzipcd tab fice vcurzipcd if citizen==1tab fice vcurzipcd if(georg >100 & georg <=224)format %04.0f curzip4gen vcurzip4=.replace vcurzip4=1 if curzip4>=1 & curzip4<=9999replace vcurzip4=1 if curzip4==0replace vcurzip4=1 if curzip4==.replace vcurzip4=2 if curzip4>9999 & curzip4!=.replace vcurzip4=2 if curzip4<1 &curzip4!=.tab vcurzip4tab fice if vcurzip4==2*********************************************************************************geographic orgin**001 - foreign, 100 - unknown US state, 101-199, 200- maryland unknown count, 201-224, 000- unknown**note if many 001, 100*format %03.0f georggen vgeorg=.replace vgeorg=1 if georg==1replace vgeorg=3 if georg==100replace vgeorg=4 if georg==0replace vgeorg=5 if georg==200replace vgeorg=6 if georg>200 & georg<=224replace vgeorg=7 if georg>100 & georg<=199replace vgeorg=2 if georg==.|georg>224|georg<0tab vgeorgtab fice if vgeorg==3 /*100 - unknown US state*/tab fice if vgeorg==4 /*unknown*/tab fice if vgeorg==5 /*Unknown MD county*/tab fice if vgeorg==2 /*value out of range*/tab fice if vgeorg==3|vgeorg==4table fice vgeorg*********************************************************************************mdresidency code**1=correct, 2=incorrect*gen vmdres=.replace vmdres=1 if mdres==1|mdres==2replace vmdres=2 if mdres>2replace vmdres=2 if mdres==.replace vmdres=2 if mdres<1tab vmdrestab fice if vmdres==2*********************************************************************************tuition status**1=correct, 2=incorrect*gen vtstatus=.replace vtstatus=1 if tstatus >=1 & tstatus <=5replace vtstatus=2 if tstatus==.|tstatus<1|tstatus>5tab vtstatus*correctly applied for tuition status 1 and 4*gen tuse=.replace tuse=1 if tstatus==4 & (sector==2|fice==1164400)replace tuse=1 if tstatus==1 & segment==1replace tuse=2 if tstatus==4 & (sector!=2&fice!=1164400)replace tuse=2 if tstatus==1 & segment!=1tab tusetab fice tusetab tstatus segment*********************************************************************************valid ID Type, valid 1, invalid 2*gen vtype=.replace vtype = 1 if idt ==1 | idt==2| idt==3replace vtype = 2 if idt !=1 & idt !=2 & idt!=3 & idt !=.tab vtype/*validate IDN1 is idn with 9 characters, 2 is idn with 8 characters which may mean leading 0 is missing,3 is idn with 10 or more characters, 4 is idn with 7 or fewer characters*/ gen vssn =idntostring vssn, replacegen vssn2=.replace vssn2=1 if strlen(vssn)==9replace vssn2=2 if strlen(vssn)==8replace vssn2=3 if strlen(vssn)>=10 /*>= 10*/replace vssn2=4 if strlen(vssn)<=7 /*<= 7*/tab vssn2tab vssn2 if vssn2>1*validate against id type*tab vssn2 idttab vssn2 if idt==1 & (vssn2==3|vssn2==4)tab fice if idt==1 & (vssn2==3|vssn2==4)*validate TSSN*gen vtssn=.replace vtssn=2 if strlen(tssn)>10replace vtssn=2 if strlen(tssn)<10replace vtssn=1 if strlen(tssn)==10tab vtssn*********************************************************************************valid campusID 1 valid, 2 not valid*gen vcamp=.replace vcamp=2 if strlen(tssn)>=11replace vcamp=1 if strlen(tssn)<=10replace vcamp=1 if strlen(tssn)==10tab vcamp*********************************************************************************valid SASID*, 9 blank, 1 valid, 2 not validmvencode sasid, mv(9)gen vsasid=.replace vsasid=1 if sasid ==.replace vsasid=1 if sasid >=1000000000replace vsasid=2 if sasid <=99999999 & sasid >9replace vsasid=9 if sasid==9tab vsasidtab fice if vsasid==2tab fice if sasid==9*validating sending opeid*gen vsending_opeid=.replace vsending_opeid=1 if firstime==5 & (sending_opeid==100200| ///sending_opeid==100300|sending_opeid==100400|sending_opeid==100500| ///sending_opeid==100700|sending_opeid==100800|sending_opeid==100900| ///sending_opeid==101200|sending_opeid==101300|sending_opeid==101500| ///sending_opeid==101600| ///sending_opeid==101700| ///sending_opeid==101800| ///sending_opeid==101900| ///sending_opeid==102000| ///sending_opeid==102100| ///sending_opeid==102200| ///sending_opeid==102300| ///sending_opeid==102400| ///sending_opeid==102600| ///sending_opeid==102800| ///sending_opeid==102900| ///sending_opeid==103000| ///sending_opeid==103100| ///sending_opeid==103300| ///sending_opeid==103400| ///sending_opeid==103600| ///sending_opeid==103800| ///sending_opeid==104000| ///sending_opeid==104100| ///sending_opeid==104400| ///sending_opeid==104600| ///sending_opeid==104700| ///sending_opeid==105000| ///sending_opeid==105100| ///sending_opeid==105200| ///sending_opeid==105500| ///sending_opeid==105700| ///sending_opeid==106000| ///sending_opeid==106100| ///sending_opeid==106200| ///sending_opeid==106300| ///sending_opeid==106500| ///sending_opeid==107000| ///sending_opeid==107100| ///sending_opeid==107200| ///sending_opeid==107300| ///sending_opeid==107400| ///sending_opeid==107500| ///sending_opeid==107600| ///sending_opeid==107700| ///sending_opeid==107800| ///sending_opeid==107900| ///sending_opeid==108100| ///sending_opeid==108200| ///sending_opeid==108300| ///sending_opeid==108500| ///sending_opeid==108600| ///sending_opeid==108700| ///sending_opeid==108800| ///sending_opeid==108900| ///sending_opeid==108906| ///sending_opeid==109000| ///sending_opeid==109003| ///sending_opeid==109100| ///sending_opeid==109200| ///sending_opeid==109300| ///sending_opeid==109400| ///sending_opeid==109500| ///sending_opeid==109700| ///sending_opeid==109800| ///sending_opeid==109900| ///sending_opeid==110000| ///sending_opeid==110100| ///sending_opeid==110200| ///sending_opeid==110300| ///sending_opeid==110400| ///sending_opeid==110500| ///sending_opeid==110600| ///sending_opeid==110700| ///sending_opeid==110800| ///sending_opeid==110900| ///sending_opeid==111000| ///sending_opeid==111100| ///sending_opeid==111300| ///sending_opeid==111600| ///sending_opeid==111700| ///sending_opeid==111700| ///sending_opeid==111800| ///sending_opeid==111900| ///sending_opeid==112000| ///sending_opeid==112100| ///sending_opeid==112200| ///sending_opeid==112400| ///sending_opeid==112500| ///sending_opeid==112700| ///sending_opeid==113100| ///sending_opeid==113200| ///sending_opeid==113300| ///sending_opeid==113400| ///sending_opeid==113700| ///sending_opeid==113800| ///sending_opeid==113900| ///sending_opeid==114000| ///sending_opeid==114100| ///sending_opeid==114200| ///sending_opeid==114300| ///sending_opeid==114400| ///sending_opeid==114600| ///sending_opeid==114700| ///sending_opeid==114900| ///sending_opeid==115000| ///sending_opeid==115100| ///sending_opeid==115101| ///sending_opeid==115300| ///sending_opeid==115400| ///sending_opeid==115500| ///sending_opeid==115600| ///sending_opeid==115700| ///sending_opeid==116100| ///sending_opeid==116200| ///sending_opeid==116300| ///sending_opeid==116400| ///sending_opeid==116500| ///sending_opeid==116600| ///sending_opeid==116900| ///sending_opeid==117000| ///sending_opeid==117100| ///sending_opeid==117200| ///sending_opeid==117300| ///sending_opeid==117400| ///sending_opeid==117600| ///sending_opeid==117700| ///sending_opeid==117800| ///sending_opeid==117900| ///sending_opeid==118100| ///sending_opeid==118200| ///sending_opeid==118300| ///sending_opeid==118500| ///sending_opeid==118600| ///sending_opeid==118700| ///sending_opeid==119000| ///sending_opeid==119100| ///sending_opeid==119200| ///sending_opeid==119300| ///sending_opeid==119600| ///sending_opeid==119700| ///sending_opeid==119701| ///sending_opeid==119900| ///sending_opeid==120000| ///sending_opeid==120100| ///sending_opeid==120200| ///sending_opeid==120300| ///sending_opeid==120400| ///sending_opeid==120500| ///sending_opeid==120600| ///sending_opeid==120700| ///sending_opeid==120800| ///sending_opeid==120900| ///sending_opeid==121200| ///sending_opeid==121400| ///sending_opeid==121500| ///sending_opeid==121600| ///sending_opeid==121700| ///sending_opeid==121800| ///sending_opeid==121900| ///sending_opeid==122000| ///sending_opeid==122300| ///sending_opeid==122400| ///sending_opeid==122600| ///sending_opeid==122700| ///sending_opeid==122800| ///sending_opeid==122900| ///sending_opeid==123000| ///sending_opeid==123200| ///sending_opeid==123300| ///sending_opeid==123600| ///sending_opeid==123700| ///sending_opeid==123800| ///sending_opeid==123900| ///sending_opeid==124000| ///sending_opeid==124200| ///sending_opeid==124300| ///sending_opeid==124500| ///sending_opeid==124600| ///sending_opeid==124700| ///sending_opeid==124900| ///sending_opeid==125000| ///sending_opeid==125100| ///sending_opeid==125200| ///sending_opeid==125300| ///sending_opeid==125500| ///sending_opeid==125600| ///sending_opeid==125800| ///sending_opeid==125900| ///sending_opeid==126000| ///sending_opeid==126100| ///sending_opeid==126200| ///sending_opeid==126600| ///sending_opeid==126700| ///sending_opeid==126800| ///sending_opeid==126900| ///sending_opeid==127000| ///sending_opeid==127200| ///sending_opeid==127300| ///sending_opeid==127500| ///sending_opeid==127800| ///sending_opeid==127900| ///sending_opeid==128000| ///sending_opeid==128100| ///sending_opeid==128200| ///sending_opeid==128400| ///sending_opeid==128500| ///sending_opeid==128600| ///sending_opeid==128700| ///sending_opeid==128800| ///sending_opeid==128900| ///sending_opeid==129000| ///sending_opeid==129100| ///sending_opeid==129200| ///sending_opeid==129300| ///sending_opeid==129400| ///sending_opeid==129500| ///sending_opeid==129600| ///sending_opeid==129900| ///sending_opeid==130200| ///sending_opeid==130500| ///sending_opeid==130600| ///sending_opeid==130700| ///sending_opeid==130800| ///sending_opeid==130900| ///sending_opeid==131000| ///sending_opeid==131200| ///sending_opeid==131300| ///sending_opeid==131400| ///sending_opeid==131500| ///sending_opeid==131600| ///sending_opeid==131700| ///sending_opeid==131900| ///sending_opeid==132000| ///sending_opeid==132100| ///sending_opeid==132200| ///sending_opeid==132500| ///sending_opeid==132600| ///sending_opeid==132800| ///sending_opeid==132900| ///sending_opeid==133400| ///sending_opeid==133500)replace vsending_opeid=1 if firstime==5 & (sending_opeid==133800| ///sending_opeid==133900| ///sending_opeid==134100| ///sending_opeid==134200| ///sending_opeid==134300| ///sending_opeid==134400| ///sending_opeid==134500| ///sending_opeid==134600| ///sending_opeid==134700| ///sending_opeid==134800| ///sending_opeid==134900| ///sending_opeid==135000| ///sending_opeid==135200| ///sending_opeid==135300| ///sending_opeid==135400| ///sending_opeid==135500| ///sending_opeid==135800| ///sending_opeid==135900| ///sending_opeid==136000| ///sending_opeid==136100| ///sending_opeid==136200| ///sending_opeid==136300| ///sending_opeid==136500| ///sending_opeid==136800| ///sending_opeid==136900| ///sending_opeid==137000| ///sending_opeid==137100| ///sending_opeid==137200| ///sending_opeid==137400| ///sending_opeid==137800| ///sending_opeid==137900| ///sending_opeid==138000| ///sending_opeid==138500| ///sending_opeid==138700| ///sending_opeid==138900| ///sending_opeid==139200| ///sending_opeid==139300| ///sending_opeid==139700| ///sending_opeid==139800| ///sending_opeid==139900| ///sending_opeid==140100| ///sending_opeid==140200| ///sending_opeid==140300| ///sending_opeid==140600| ///sending_opeid==140800| ///sending_opeid==140900| ///sending_opeid==141400| ///sending_opeid==141500| ///sending_opeid==141600| ///sending_opeid==141700| ///sending_opeid==141708| ///sending_opeid==142200| ///sending_opeid==142400| ///sending_opeid==142500| ///sending_opeid==142600| ///sending_opeid==142800| ///sending_opeid==142900| ///sending_opeid==143100| ///sending_opeid==143300| ///sending_opeid==143400| ///sending_opeid==143600| ///sending_opeid==143700| ///sending_opeid==144100| ///sending_opeid==144102| ///sending_opeid==144300| ///sending_opeid==144400| ///sending_opeid==144500| ///sending_opeid==144800| ///sending_opeid==145600| ///sending_opeid==145900| ///sending_opeid==146000| ///sending_opeid==146200| ///sending_opeid==146400| ///sending_opeid==146600| ///sending_opeid==146700| ///sending_opeid==146800| ///sending_opeid==146900| ///sending_opeid==147000| ///sending_opeid==147100| ///sending_opeid==147200| ///sending_opeid==147300| ///sending_opeid==147500| ///sending_opeid==147700| ///sending_opeid==147800| ///sending_opeid==147900| ///sending_opeid==148000| ///sending_opeid==148100| ///sending_opeid==148200| ///sending_opeid==148400| ///sending_opeid==148500| ///sending_opeid==148600| ///sending_opeid==148700| ///sending_opeid==148800| ///sending_opeid==148900| ///sending_opeid==149000| ///sending_opeid==149300| ///sending_opeid==149500| ///sending_opeid==149710| ///sending_opeid==149900| ///sending_opeid==150000| ///sending_opeid==150100| ///sending_opeid==150200| ///sending_opeid==150400| ///sending_opeid==150500| ///sending_opeid==150600| ///sending_opeid==150800| ///sending_opeid==150900| ///sending_opeid==151000| ///sending_opeid==151200| ///sending_opeid==151300| ///sending_opeid==151400| ///sending_opeid==151500| ///sending_opeid==151900| ///sending_opeid==152000| ///sending_opeid==152100| ///sending_opeid==152200| ///sending_opeid==152300| ///sending_opeid==152600| ///sending_opeid==152800| ///sending_opeid==153100| ///sending_opeid==153300| ///sending_opeid==153500| ///sending_opeid==153600| ///sending_opeid==153700| ///sending_opeid==153702| ///sending_opeid==153800| ///sending_opeid==154000| ///sending_opeid==154001| ///sending_opeid==154100| ///sending_opeid==154200| ///sending_opeid==154300| ///sending_opeid==154400| ///sending_opeid==154500| ///sending_opeid==154600| ///sending_opeid==154700| ///sending_opeid==154900| ///sending_opeid==155200| ///sending_opeid==155400| ///sending_opeid==155500| ///sending_opeid==155600| ///sending_opeid==155700| ///sending_opeid==155800| ///sending_opeid==155900| ///sending_opeid==156000| ///sending_opeid==156100| ///sending_opeid==156200| ///sending_opeid==156300| ///sending_opeid==156400| ///sending_opeid==156600| ///sending_opeid==156700| ///sending_opeid==156800| ///sending_opeid==156900| ///sending_opeid==157000| ///sending_opeid==157100| ///sending_opeid==157200| ///sending_opeid==157300| ///sending_opeid==157400| ///sending_opeid==157500| ///sending_opeid==157700| ///sending_opeid==157800| ///sending_opeid==157900| ///sending_opeid==157900| ///sending_opeid==158000| ///sending_opeid==158100| ///sending_opeid==158200| ///sending_opeid==158300| ///sending_opeid==158500| ///sending_opeid==158600| ///sending_opeid==158700| ///sending_opeid==158800| ///sending_opeid==158900| ///sending_opeid==159000| ///sending_opeid==159100| ///sending_opeid==159200| ///sending_opeid==159400| ///sending_opeid==159600| ///sending_opeid==159700| ///sending_opeid==159800| ///sending_opeid==159900| ///sending_opeid==160000| ///sending_opeid==160100| ///sending_opeid==160200| ///sending_opeid==160400| ///sending_opeid==160500| ///sending_opeid==160600| ///sending_opeid==161000| ///sending_opeid==161100| ///sending_opeid==161200| ///sending_opeid==161300| ///sending_opeid==161400| ///sending_opeid==161500| ///sending_opeid==161600| ///sending_opeid==161700| ///sending_opeid==161900| ///sending_opeid==162000| ///sending_opeid==162100| ///sending_opeid==162300| ///sending_opeid==162400| ///sending_opeid==162500| ///sending_opeid==162600| ///sending_opeid==162800| ///sending_opeid==163200| ///sending_opeid==163300| ///sending_opeid==163400| ///sending_opeid==163600| ///sending_opeid==163700| ///sending_opeid==163800| ///sending_opeid==163900| ///sending_opeid==164000| ///sending_opeid==164100| ///sending_opeid==164300| ///sending_opeid==164800| ///sending_opeid==164900| ///sending_opeid==165000| ///sending_opeid==165200| ///sending_opeid==165400| ///sending_opeid==165500| ///sending_opeid==165700| ///sending_opeid==165900| ///sending_opeid==166100| ///sending_opeid==166300| ///sending_opeid==166400| ///sending_opeid==166500| ///sending_opeid==166600| ///sending_opeid==166900| ///sending_opeid==167100| ///sending_opeid==167400| ///sending_opeid==167500| ///sending_opeid==167600| ///sending_opeid==167800| ///sending_opeid==168100| ///sending_opeid==168200| ///sending_opeid==168400| ///sending_opeid==168500| ///sending_opeid==168800| ///sending_opeid==168900| ///sending_opeid==169100| ///sending_opeid==169200| ///sending_opeid==169300| ///sending_opeid==169400| ///sending_opeid==169600| ///sending_opeid==169800| ///sending_opeid==169900| ///sending_opeid==170000| ///sending_opeid==170100| ///sending_opeid==170300)replace vsending_opeid=1 if firstime==5 & (sending_opeid==170400| ///sending_opeid==170500| ///sending_opeid==170600| ///sending_opeid==170700| ///sending_opeid==170800| ///sending_opeid==170900| ///sending_opeid==171000| ///sending_opeid==171200| ///sending_opeid==171600| ///sending_opeid==171700| ///sending_opeid==172100| ///sending_opeid==172200| ///sending_opeid==172300| ///sending_opeid==172400| ///sending_opeid==172500| ///sending_opeid==172700| ///sending_opeid==172800| ///sending_opeid==173200| ///sending_opeid==173300| ///sending_opeid==173400| ///sending_opeid==173500| ///sending_opeid==173600| ///sending_opeid==173700| ///sending_opeid==173900| ///sending_opeid==174100| ///sending_opeid==174400| ///sending_opeid==174500| ///sending_opeid==174600| ///sending_opeid==174700| ///sending_opeid==174800| ///sending_opeid==174900| ///sending_opeid==175000| ///sending_opeid==175200| ///sending_opeid==175300| ///sending_opeid==175400| ///sending_opeid==175600| ///sending_opeid==175700| ///sending_opeid==175800| ///sending_opeid==175900| ///sending_opeid==176100| ///sending_opeid==176500| ///sending_opeid==176700| ///sending_opeid==176800| ///sending_opeid==176900| ///sending_opeid==177100| ///sending_opeid==177200| ///sending_opeid==177300| ///sending_opeid==177400| ///sending_opeid==177500| ///sending_opeid==177600| ///sending_opeid==177800| ///sending_opeid==178000| ///sending_opeid==178100| ///sending_opeid==178300| ///sending_opeid==178400| ///sending_opeid==178500| ///sending_opeid==178600| ///sending_opeid==178700| ///sending_opeid==178800| ///sending_opeid==178900| ///sending_opeid==179200| ///sending_opeid==179300| ///sending_opeid==179500| ///sending_opeid==179800| ///sending_opeid==179900| ///sending_opeid==180000| ///sending_opeid==180100| ///sending_opeid==180300| ///sending_opeid==180400| ///sending_opeid==180500| ///sending_opeid==180700| ///sending_opeid==180800| ///sending_opeid==180900| ///sending_opeid==181100| ///sending_opeid==181300| ///sending_opeid==181400| ///sending_opeid==181500| ///sending_opeid==181600| ///sending_opeid==181700| ///sending_opeid==182000| ///sending_opeid==182100| ///sending_opeid==182200| ///sending_opeid==182300| ///sending_opeid==182400| ///sending_opeid==182500| ///sending_opeid==182600| ///sending_opeid==182700| ///sending_opeid==182800| ///sending_opeid==183000| ///sending_opeid==183200| ///sending_opeid==183300| ///sending_opeid==183400| ///sending_opeid==183500| ///sending_opeid==183600| ///sending_opeid==183800| ///sending_opeid==183900| ///sending_opeid==184000| ///sending_opeid==184200| ///sending_opeid==184300| ///sending_opeid==184400| ///sending_opeid==184600| ///sending_opeid==184700| ///sending_opeid==184800| ///sending_opeid==185000| ///sending_opeid==185200| ///sending_opeid==185400| ///sending_opeid==185500| ///sending_opeid==185600| ///sending_opeid==185700| ///sending_opeid==185800| ///sending_opeid==185900| ///sending_opeid==186000| ///sending_opeid==186400| ///sending_opeid==186500| ///sending_opeid==186600| ///sending_opeid==186700| ///sending_opeid==186800| ///sending_opeid==186900| ///sending_opeid==187100| ///sending_opeid==187300| ///sending_opeid==187400| ///sending_opeid==187500| ///sending_opeid==187700| ///sending_opeid==187900| ///sending_opeid==188000| ///sending_opeid==188100| ///sending_opeid==188300| ///sending_opeid==188700| ///sending_opeid==188900| ///sending_opeid==189000| ///sending_opeid==189100| ///sending_opeid==189200| ///sending_opeid==189300| ///sending_opeid==189400| ///sending_opeid==189500| ///sending_opeid==189600| ///sending_opeid==189700| ///sending_opeid==190000| ///sending_opeid==190100| ///sending_opeid==190200| ///sending_opeid==190300| ///sending_opeid==190302| ///sending_opeid==190400| ///sending_opeid==190500| ///sending_opeid==190600| ///sending_opeid==190700| ///sending_opeid==190800| ///sending_opeid==190900| ///sending_opeid==191000| ///sending_opeid==191100| ///sending_opeid==191300| ///sending_opeid==191400| ///sending_opeid==191500| ///sending_opeid==191600| ///sending_opeid==191700| ///sending_opeid==191800| ///sending_opeid==191900| ///sending_opeid==192000| ///sending_opeid==192100| ///sending_opeid==192114| ///sending_opeid==192300| ///sending_opeid==192400| ///sending_opeid==192500| ///sending_opeid==192502| ///sending_opeid==192600| ///sending_opeid==192700| ///sending_opeid==192800| ///sending_opeid==192900| ///sending_opeid==193000| ///sending_opeid==193100| ///sending_opeid==193300| ///sending_opeid==193600| ///sending_opeid==193700| ///sending_opeid==193800| ///sending_opeid==193900| ///sending_opeid==194000| ///sending_opeid==194300| ///sending_opeid==194500| ///sending_opeid==194600| ///sending_opeid==194800| ///sending_opeid==194900| ///sending_opeid==194901| ///sending_opeid==195000| ///sending_opeid==195100| ///sending_opeid==195200| ///sending_opeid==195300| ///sending_opeid==195400| ///sending_opeid==195500| ///sending_opeid==195800| ///sending_opeid==195900| ///sending_opeid==196000| ///sending_opeid==196100| ///sending_opeid==196200| ///sending_opeid==196300| ///sending_opeid==196400| ///sending_opeid==196500| ///sending_opeid==196800| ///sending_opeid==196900| ///sending_opeid==197100| ///sending_opeid==197200| ///sending_opeid==197400| ///sending_opeid==197500| ///sending_opeid==197600| ///sending_opeid==197700| ///sending_opeid==197900| ///sending_opeid==198000| ///sending_opeid==198200| ///sending_opeid==198300| ///sending_opeid==198700| ///sending_opeid==198800| ///sending_opeid==198900| ///sending_opeid==199000| ///sending_opeid==199100| ///sending_opeid==199300| ///sending_opeid==199400| ///sending_opeid==199600| ///sending_opeid==199700| ///sending_opeid==199800| ///sending_opeid==199900| ///sending_opeid==200100| ///sending_opeid==200200| ///sending_opeid==200300| ///sending_opeid==200400| ///sending_opeid==200500| ///sending_opeid==200600| ///sending_opeid==200700| ///sending_opeid==200800| ///sending_opeid==201000| ///sending_opeid==201100| ///sending_opeid==201200| ///sending_opeid==201300| ///sending_opeid==201400| ///sending_opeid==201500| ///sending_opeid==201600| ///sending_opeid==201700| ///sending_opeid==201900| ///sending_opeid==202000| ///sending_opeid==202100| ///sending_opeid==202200| ///sending_opeid==202300| ///sending_opeid==202400| ///sending_opeid==202500| ///sending_opeid==202600| ///sending_opeid==202700| ///sending_opeid==202900| ///sending_opeid==203100| ///sending_opeid==203200| ///sending_opeid==203300)replace vsending_opeid=1 if firstime==5 & (sending_opeid==203500| ///sending_opeid==203600| ///sending_opeid==203800| ///sending_opeid==203900| ///sending_opeid==204000| ///sending_opeid==204100| ///sending_opeid==204300| ///sending_opeid==204400| ///sending_opeid==205000| ///sending_opeid==205100| ///sending_opeid==205200| ///sending_opeid==205300| ///sending_opeid==205400| ///sending_opeid==205500| ///sending_opeid==205700| ///sending_opeid==205800| ///sending_opeid==206000| ///sending_opeid==206100| ///sending_opeid==206200| ///sending_opeid==206300| ///sending_opeid==206400| ///sending_opeid==206500| ///sending_opeid==206700| ///sending_opeid==206800| ///sending_opeid==207100| ///sending_opeid==207200| ///sending_opeid==207300| ///sending_opeid==207400| ///sending_opeid==207500| ///sending_opeid==207600| ///sending_opeid==207700| ///sending_opeid==207709| ///sending_opeid==207800| ///sending_opeid==208000| ///sending_opeid==208300| ///sending_opeid==208600| ///sending_opeid==208700| ///sending_opeid==208900| ///sending_opeid==209100| ///sending_opeid==209200| ///sending_opeid==209300| ///sending_opeid==209500| ///sending_opeid==209600| ///sending_opeid==209900| ///sending_opeid==210100| ///sending_opeid==210200| ///sending_opeid==210300| ///sending_opeid==210400| ///sending_opeid==210500| ///sending_opeid==210600| ///sending_opeid==210700| ///sending_opeid==210800| ///sending_opeid==210900| ///sending_opeid==211400| ///sending_opeid==211500| ///sending_opeid==211600| ///sending_opeid==211700| ///sending_opeid==211800| ///sending_opeid==211900| ///sending_opeid==212000| ///sending_opeid==212100| ///sending_opeid==212200| ///sending_opeid==212300| ///sending_opeid==212400| ///sending_opeid==212600| ///sending_opeid==212800| ///sending_opeid==212900| ///sending_opeid==213000| ///sending_opeid==213300| ///sending_opeid==213900| ///sending_opeid==214000| ///sending_opeid==214100| ///sending_opeid==214300| ///sending_opeid==214400| ///sending_opeid==214500| ///sending_opeid==214600| ///sending_opeid==214700| ///sending_opeid==214800| ///sending_opeid==214900| ///sending_opeid==215000| ///sending_opeid==215100| ///sending_opeid==215300| ///sending_opeid==215400| ///sending_opeid==215500| ///sending_opeid==215700| ///sending_opeid==215800| ///sending_opeid==216000| ///sending_opeid==216100| ///sending_opeid==216400| ///sending_opeid==216500| ///sending_opeid==216700| ///sending_opeid==216800| ///sending_opeid==216900| ///sending_opeid==217000| ///sending_opeid==217100| ///sending_opeid==217200| ///sending_opeid==217300| ///sending_opeid==217400| ///sending_opeid==217500| ///sending_opeid==217600| ///sending_opeid==217700| ///sending_opeid==217800| ///sending_opeid==218000| ///sending_opeid==218100| ///sending_opeid==218300| ///sending_opeid==218400| ///sending_opeid==218500| ///sending_opeid==218700| ///sending_opeid==218800| ///sending_opeid==218900| ///sending_opeid==219000| ///sending_opeid==219200| ///sending_opeid==219300| ///sending_opeid==219400| ///sending_opeid==219700| ///sending_opeid==219900| ///sending_opeid==220100| ///sending_opeid==220200| ///sending_opeid==220500| ///sending_opeid==220600| ///sending_opeid==220800| ///sending_opeid==220900| ///sending_opeid==221000| ///sending_opeid==221100| ///sending_opeid==221400| ///sending_opeid==221700| ///sending_opeid==221800| ///sending_opeid==221900| ///sending_opeid==222100| ///sending_opeid==222200| ///sending_opeid==222400| ///sending_opeid==222500| ///sending_opeid==222600| ///sending_opeid==222700| ///sending_opeid==222800| ///sending_opeid==222900| ///sending_opeid==223300| ///sending_opeid==223400| ///sending_opeid==223500| ///sending_opeid==223600| ///sending_opeid==223700| ///sending_opeid==223800| ///sending_opeid==223900| ///sending_opeid==224000| ///sending_opeid==224100| ///sending_opeid==224200| ///sending_opeid==224300| ///sending_opeid==224600| ///sending_opeid==224700| ///sending_opeid==224800| ///sending_opeid==224900| ///sending_opeid==225100| ///sending_opeid==225200| ///sending_opeid==225400| ///sending_opeid==225900| ///sending_opeid==226000| ///sending_opeid==226100| ///sending_opeid==226200| ///sending_opeid==226300| ///sending_opeid==226400| ///sending_opeid==226500| ///sending_opeid==226600| ///sending_opeid==226700| ///sending_opeid==226800| ///sending_opeid==226900| ///sending_opeid==227000| ///sending_opeid==227200| ///sending_opeid==227300| ///sending_opeid==227400| ///sending_opeid==227500| ///sending_opeid==227600| ///sending_opeid==227700| ///sending_opeid==227800| ///sending_opeid==227900| ///sending_opeid==228200| ///sending_opeid==228400| ///sending_opeid==228800| ///sending_opeid==229000| ///sending_opeid==229200| ///sending_opeid==229300| ///sending_opeid==229400| ///sending_opeid==229500| ///sending_opeid==229700| ///sending_opeid==229900| ///sending_opeid==230100| ///sending_opeid==230200| ///sending_opeid==230300| ///sending_opeid==230700| ///sending_opeid==230800| ///sending_opeid==231000| ///sending_opeid==231100| ///sending_opeid==231300| ///sending_opeid==231400| ///sending_opeid==231500| ///sending_opeid==231600| ///sending_opeid==231700| ///sending_opeid==231800| ///sending_opeid==232200| ///sending_opeid==232300| ///sending_opeid==232500| ///sending_opeid==232600| ///sending_opeid==232700| ///sending_opeid==232800| ///sending_opeid==232900| ///sending_opeid==233000| ///sending_opeid==233100| ///sending_opeid==233200| ///sending_opeid==233400| ///sending_opeid==233500| ///sending_opeid==233600| ///sending_opeid==233700| ///sending_opeid==233900| ///sending_opeid==234000| ///sending_opeid==234100| ///sending_opeid==234200| ///sending_opeid==234300| ///sending_opeid==234500| ///sending_opeid==234600| ///sending_opeid==234700| ///sending_opeid==235000| ///sending_opeid==235300| ///sending_opeid==235400| ///sending_opeid==235500| ///sending_opeid==235600| ///sending_opeid==235700| ///sending_opeid==235800| ///sending_opeid==236000| ///sending_opeid==236100| ///sending_opeid==236200| ///sending_opeid==236500| ///sending_opeid==236600| ///sending_opeid==236700| ///sending_opeid==236900| ///sending_opeid==237000| ///sending_opeid==237100| ///sending_opeid==237300| ///sending_opeid==237500| ///sending_opeid==237700| ///sending_opeid==237900| ///sending_opeid==238000| ///sending_opeid==238200| ///sending_opeid==238300| ///sending_opeid==238500| ///sending_opeid==238600| ///sending_opeid==238800| ///sending_opeid==238900| ///sending_opeid==239100| ///sending_opeid==239300| ///sending_opeid==239400)replace vsending_opeid=1 if firstime==5 & (sending_opeid==239600| ///sending_opeid==239700| ///sending_opeid==239800| ///sending_opeid==240100| ///sending_opeid==240200| ///sending_opeid==240300| ///sending_opeid==240400| ///sending_opeid==240500| ///sending_opeid==240700| ///sending_opeid==240800| ///sending_opeid==240900| ///sending_opeid==241000| ///sending_opeid==241100| ///sending_opeid==241300| ///sending_opeid==241400| ///sending_opeid==241500| ///sending_opeid==241600| ///sending_opeid==241700| ///sending_opeid==242200| ///sending_opeid==242300| ///sending_opeid==242400| ///sending_opeid==242600| ///sending_opeid==242700| ///sending_opeid==243000| ///sending_opeid==243300| ///sending_opeid==243500| ///sending_opeid==243600| ///sending_opeid==243900| ///sending_opeid==244000| ///sending_opeid==244001| ///sending_opeid==244100| ///sending_opeid==244700| ///sending_opeid==244900| ///sending_opeid==245000| ///sending_opeid==245200| ///sending_opeid==245300| ///sending_opeid==245400| ///sending_opeid==245600| ///sending_opeid==245700| ///sending_opeid==245800| ///sending_opeid==245900| ///sending_opeid==246000| ///sending_opeid==246100| ///sending_opeid==246200| ///sending_opeid==246300| ///sending_opeid==246302| ///sending_opeid==246400| ///sending_opeid==246600| ///sending_opeid==246700| ///sending_opeid==246800| ///sending_opeid==247100| ///sending_opeid==247300| ///sending_opeid==247400| ///sending_opeid==247600| ///sending_opeid==247700| ///sending_opeid==247900| ///sending_opeid==248000| ///sending_opeid==248200| ///sending_opeid==248400| ///sending_opeid==248500| ///sending_opeid==248600| ///sending_opeid==248800| ///sending_opeid==248900| ///sending_opeid==249000| ///sending_opeid==249100| ///sending_opeid==249400| ///sending_opeid==249500| ///sending_opeid==249600| ///sending_opeid==249800| ///sending_opeid==249900| ///sending_opeid==250000| ///sending_opeid==250100| ///sending_opeid==250200| ///sending_opeid==250300| ///sending_opeid==250400| ///sending_opeid==250600| ///sending_opeid==250900| ///sending_opeid==251200| ///sending_opeid==251400| ///sending_opeid==251600| ///sending_opeid==251700| ///sending_opeid==251800| ///sending_opeid==251900| ///sending_opeid==252000| ///sending_opeid==252100| ///sending_opeid==252200| ///sending_opeid==252300| ///sending_opeid==252400| ///sending_opeid==252500| ///sending_opeid==252600| ///sending_opeid==252700| ///sending_opeid==252800| ///sending_opeid==252900| ///sending_opeid==253000| ///sending_opeid==253100| ///sending_opeid==253200| ///sending_opeid==253300| ///sending_opeid==253400| ///sending_opeid==253600| ///sending_opeid==253700| ///sending_opeid==253900| ///sending_opeid==254000| ///sending_opeid==254100| ///sending_opeid==254200| ///sending_opeid==254300| ///sending_opeid==254400| ///sending_opeid==254700| ///sending_opeid==254800| ///sending_opeid==255100| ///sending_opeid==255300| ///sending_opeid==255400| ///sending_opeid==255500| ///sending_opeid==255700| ///sending_opeid==255900| ///sending_opeid==256000| ///sending_opeid==256300| ///sending_opeid==256500| ///sending_opeid==256596| ///sending_opeid==256600| ///sending_opeid==256700| ///sending_opeid==256800| ///sending_opeid==256900| ///sending_opeid==257200| ///sending_opeid==257300| ///sending_opeid==257500| ///sending_opeid==257501| ///sending_opeid==257900| ///sending_opeid==258000| ///sending_opeid==258100| ///sending_opeid==258200| ///sending_opeid==258300| ///sending_opeid==258600| ///sending_opeid==258700| ///sending_opeid==258900| ///sending_opeid==259000| ///sending_opeid==259100| ///sending_opeid==259500| ///sending_opeid==259600| ///sending_opeid==259700| ///sending_opeid==259800| ///sending_opeid==259900| ///sending_opeid==260000| ///sending_opeid==260100| ///sending_opeid==260300| ///sending_opeid==260700| ///sending_opeid==260800| ///sending_opeid==260900| ///sending_opeid==261000| ///sending_opeid==261300| ///sending_opeid==261500| ///sending_opeid==261600| ///sending_opeid==261700| ///sending_opeid==261900| ///sending_opeid==262100| ///sending_opeid==262200| ///sending_opeid==262400| ///sending_opeid==262500| ///sending_opeid==262600| ///sending_opeid==262700| ///sending_opeid==262800| ///sending_opeid==262900| ///sending_opeid==263200| ///sending_opeid==263800| ///sending_opeid==263900| ///sending_opeid==264200| ///sending_opeid==264300| ///sending_opeid==264900| ///sending_opeid==265000| ///sending_opeid==265100| ///sending_opeid==265101| ///sending_opeid==265300| ///sending_opeid==265400| ///sending_opeid==265500| ///sending_opeid==265600| ///sending_opeid==265700| ///sending_opeid==265701| ///sending_opeid==265702| ///sending_opeid==265703| ///sending_opeid==266000| ///sending_opeid==266300| ///sending_opeid==266400| ///sending_opeid==266500| ///sending_opeid==266600| ///sending_opeid==266700| ///sending_opeid==266800| ///sending_opeid==266900| ///sending_opeid==267000| ///sending_opeid==267100| ///sending_opeid==267400| ///sending_opeid==267700| ///sending_opeid==268100| ///sending_opeid==268300| ///sending_opeid==268500| ///sending_opeid==268700| ///sending_opeid==268800| ///sending_opeid==268900| ///sending_opeid==269000| ///sending_opeid==269100| ///sending_opeid==269200| ///sending_opeid==269300| ///sending_opeid==269400| ///sending_opeid==269600| ///sending_opeid==269700| ///sending_opeid==269800| ///sending_opeid==269900| ///sending_opeid==270000| ///sending_opeid==270100| ///sending_opeid==270300| ///sending_opeid==270400| ///sending_opeid==270500| ///sending_opeid==270700| ///sending_opeid==270800| ///sending_opeid==270900| ///sending_opeid==271000| ///sending_opeid==271100| ///sending_opeid==271200| ///sending_opeid==271300| ///sending_opeid==271800| ///sending_opeid==272200| ///sending_opeid==272206| ///sending_opeid==272600| ///sending_opeid==272800| ///sending_opeid==272900| ///sending_opeid==273100| ///sending_opeid==273200| ///sending_opeid==273400| ///sending_opeid==273500| ///sending_opeid==273700| ///sending_opeid==273900| ///sending_opeid==274000| ///sending_opeid==274100| ///sending_opeid==274200| ///sending_opeid==274400| ///sending_opeid==274800| ///sending_opeid==274900| ///sending_opeid==275100| ///sending_opeid==275800| ///sending_opeid==275900| ///sending_opeid==276000| ///sending_opeid==276300| ///sending_opeid==276500| ///sending_opeid==276900| ///sending_opeid==277200| ///sending_opeid==277500| ///sending_opeid==277700| ///sending_opeid==277800| ///sending_opeid==277900| ///sending_opeid==278200| ///sending_opeid==278201)replace vsending_opeid=1 if firstime==5 & (sending_opeid==278300| ///sending_opeid==278400| ///sending_opeid==278500| ///sending_opeid==278520| ///sending_opeid==278800| ///sending_opeid==279000| ///sending_opeid==279100| ///sending_opeid==279500| ///sending_opeid==279600| ///sending_opeid==279800| ///sending_opeid==280300| ///sending_opeid==280500| ///sending_opeid==280600| ///sending_opeid==280700| ///sending_opeid==280800| ///sending_opeid==281000| ///sending_opeid==281001| ///sending_opeid==281200| ///sending_opeid==281300| ///sending_opeid==281400| ///sending_opeid==281500| ///sending_opeid==281600| ///sending_opeid==281700| ///sending_opeid==282000| ///sending_opeid==282100| ///sending_opeid==282200| ///sending_opeid==282300| ///sending_opeid==282500| ///sending_opeid==282600| ///sending_opeid==282900| ///sending_opeid==283200| ///sending_opeid==283300| ///sending_opeid==283400| ///sending_opeid==283500| ///sending_opeid==283600| ///sending_opeid==283700| ///sending_opeid==283800| ///sending_opeid==283900| ///sending_opeid==284000| ///sending_opeid==284100| ///sending_opeid==284200| ///sending_opeid==284300| ///sending_opeid==284400| ///sending_opeid==284500| ///sending_opeid==284600| ///sending_opeid==284700| ///sending_opeid==284800| ///sending_opeid==284900| ///sending_opeid==285000| ///sending_opeid==285100| ///sending_opeid==285300| ///sending_opeid==285400| ///sending_opeid==285500| ///sending_opeid==285600| ///sending_opeid==285700| ///sending_opeid==285800| ///sending_opeid==285900| ///sending_opeid==286000| ///sending_opeid==286100| ///sending_opeid==286200| ///sending_opeid==286300| ///sending_opeid==286400| ///sending_opeid==286600| ///sending_opeid==286700| ///sending_opeid==286800| ///sending_opeid==286900| ///sending_opeid==287000| ///sending_opeid==287100| ///sending_opeid==287200| ///sending_opeid==287300| ///sending_opeid==287400| ///sending_opeid==287500| ///sending_opeid==287600| ///sending_opeid==287700| ///sending_opeid==287800| ///sending_opeid==287900| ///sending_opeid==288000| ///sending_opeid==288100| ///sending_opeid==288200| ///sending_opeid==288300| ///sending_opeid==288500| ///sending_opeid==288600| ///sending_opeid==288700| ///sending_opeid==288900| ///sending_opeid==289000| ///sending_opeid==289200| ///sending_opeid==289300| ///sending_opeid==289400| ///sending_opeid==289500| ///sending_opeid==289600| ///sending_opeid==289900| ///sending_opeid==290000| ///sending_opeid==290100| ///sending_opeid==290300| ///sending_opeid==290500| ///sending_opeid==290600| ///sending_opeid==290700| ///sending_opeid==290800| ///sending_opeid==291000| ///sending_opeid==291100| ///sending_opeid==291200| ///sending_opeid==291300| ///sending_opeid==291400| ///sending_opeid==291500| ///sending_opeid==291600| ///sending_opeid==291700| ///sending_opeid==291800| ///sending_opeid==291900| ///sending_opeid==292000| ///sending_opeid==292300| ///sending_opeid==292600| ///sending_opeid==292700| ///sending_opeid==292800| ///sending_opeid==292900| ///sending_opeid==293000| ///sending_opeid==293100| ///sending_opeid==293300| ///sending_opeid==293400| ///sending_opeid==293500| ///sending_opeid==293600| ///sending_opeid==293700| ///sending_opeid==293900| ///sending_opeid==294000| ///sending_opeid==294100| ///sending_opeid==294200| ///sending_opeid==294300| ///sending_opeid==294400| ///sending_opeid==294500| ///sending_opeid==294600| ///sending_opeid==294700| ///sending_opeid==294800| ///sending_opeid==294900| ///sending_opeid==295000| ///sending_opeid==295100| ///sending_opeid==295300| ///sending_opeid==295400| ///sending_opeid==295500| ///sending_opeid==295600| ///sending_opeid==295700| ///sending_opeid==295800| ///sending_opeid==296000| ///sending_opeid==296100| ///sending_opeid==296200| ///sending_opeid==296300| ///sending_opeid==296400| ///sending_opeid==296800| ///sending_opeid==297000| ///sending_opeid==297200| ///sending_opeid==297300| ///sending_opeid==297400| ///sending_opeid==297500| ///sending_opeid==297600| ///sending_opeid==297800| ///sending_opeid==297900| ///sending_opeid==298000| ///sending_opeid==298100| ///sending_opeid==298200| ///sending_opeid==298300| ///sending_opeid==298400| ///sending_opeid==298500| ///sending_opeid==298600| ///sending_opeid==298800| ///sending_opeid==298900| ///sending_opeid==299000| ///sending_opeid==299100| ///sending_opeid==299200| ///sending_opeid==299300| ///sending_opeid==299400| ///sending_opeid==299500| ///sending_opeid==299600| ///sending_opeid==299700| ///sending_opeid==300500| ///sending_opeid==300700| ///sending_opeid==300800| ///sending_opeid==300900| ///sending_opeid==301010| ///sending_opeid==301100| ///sending_opeid==301200| ///sending_opeid==301300| ///sending_opeid==301400| ///sending_opeid==301600| ///sending_opeid==301800| ///sending_opeid==302300| ///sending_opeid==302400| ///sending_opeid==302500| ///sending_opeid==302600| ///sending_opeid==302900| ///sending_opeid==303000| ///sending_opeid==303100| ///sending_opeid==303200| ///sending_opeid==303300| ///sending_opeid==303500| ///sending_opeid==303600| ///sending_opeid==303700| ///sending_opeid==303900| ///sending_opeid==304000| ///sending_opeid==304100| ///sending_opeid==304200| ///sending_opeid==304300| ///sending_opeid==304400| ///sending_opeid==304500| ///sending_opeid==304600| ///sending_opeid==304800| ///sending_opeid==304900| ///sending_opeid==305000| ///sending_opeid==305100| ///sending_opeid==306500| ///sending_opeid==306600| ///sending_opeid==306800| ///sending_opeid==306900| ///sending_opeid==307200| ///sending_opeid==307300| ///sending_opeid==307500| ///sending_opeid==307700| ///sending_opeid==307800| ///sending_opeid==308300| ///sending_opeid==308400| ///sending_opeid==308500| ///sending_opeid==308600| ///sending_opeid==308900| ///sending_opeid==309000| ///sending_opeid==309005| ///sending_opeid==310000| ///sending_opeid==310900| ///sending_opeid==311000| ///sending_opeid==311300| ///sending_opeid==311400| ///sending_opeid==311500| ///sending_opeid==311600| ///sending_opeid==311900| ///sending_opeid==312100| ///sending_opeid==312200| ///sending_opeid==312300| ///sending_opeid==312301| ///sending_opeid==312500| ///sending_opeid==312501| ///sending_opeid==312502| ///sending_opeid==312700| ///sending_opeid==313100| ///sending_opeid==313300| ///sending_opeid==313400| ///sending_opeid==313500| ///sending_opeid==314100| ///sending_opeid==314200| ///sending_opeid==314300| ///sending_opeid==314400| ///sending_opeid==314500| ///sending_opeid==314600| ///sending_opeid==314700)replace vsending_opeid=1 if firstime==5 & (sending_opeid==314900| ///sending_opeid==315000| ///sending_opeid==315100| ///sending_opeid==315200| ///sending_opeid==315300| ///sending_opeid==315400| ///sending_opeid==315500| ///sending_opeid==315600| ///sending_opeid==315700| ///sending_opeid==315800| ///sending_opeid==316000| ///sending_opeid==316100| ///sending_opeid==316200| ///sending_opeid==316300| ///sending_opeid==316400| ///sending_opeid==316500| ///sending_opeid==316600| ///sending_opeid==316700| ///sending_opeid==316800| ///sending_opeid==317000| ///sending_opeid==317200| ///sending_opeid==317400| ///sending_opeid==317600| ///sending_opeid==317800| ///sending_opeid==317900| ///sending_opeid==318000| ///sending_opeid==318100| ///sending_opeid==318300| ///sending_opeid==318400| ///sending_opeid==318500| ///sending_opeid==318600| ///sending_opeid==318800| ///sending_opeid==318900| ///sending_opeid==319100| ///sending_opeid==319300| ///sending_opeid==319400| ///sending_opeid==319600| ///sending_opeid==319700| ///sending_opeid==319800| ///sending_opeid==319801| ///sending_opeid==319900| ///sending_opeid==320300| ///sending_opeid==320400| ///sending_opeid==320600| ///sending_opeid==320700| ///sending_opeid==320800| ///sending_opeid==320900| ///sending_opeid==321000| ///sending_opeid==321100| ///sending_opeid==321200| ///sending_opeid==321300| ///sending_opeid==321600| ///sending_opeid==321700| ///sending_opeid==321800| ///sending_opeid==321900| ///sending_opeid==322000| ///sending_opeid==322100| ///sending_opeid==322200| ///sending_opeid==322300| ///sending_opeid==322400| ///sending_opeid==322500| ///sending_opeid==322700| ///sending_opeid==322800| ///sending_opeid==322900| ///sending_opeid==323000| ///sending_opeid==323100| ///sending_opeid==323300| ///sending_opeid==323500| ///sending_opeid==323700| ///sending_opeid==323800| ///sending_opeid==323900| ///sending_opeid==324000| ///sending_opeid==324100| ///sending_opeid==324200| ///sending_opeid==324300| ///sending_opeid==324400| ///sending_opeid==324500| ///sending_opeid==324700| ///sending_opeid==324900| ///sending_opeid==325100| ///sending_opeid==325200| ///sending_opeid==325300| ///sending_opeid==325600| ///sending_opeid==325800| ///sending_opeid==325900| ///sending_opeid==326000| ///sending_opeid==326200| ///sending_opeid==326300| ///sending_opeid==326500| ///sending_opeid==326600| ///sending_opeid==326700| ///sending_opeid==326800| ///sending_opeid==326900| ///sending_opeid==327000| ///sending_opeid==327200| ///sending_opeid==327300| ///sending_opeid==327400| ///sending_opeid==327500| ///sending_opeid==327600| ///sending_opeid==327700| ///sending_opeid==327900| ///sending_opeid==328000| ///sending_opeid==328200| ///sending_opeid==328300| ///sending_opeid==328400| ///sending_opeid==328500| ///sending_opeid==328600| ///sending_opeid==328700| ///sending_opeid==328800| ///sending_opeid==328900| ///sending_opeid==329000| ///sending_opeid==329100| ///sending_opeid==329200| ///sending_opeid==329300| ///sending_opeid==329400| ///sending_opeid==329600| ///sending_opeid==329700| ///sending_opeid==329800| ///sending_opeid==330000| ///sending_opeid==330100| ///sending_opeid==330200| ///sending_opeid==330300| ///sending_opeid==330400| ///sending_opeid==330600| ///sending_opeid==330900| ///sending_opeid==331100| ///sending_opeid==331300| ///sending_opeid==331400| ///sending_opeid==331500| ///sending_opeid==331600| ///sending_opeid==331700| ///sending_opeid==331800| ///sending_opeid==332000| ///sending_opeid==332100| ///sending_opeid==332200| ///sending_opeid==332300| ///sending_opeid==332400| ///sending_opeid==332500| ///sending_opeid==332600| ///sending_opeid==332700| ///sending_opeid==332800| ///sending_opeid==332900| ///sending_opeid==332922| ///sending_opeid==335000| ///sending_opeid==335100| ///sending_opeid==335200| ///sending_opeid==335300| ///sending_opeid==335400| ///sending_opeid==335600| ///sending_opeid==335700| ///sending_opeid==335800| ///sending_opeid==335900| ///sending_opeid==336000| ///sending_opeid==336200| ///sending_opeid==336400| ///sending_opeid==336600| ///sending_opeid==336700| ///sending_opeid==336800| ///sending_opeid==336800| ///sending_opeid==336900| ///sending_opeid==337000| ///sending_opeid==337100| ///sending_opeid==337600| ///sending_opeid==337800| ///sending_opeid==337900| ///sending_opeid==337901| ///sending_opeid==337902| ///sending_opeid==337903| ///sending_opeid==338400| ///sending_opeid==338500| ///sending_opeid==338600| ///sending_opeid==338800| ///sending_opeid==338900| ///sending_opeid==339100| ///sending_opeid==339200| ///sending_opeid==339300| ///sending_opeid==339400| ///sending_opeid==339500| ///sending_opeid==339600| ///sending_opeid==339900| ///sending_opeid==340100| ///sending_opeid==340200| ///sending_opeid==340400| ///sending_opeid==340403| ///sending_opeid==340409| ///sending_opeid==340410| ///sending_opeid==340600| ///sending_opeid==340700| ///sending_opeid==340800| ///sending_opeid==340900| ///sending_opeid==341000| ///sending_opeid==341001| ///sending_opeid==341100| ///sending_opeid==341400| ///sending_opeid==341700| ///sending_opeid==341800| ///sending_opeid==341900| ///sending_opeid==342000| ///sending_opeid==342100| ///sending_opeid==342200| ///sending_opeid==342300| ///sending_opeid==342400| ///sending_opeid==342500| ///sending_opeid==342700| ///sending_opeid==342800| ///sending_opeid==342900| ///sending_opeid==343000| ///sending_opeid==343100| ///sending_opeid==343200| ///sending_opeid==343400| ///sending_opeid==343500| ///sending_opeid==343600| ///sending_opeid==343700| ///sending_opeid==343800| ///sending_opeid==343900| ///sending_opeid==344000| ///sending_opeid==344100| ///sending_opeid==344500| ///sending_opeid==344600| ///sending_opeid==344700| ///sending_opeid==344800| ///sending_opeid==344900| ///sending_opeid==345000| ///sending_opeid==345100| ///sending_opeid==345500| ///sending_opeid==345600| ///sending_opeid==345700| ///sending_opeid==345800| ///sending_opeid==345900| ///sending_opeid==346100| ///sending_opeid==346300| ///sending_opeid==346500| ///sending_opeid==346600| ///sending_opeid==346700| ///sending_opeid==346900| ///sending_opeid==347000| ///sending_opeid==347100| ///sending_opeid==347400| ///sending_opeid==347700| ///sending_opeid==347800| ///sending_opeid==347900| ///sending_opeid==348000| ///sending_opeid==348100| ///sending_opeid==348200| ///sending_opeid==348300| ///sending_opeid==348400| ///sending_opeid==348500| ///sending_opeid==348600| ///sending_opeid==348700)replace vsending_opeid=1 if firstime==5 & (sending_opeid==349000| ///sending_opeid==349200| ///sending_opeid==349400| ///sending_opeid==349500| ///sending_opeid==349600| ///sending_opeid==349800| ///sending_opeid==349900| ///sending_opeid==350000| ///sending_opeid==350100| ///sending_opeid==350200| ///sending_opeid==350400| ///sending_opeid==350500| ///sending_opeid==350600| ///sending_opeid==350700| ///sending_opeid==350900| ///sending_opeid==351000| ///sending_opeid==351100| ///sending_opeid==351700| ///sending_opeid==351800| ///sending_opeid==351900| ///sending_opeid==352200| ///sending_opeid==352300| ///sending_opeid==352400| ///sending_opeid==352500| ///sending_opeid==352600| ///sending_opeid==352700| ///sending_opeid==352800| ///sending_opeid==352900| ///sending_opeid==353000| ///sending_opeid==353100| ///sending_opeid==353400| ///sending_opeid==353500| ///sending_opeid==353600| ///sending_opeid==353700| ///sending_opeid==353900| ///sending_opeid==354000| ///sending_opeid==354100| ///sending_opeid==354300| ///sending_opeid==354400| ///sending_opeid==354500| ///sending_opeid==354600| ///sending_opeid==354900| ///sending_opeid==355300| ///sending_opeid==355400| ///sending_opeid==355600| ///sending_opeid==355700| ///sending_opeid==355800| ///sending_opeid==356000| ///sending_opeid==356100| ///sending_opeid==356200| ///sending_opeid==356300| ///sending_opeid==356400| ///sending_opeid==356500| ///sending_opeid==356600| ///sending_opeid==356800| ///sending_opeid==357000| ///sending_opeid==357100| ///sending_opeid==357200| ///sending_opeid==357300| ///sending_opeid==357400| ///sending_opeid==357500| ///sending_opeid==357600| ///sending_opeid==357700| ///sending_opeid==357800| ///sending_opeid==357900| ///sending_opeid==358000| ///sending_opeid==358100| ///sending_opeid==358200| ///sending_opeid==358300| ///sending_opeid==358400| ///sending_opeid==358500| ///sending_opeid==358600| ///sending_opeid==358800| ///sending_opeid==359000| ///sending_opeid==359100| ///sending_opeid==359200| ///sending_opeid==359300| ///sending_opeid==359400| ///sending_opeid==359500| ///sending_opeid==359600| ///sending_opeid==359800| ///sending_opeid==359900| ///sending_opeid==360000| ///sending_opeid==360100| ///sending_opeid==360200| ///sending_opeid==360300| ///sending_opeid==360400| ///sending_opeid==360600| ///sending_opeid==360700| ///sending_opeid==360800| ///sending_opeid==360900| ///sending_opeid==361000| ///sending_opeid==361100| ///sending_opeid==361200| ///sending_opeid==361300| ///sending_opeid==361400| ///sending_opeid==361500| ///sending_opeid==361600| ///sending_opeid==361700| ///sending_opeid==361800| ///sending_opeid==361900| ///sending_opeid==362000| ///sending_opeid==362100| ///sending_opeid==362300| ///sending_opeid==362400| ///sending_opeid==362500| ///sending_opeid==362600| ///sending_opeid==362700| ///sending_opeid==362800| ///sending_opeid==363000| ///sending_opeid==363100| ///sending_opeid==363200| ///sending_opeid==363208| ///sending_opeid==363400| ///sending_opeid==363500| ///sending_opeid==363600| ///sending_opeid==363600| ///sending_opeid==363700| ///sending_opeid==363800| ///sending_opeid==363900| ///sending_opeid==364100| ///sending_opeid==364200| ///sending_opeid==364300| ///sending_opeid==364400| ///sending_opeid==364500| ///sending_opeid==364501| ///sending_opeid==364600| ///sending_opeid==364700| ///sending_opeid==364800| ///sending_opeid==365100| ///sending_opeid==365200| ///sending_opeid==365400| ///sending_opeid==365600| ///sending_opeid==365800| ///sending_opeid==365900| ///sending_opeid==366100| ///sending_opeid==366200| ///sending_opeid==366300| ///sending_opeid==366400| ///sending_opeid==366500| ///sending_opeid==366800| ///sending_opeid==366900| ///sending_opeid==367000| ///sending_opeid==367100| ///sending_opeid==367200| ///sending_opeid==367400| ///sending_opeid==367409| ///sending_opeid==367500| ///sending_opeid==367600| ///sending_opeid==367700| ///sending_opeid==367800| ///sending_opeid==367900| ///sending_opeid==368000| ///sending_opeid==368100| ///sending_opeid==368200| ///sending_opeid==368300| ///sending_opeid==368400| ///sending_opeid==368402| ///sending_opeid==368500| ///sending_opeid==368600| ///sending_opeid==368700| ///sending_opeid==368800| ///sending_opeid==368900| ///sending_opeid==369000| ///sending_opeid==369100| ///sending_opeid==369200| ///sending_opeid==369300| ///sending_opeid==369400| ///sending_opeid==369600| ///sending_opeid==369700| ///sending_opeid==369800| ///sending_opeid==370200| ///sending_opeid==370300| ///sending_opeid==370400| ///sending_opeid==370500| ///sending_opeid==370600| ///sending_opeid==370700| ///sending_opeid==370800| ///sending_opeid==370900| ///sending_opeid==371100| ///sending_opeid==371200| ///sending_opeid==371300| ///sending_opeid==371400| ///sending_opeid==371500| ///sending_opeid==371900| ///sending_opeid==372000| ///sending_opeid==372100| ///sending_opeid==372300| ///sending_opeid==372400| ///sending_opeid==372600| ///sending_opeid==372700| ///sending_opeid==372800| ///sending_opeid==373200| ///sending_opeid==373300| ///sending_opeid==373400| ///sending_opeid==373500| ///sending_opeid==373600| ///sending_opeid==373700| ///sending_opeid==373800| ///sending_opeid==373900| ///sending_opeid==374200| ///sending_opeid==374300| ///sending_opeid==374400| ///sending_opeid==374500| ///sending_opeid==374600| ///sending_opeid==374700| ///sending_opeid==374800| ///sending_opeid==374900| ///sending_opeid==375100| ///sending_opeid==375200| ///sending_opeid==375300| ///sending_opeid==375400| ///sending_opeid==375800| ///sending_opeid==375900| ///sending_opeid==376000| ///sending_opeid==376100| ///sending_opeid==376200| ///sending_opeid==376400| ///sending_opeid==376500| ///sending_opeid==376600| ///sending_opeid==376700| ///sending_opeid==376800| ///sending_opeid==376900| ///sending_opeid==377000| ///sending_opeid==377100| ///sending_opeid==377200| ///sending_opeid==377300| ///sending_opeid==377400| ///sending_opeid==377500| ///sending_opeid==377600| ///sending_opeid==377700| ///sending_opeid==377800| ///sending_opeid==377900| ///sending_opeid==378000| ///sending_opeid==378100| ///sending_opeid==378200| ///sending_opeid==378300| ///sending_opeid==378400| ///sending_opeid==378500| ///sending_opeid==378600| ///sending_opeid==378700| ///sending_opeid==378703| ///sending_opeid==378800| ///sending_opeid==379000| ///sending_opeid==379100| ///sending_opeid==379200| ///sending_opeid==379300| ///sending_opeid==379400| ///sending_opeid==379600)replace vsending_opeid=1 if firstime==5 & (sending_opeid==379700| ///sending_opeid==379800| ///sending_opeid==379900| ///sending_opeid==380000| ///sending_opeid==380001| ///sending_opeid==380100| ///sending_opeid==380200| ///sending_opeid==380300| ///sending_opeid==380400| ///sending_opeid==380500| ///sending_opeid==380600| ///sending_opeid==380700| ///sending_opeid==380800| ///sending_opeid==380900| ///sending_opeid==381000| ///sending_opeid==381100| ///sending_opeid==381200| ///sending_opeid==381300| ///sending_opeid==381500| ///sending_opeid==381600| ///sending_opeid==381800| ///sending_opeid==381900| ///sending_opeid==382000| ///sending_opeid==382200| ///sending_opeid==382300| ///sending_opeid==382600| ///sending_opeid==382700| ///sending_opeid==382800| ///sending_opeid==383000| ///sending_opeid==383100| ///sending_opeid==383200| ///sending_opeid==383500| ///sending_opeid==383700| ///sending_opeid==383800| ///sending_opeid==383900| ///sending_opeid==384000| ///sending_opeid==384200| ///sending_opeid==384800| ///sending_opeid==385000| ///sending_opeid==385400| ///sending_opeid==385600| ///sending_opeid==386100| ///sending_opeid==386300| ///sending_opeid==386600| ///sending_opeid==386800| ///sending_opeid==386900| ///sending_opeid==387400| ///sending_opeid==387500| ///sending_opeid==388400| ///sending_opeid==389200| ///sending_opeid==389500| ///sending_opeid==389600| ///sending_opeid==389700| ///sending_opeid==389900| ///sending_opeid==391100| ///sending_opeid==391500| ///sending_opeid==391700| ///sending_opeid==391900| ///sending_opeid==392000| ///sending_opeid==392100| ///sending_opeid==392300| ///sending_opeid==392400| ///sending_opeid==392500| ///sending_opeid==392600| ///sending_opeid==392800| ///sending_opeid==392900| ///sending_opeid==393000| ///sending_opeid==393100| ///sending_opeid==393200| ///sending_opeid==393300| ///sending_opeid==393500| ///sending_opeid==393600| ///sending_opeid==393700| ///sending_opeid==393800| ///sending_opeid==393801| ///sending_opeid==393803| ///sending_opeid==393804| ///sending_opeid==393805| ///sending_opeid==393806| ///sending_opeid==393807| ///sending_opeid==393808| ///sending_opeid==393809| ///sending_opeid==393810| ///sending_opeid==393810| ///sending_opeid==393811| ///sending_opeid==394100| ///sending_opeid==394300| ///sending_opeid==394400| ///sending_opeid==394600| ///sending_opeid==394700| ///sending_opeid==394800| ///sending_opeid==395400| ///sending_opeid==395500| ///sending_opeid==395600| ///sending_opeid==396100| ///sending_opeid==396300| ///sending_opeid==396500| ///sending_opeid==396600| ///sending_opeid==396900| ///sending_opeid==397400| ///sending_opeid==397600| ///sending_opeid==397700| ///sending_opeid==397800| ///sending_opeid==397900| ///sending_opeid==398100| ///sending_opeid==398200| ///sending_opeid==398500| ///sending_opeid==398600| ///sending_opeid==398700| ///sending_opeid==398800| ///sending_opeid==399000| ///sending_opeid==399100| ///sending_opeid==399200| ///sending_opeid==399300| ///sending_opeid==399400| ///sending_opeid==399500| ///sending_opeid==399600| ///sending_opeid==399800| ///sending_opeid==399900| ///sending_opeid==400300| ///sending_opeid==400400| ///sending_opeid==400600| ///sending_opeid==400700| ///sending_opeid==400900| ///sending_opeid==402400| ///sending_opeid==402500| ///sending_opeid==402600| ///sending_opeid==402700| ///sending_opeid==403300| ///sending_opeid==405400| ///sending_opeid==405600| ///sending_opeid==405700| ///sending_opeid==405800| ///sending_opeid==406000| ///sending_opeid==406100| ///sending_opeid==406200| ///sending_opeid==406900| ///sending_opeid==407100| ///sending_opeid==407200| ///sending_opeid==407500| ///sending_opeid==407600| ///sending_opeid==408000| ///sending_opeid==411700| ///sending_opeid==418100| ///sending_opeid==420300| ///sending_opeid==423300| ///sending_opeid==431100| ///sending_opeid==441300| ///sending_opeid==442500| ///sending_opeid==443100| ///sending_opeid==443600| ///sending_opeid==445200| ///sending_opeid==445300| ///sending_opeid==446200| ///sending_opeid==446700| ///sending_opeid==448000| ///sending_opeid==448100| ///sending_opeid==448400| ///sending_opeid==449000| ///sending_opeid==449400| ///sending_opeid==450200| ///sending_opeid==450300| ///sending_opeid==450600| ///sending_opeid==450700| ///sending_opeid==450800| ///sending_opeid==450900| ///sending_opeid==451300| ///sending_opeid==454900| ///sending_opeid==456000| ///sending_opeid==456800| ///sending_opeid==457100| ///sending_opeid==457900| ///sending_opeid==457901| ///sending_opeid==458600| ///sending_opeid==458614| ///sending_opeid==458615| ///sending_opeid==458700| ///sending_opeid==459500| ///sending_opeid==459800| ///sending_opeid==460000| ///sending_opeid==460800| ///sending_opeid==461700| ///sending_opeid==461800| ///sending_opeid==461900| ///sending_opeid==462100| ///sending_opeid==462500| ///sending_opeid==464100| ///sending_opeid==464200| ///sending_opeid==464500| ///sending_opeid==464600| ///sending_opeid==465000| ///sending_opeid==466100| ///sending_opeid==466600| ///sending_opeid==466700| ///sending_opeid==466900| ///sending_opeid==467300| ///sending_opeid==469200| ///sending_opeid==469700| ///sending_opeid==470300| ///sending_opeid==470700| ///sending_opeid==471100| ///sending_opeid==471300| ///sending_opeid==472900| ///sending_opeid==473000| ///sending_opeid==473100| ///sending_opeid==473300| ///sending_opeid==473600| ///sending_opeid==473900| ///sending_opeid==474000| ///sending_opeid==474200| ///sending_opeid==474300| ///sending_opeid==475900| ///sending_opeid==476500| ///sending_opeid==477600| ///sending_opeid==478800| ///sending_opeid==479800| ///sending_opeid==479900| ///sending_opeid==481100| ///sending_opeid==482500| ///sending_opeid==483500| ///sending_opeid==483800| ///sending_opeid==484400| ///sending_opeid==484500| ///sending_opeid==485200| ///sending_opeid==485300| ///sending_opeid==485500| ///sending_opeid==486100| ///sending_opeid==486600| ///sending_opeid==487800| ///sending_opeid==488200| ///sending_opeid==488700| ///sending_opeid==488900| ///sending_opeid==489000| ///sending_opeid==489300| ///sending_opeid==489400| ///sending_opeid==489800| ///sending_opeid==489900| ///sending_opeid==490100| ///sending_opeid==490200| ///sending_opeid==491000| ///sending_opeid==491002| ///sending_opeid==491400| ///sending_opeid==492000| ///sending_opeid==492300| ///sending_opeid==492400| ///sending_opeid==492500| ///sending_opeid==492600| ///sending_opeid==492900| ///sending_opeid==493401)replace vsending_opeid=1 if firstime==5 & (sending_opeid==493700| ///sending_opeid==493800| ///sending_opeid==494700| ///sending_opeid==494900| ///sending_opeid==495100| ///sending_opeid==495200| ///sending_opeid==497200| ///sending_opeid==497700| ///sending_opeid==498800| ///sending_opeid==499200| ///sending_opeid==499600| ///sending_opeid==499800| ///sending_opeid==499900| ///sending_opeid==500003| ///sending_opeid==500100| ///sending_opeid==500600| ///sending_opeid==500700| ///sending_opeid==500800| ///sending_opeid==501500| ///sending_opeid==501900| ///sending_opeid==502200| ///sending_opeid==506400| ///sending_opeid==506600| ///sending_opeid==510200| ///sending_opeid==512725| ///sending_opeid==520400| ///sending_opeid==520800| ///sending_opeid==521000| ///sending_opeid==522000| ///sending_opeid==522300| ///sending_opeid==524400| ///sending_opeid==524500| ///sending_opeid==525200| ///sending_opeid==525400| ///sending_opeid==525500| ///sending_opeid==525600| ///sending_opeid==525800| ///sending_opeid==526000| ///sending_opeid==526300| ///sending_opeid==526400| ///sending_opeid==526500| ///sending_opeid==526700| ///sending_opeid==527100| ///sending_opeid==527300| ///sending_opeid==527600| ///sending_opeid==527700| ///sending_opeid==527900| ///sending_opeid==528000| ///sending_opeid==528100| ///sending_opeid==528200| ///sending_opeid==528300| ///sending_opeid==528800| ///sending_opeid==528900| ///sending_opeid==528900| ///sending_opeid==529100| ///sending_opeid==529100| ///sending_opeid==529400| ///sending_opeid==530100| ///sending_opeid==530400| ///sending_opeid==530600| ///sending_opeid==530700| ///sending_opeid==530900| ///sending_opeid==531000| ///sending_opeid==531100| ///sending_opeid==531102| ///sending_opeid==531103| ///sending_opeid==531104| ///sending_opeid==531200| ///sending_opeid==531300| ///sending_opeid==531600| ///sending_opeid==531700| ///sending_opeid==531800| ///sending_opeid==532000| ///sending_opeid==533000| ///sending_opeid==533500| ///sending_opeid==533900| ///sending_opeid==534100| ///sending_opeid==535100| ///sending_opeid==535200| ///sending_opeid==535300| ///sending_opeid==535400| ///sending_opeid==535600| ///sending_opeid==535700| ///sending_opeid==535800| ///sending_opeid==535900| ///sending_opeid==536000| ///sending_opeid==536300| ///sending_opeid==536500| ///sending_opeid==537200| ///sending_opeid==537300| ///sending_opeid==537800| ///sending_opeid==537900| ///sending_opeid==538000| ///sending_opeid==538400| ///sending_opeid==538700| ///sending_opeid==538900| ///sending_opeid==539000| ///sending_opeid==542400| ///sending_opeid==542600| ///sending_opeid==542900| ///sending_opeid==543000| ///sending_opeid==543800| ///sending_opeid==544500| ///sending_opeid==544700| ///sending_opeid==544800| ///sending_opeid==544900| ///sending_opeid==545200| ///sending_opeid==546000| ///sending_opeid==546100| ///sending_opeid==546300| ///sending_opeid==546400| ///sending_opeid==546700| ///sending_opeid==548800| ///sending_opeid==548809| ///sending_opeid==548816| ///sending_opeid==548834| ///sending_opeid==548835| ///sending_opeid==548841| ///sending_opeid==548900| ///sending_opeid==549800| ///sending_opeid==549900| ///sending_opeid==550000| ///sending_opeid==551100| ///sending_opeid==551900| ///sending_opeid==552300| ///sending_opeid==552500| ///sending_opeid==552600| ///sending_opeid==553100| ///sending_opeid==553200| ///sending_opeid==553300| ///sending_opeid==553400| ///sending_opeid==553500| ///sending_opeid==553700| ///sending_opeid==554100| ///sending_opeid==554400| ///sending_opeid==555700| ///sending_opeid==558500| ///sending_opeid==558600| ///sending_opeid==559400| ///sending_opeid==559600| ///sending_opeid==559900| ///sending_opeid==560000| ///sending_opeid==560100| ///sending_opeid==560500| ///sending_opeid==560700| ///sending_opeid==560800| ///sending_opeid==561200| ///sending_opeid==561300| ///sending_opeid==561400| ///sending_opeid==561500| ///sending_opeid==561700| ///sending_opeid==561800| ///sending_opeid==561900| ///sending_opeid==562000| ///sending_opeid==562004| ///sending_opeid==562005| ///sending_opeid==562100| ///sending_opeid==562200| ///sending_opeid==562400| ///sending_opeid==563800| ///sending_opeid==565500| ///sending_opeid==569100| ///sending_opeid==569200| ///sending_opeid==569700| ///sending_opeid==569900| ///sending_opeid==570700| ///sending_opeid==573200| ///sending_opeid==573300| ///sending_opeid==573400| ///sending_opeid==575200| ///sending_opeid==575300| ///sending_opeid==575400| ///sending_opeid==575700| ///sending_opeid==575900| ///sending_opeid==576000| ///sending_opeid==576100| ///sending_opeid==576300| ///sending_opeid==577600| ///sending_opeid==584701| ///sending_opeid==594200| ///sending_opeid==598700| ///sending_opeid==610800| ///sending_opeid==611500| ///sending_opeid==612600| ///sending_opeid==613100| ///sending_opeid==613600| ///sending_opeid==616500| ///sending_opeid==618100| ///sending_opeid==619100| ///sending_opeid==621402| ///sending_opeid==621403| ///sending_opeid==622500| ///sending_opeid==622800| ///sending_opeid==624000| ///sending_opeid==625700| ///sending_opeid==626700| ///sending_opeid==627300| ///sending_opeid==630502| ///sending_opeid==630503| ///sending_opeid==632200| ///sending_opeid==632400| ///sending_opeid==633100| ///sending_opeid==635202| ///sending_opeid==638500| ///sending_opeid==638900| ///sending_opeid==639200| ///sending_opeid==639202| ///sending_opeid==639203| ///sending_opeid==639900| ///sending_opeid==640400| ///sending_opeid==641700| ///sending_opeid==642000| ///sending_opeid==642100| ///sending_opeid==642100| ///sending_opeid==642101| ///sending_opeid==642901| ///sending_opeid==642902| ///sending_opeid==643500| ///sending_opeid==643502| ///sending_opeid==643800| ///sending_opeid==644300| ///sending_opeid==644500| ///sending_opeid==644800| ///sending_opeid==646101| ///sending_opeid==646102| ///sending_opeid==646700| ///sending_opeid==647700| ///sending_opeid==647800| ///sending_opeid==648200| ///sending_opeid==648300| ///sending_opeid==648700| ///sending_opeid==648900| ///sending_opeid==649400| ///sending_opeid==650700| ///sending_opeid==653400| ///sending_opeid==653700| ///sending_opeid==655100| ///sending_opeid==656000| ///sending_opeid==656500| ///sending_opeid==657400| ///sending_opeid==657600| ///sending_opeid==657700| ///sending_opeid==657702| ///sending_opeid==657800| ///sending_opeid==658201| ///sending_opeid==658202| ///sending_opeid==658300| ///sending_opeid==659100| ///sending_opeid==660600)replace vsending_opeid=1 if firstime==5 & (sending_opeid==661200| ///sending_opeid==662200| ///sending_opeid==663900| ///sending_opeid==665600| ///sending_opeid==666100| ///sending_opeid==666600| ///sending_opeid==672000| ///sending_opeid==673100| ///sending_opeid==675000| ///sending_opeid==675300| ///sending_opeid==675500| ///sending_opeid==675600| ///sending_opeid==676000| ///sending_opeid==676800| ///sending_opeid==677100| ///sending_opeid==677500| ///sending_opeid==677700| ///sending_opeid==678200| ///sending_opeid==678500| ///sending_opeid==678700| ///sending_opeid==678800| ///sending_opeid==678900| ///sending_opeid==679100| ///sending_opeid==679900| ///sending_opeid==680400| ///sending_opeid==680700| ///sending_opeid==681000| ///sending_opeid==681100| ///sending_opeid==681500| ///sending_opeid==681900| ///sending_opeid==683500| ///sending_opeid==683600| ///sending_opeid==685800| ///sending_opeid==686300| ///sending_opeid==686500| ///sending_opeid==686700| ///sending_opeid==687100| ///sending_opeid==687300| ///sending_opeid==689500| ///sending_opeid==690100| ///sending_opeid==691100| ///sending_opeid==693100| ///sending_opeid==693800| ///sending_opeid==694100| ///sending_opeid==694200| ///sending_opeid==694900| ///sending_opeid==695100| ///sending_opeid==696000| ///sending_opeid==696100| ///sending_opeid==696103| ///sending_opeid==696200| ///sending_opeid==697300| ///sending_opeid==697500| ///sending_opeid==697700| ///sending_opeid==698200| ///sending_opeid==700600| ///sending_opeid==701200| ///sending_opeid==702200| ///sending_opeid==702500| ///sending_opeid==702600| ///sending_opeid==703100| ///sending_opeid==703200| ///sending_opeid==703500| ///sending_opeid==704400| ///sending_opeid==704700| ///sending_opeid==705000| ///sending_opeid==705300| ///sending_opeid==708500| ///sending_opeid==708700| ///sending_opeid==709000| ///sending_opeid==709100| ///sending_opeid==709600| ///sending_opeid==709900| ///sending_opeid==710700| ///sending_opeid==710800| ///sending_opeid==710900| ///sending_opeid==711000| ///sending_opeid==711100| ///sending_opeid==711300| ///sending_opeid==711500| ///sending_opeid==711800| ///sending_opeid==711900| ///sending_opeid==712000| ///sending_opeid==712100| ///sending_opeid==713000| ///sending_opeid==714200| ///sending_opeid==716400| ///sending_opeid==717000| ///sending_opeid==717100| ///sending_opeid==717800| ///sending_opeid==718700| ///sending_opeid==719000| ///sending_opeid==719001| ///sending_opeid==719100| ///sending_opeid==720300| ///sending_opeid==720400| ///sending_opeid==720500| ///sending_opeid==720600| ///sending_opeid==721000| ///sending_opeid==721900| ///sending_opeid==722600| ///sending_opeid==722800| ///sending_opeid==722900| ///sending_opeid==725300| ///sending_opeid==725800| ///sending_opeid==726000| ///sending_opeid==726300| ///sending_opeid==726400| ///sending_opeid==726500| ///sending_opeid==726600| ///sending_opeid==727300| ///sending_opeid==727500| ///sending_opeid==727600| ///sending_opeid==727900| ///sending_opeid==728300| ///sending_opeid==728700| ///sending_opeid==728900| ///sending_opeid==729100| ///sending_opeid==729600| ///sending_opeid==729700| ///sending_opeid==730000| ///sending_opeid==730300| ///sending_opeid==730301| ///sending_opeid==730302| ///sending_opeid==730303| ///sending_opeid==730305| ///sending_opeid==730306| ///sending_opeid==730307| ///sending_opeid==730400| ///sending_opeid==730500| ///sending_opeid==731100| ///sending_opeid==731600| ///sending_opeid==732900| ///sending_opeid==734100| ///sending_opeid==735000| ///sending_opeid==735100| ///sending_opeid==736200| ///sending_opeid==736700| ///sending_opeid==737100| ///sending_opeid==737200| ///sending_opeid==737500| ///sending_opeid==738700| ///sending_opeid==738800| ///sending_opeid==739100| ///sending_opeid==739101| ///sending_opeid==739400| ///sending_opeid==739800| ///sending_opeid==740100| ///sending_opeid==740500| ///sending_opeid==743000| ///sending_opeid==743600| ///sending_opeid==743700| ///sending_opeid==743900| ///sending_opeid==744700| ///sending_opeid==745600| ///sending_opeid==745700| ///sending_opeid==745900| ///sending_opeid==746200| ///sending_opeid==746500| ///sending_opeid==746600| ///sending_opeid==746800| ///sending_opeid==746900| ///sending_opeid==747000| ///sending_opeid==747300| ///sending_opeid==747600| ///sending_opeid==748100| ///sending_opeid==748400| ///sending_opeid==748600| ///sending_opeid==748800| ///sending_opeid==748801| ///sending_opeid==749100| ///sending_opeid==750100| ///sending_opeid==750103| ///sending_opeid==750200| ///sending_opeid==750700| ///sending_opeid==750703| ///sending_opeid==751800| ///sending_opeid==752200| ///sending_opeid==752500| ///sending_opeid==752600| ///sending_opeid==752900| ///sending_opeid==753100| ///sending_opeid==753200| ///sending_opeid==753600| ///sending_opeid==754000| ///sending_opeid==754400| ///sending_opeid==754800| ///sending_opeid==754900| ///sending_opeid==755500| ///sending_opeid==755800| ///sending_opeid==756000| ///sending_opeid==757000| ///sending_opeid==757200| ///sending_opeid==757300| ///sending_opeid==757800| ///sending_opeid==757802| ///sending_opeid==758200| ///sending_opeid==758604| ///sending_opeid==758605| ///sending_opeid==758800| ///sending_opeid==759300| ///sending_opeid==759800| ///sending_opeid==760000| ///sending_opeid==760200| ///sending_opeid==760500| ///sending_opeid==760600| ///sending_opeid==760700| ///sending_opeid==761100| ///sending_opeid==761700| ///sending_opeid==763500| ///sending_opeid==764000| ///sending_opeid==764400| ///sending_opeid==764900| ///sending_opeid==765600| ///sending_opeid==765800| ///sending_opeid==765900| ///sending_opeid==766900| ///sending_opeid==767800| ///sending_opeid==768400| ///sending_opeid==768600| ///sending_opeid==768700| ///sending_opeid==769000| ///sending_opeid==769100| ///sending_opeid==769200| ///sending_opeid==769300| ///sending_opeid==769400| ///sending_opeid==770700| ///sending_opeid==771300| ///sending_opeid==771700| ///sending_opeid==772800| ///sending_opeid==772900| ///sending_opeid==773000| ///sending_opeid==773100| ///sending_opeid==773800| ///sending_opeid==775600| ///sending_opeid==776400| ///sending_opeid==777400| ///sending_opeid==777500| ///sending_opeid==777900| ///sending_opeid==778000| ///sending_opeid==778100| ///sending_opeid==778200| ///sending_opeid==778300| ///sending_opeid==779000| ///sending_opeid==780400| ///sending_opeid==780401| ///sending_opeid==780402| ///sending_opeid==781400| ///sending_opeid==781900)replace vsending_opeid=1 if firstime==5 & (sending_opeid==782600| ///sending_opeid==783900| ///sending_opeid==784500| ///sending_opeid==787000| ///sending_opeid==787100| ///sending_opeid==789200| ///sending_opeid==789300| ///sending_opeid==790000| ///sending_opeid==790400| ///sending_opeid==791100| ///sending_opeid==791200| ///sending_opeid==791600| ///sending_opeid==792100| ///sending_opeid==792600| ///sending_opeid==793000| ///sending_opeid==793300| ///sending_opeid==793600| ///sending_opeid==793700| ///sending_opeid==793800| ///sending_opeid==793803| ///sending_opeid==793804| ///sending_opeid==793806| ///sending_opeid==793807| ///sending_opeid==793808| ///sending_opeid==793809| ///sending_opeid==793810| ///sending_opeid==793811| ///sending_opeid==794100| ///sending_opeid==794700| ///sending_opeid==794800| ///sending_opeid==795000| ///sending_opeid==795400| ///sending_opeid==798500| ///sending_opeid==798600| ///sending_opeid==798700| ///sending_opeid==798800| ///sending_opeid==799300| ///sending_opeid==803700| ///sending_opeid==803800| ///sending_opeid==807100| ///sending_opeid==807300| ///sending_opeid==807500| ///sending_opeid==807600| ///sending_opeid==807800| ///sending_opeid==808000| ///sending_opeid==808100| ///sending_opeid==808200| ///sending_opeid==808300| ///sending_opeid==808500| ///sending_opeid==808700| ///sending_opeid==809000| ///sending_opeid==809002| ///sending_opeid==811600| ///sending_opeid==812900| ///sending_opeid==813200| ///sending_opeid==813300| ///sending_opeid==814500| ///sending_opeid==815500| ///sending_opeid==817200| ///sending_opeid==817500| ///sending_opeid==817800| ///sending_opeid==817801| ///sending_opeid==818900| ///sending_opeid==818903| ///sending_opeid==819400| ///sending_opeid==820000| ///sending_opeid==821700| ///sending_opeid==822100| ///sending_opeid==822101| ///sending_opeid==822103| ///sending_opeid==822104| ///sending_opeid==822105| ///sending_opeid==822300| ///sending_opeid==822800| ///sending_opeid==824400| ///sending_opeid==824600| ///sending_opeid==825900| ///sending_opeid==825901| ///sending_opeid==826000| ///sending_opeid==826300| ///sending_opeid==826700| ///sending_opeid==826900| ///sending_opeid==827800| ///sending_opeid==828400| ///sending_opeid==830300| ///sending_opeid==830400| ///sending_opeid==830800| ///sending_opeid==831000| ///sending_opeid==832800| ///sending_opeid==832801| ///sending_opeid==833200| ///sending_opeid==834300| ///sending_opeid==835000| ///sending_opeid==835500| ///sending_opeid==840300| ///sending_opeid==840400| ///sending_opeid==841700| ///sending_opeid==842400| ///sending_opeid==842500| ///sending_opeid==843500| ///sending_opeid==843700| ///sending_opeid==844103| ///sending_opeid==846600| ///sending_opeid==848300| ///sending_opeid==849200| ///sending_opeid==849300| ///sending_opeid==849400| ///sending_opeid==849500| ///sending_opeid==849800| ///sending_opeid==850300| ///sending_opeid==850400| ///sending_opeid==851000| ///sending_opeid==853700| ///sending_opeid==854300| ///sending_opeid==854400| ///sending_opeid==855200| ///sending_opeid==855700| ///sending_opeid==855800| ///sending_opeid==856800| ///sending_opeid==857500| ///sending_opeid==859200| ///sending_opeid==859600| ///sending_opeid==859700| ///sending_opeid==860600| ///sending_opeid==860900| ///sending_opeid==861100| ///sending_opeid==861200| ///sending_opeid==861300| ///sending_opeid==861400| ///sending_opeid==861700| ///sending_opeid==861900| ///sending_opeid==863500| ///sending_opeid==864500| ///sending_opeid==865300| ///sending_opeid==865500| ///sending_opeid==865800| ///sending_opeid==865900| ///sending_opeid==866000| ///sending_opeid==866100| ///sending_opeid==867700| ///sending_opeid==868200| ///sending_opeid==869412| ///sending_opeid==884400| ///sending_opeid==884600| ///sending_opeid==884800| ///sending_opeid==884900| ///sending_opeid==885500| ///sending_opeid==885900| ///sending_opeid==886000| ///sending_opeid==886200| ///sending_opeid==886300| ///sending_opeid==886400| ///sending_opeid==887100| ///sending_opeid==887200| ///sending_opeid==887300| ///sending_opeid==887400| ///sending_opeid==887402| ///sending_opeid==887403| ///sending_opeid==887800| ///sending_opeid==888000| ///sending_opeid==888600| ///sending_opeid==888700| ///sending_opeid==888900| ///sending_opeid==889100| ///sending_opeid==889600| ///sending_opeid==890200| ///sending_opeid==890300| ///sending_opeid==890600| ///sending_opeid==891600| ///sending_opeid==891800| ///sending_opeid==893800| ///sending_opeid==893900| ///sending_opeid==894600| ///sending_opeid==894700| ///sending_opeid==895500| ///sending_opeid==895900| ///sending_opeid==897600| ///sending_opeid==898100| ///sending_opeid==898800| ///sending_opeid==900300| ///sending_opeid==901000| ///sending_opeid==902200| ///sending_opeid==902900| ///sending_opeid==903200| ///sending_opeid==903800| ///sending_opeid==904300| ///sending_opeid==904700| ///sending_opeid==905400| ///sending_opeid==905800| ///sending_opeid==905803| ///sending_opeid==906500| ///sending_opeid==907700| ///sending_opeid==907800| ///sending_opeid==907900| ///sending_opeid==908204| ///sending_opeid==908900| ///sending_opeid==910400| ///sending_opeid==912900| ///sending_opeid==913500| ///sending_opeid==914500| ///sending_opeid==915600| ///sending_opeid==915700| ///sending_opeid==915705| ///sending_opeid==915706| ///sending_opeid==915800| ///sending_opeid==915900| ///sending_opeid==916000| ///sending_opeid==916300| ///sending_opeid==917200| ///sending_opeid==918300| ///sending_opeid==918500| ///sending_opeid==918600| ///sending_opeid==919200| ///sending_opeid==919400| ///sending_opeid==920401| ///sending_opeid==920402| ///sending_opeid==920403| ///sending_opeid==920404| ///sending_opeid==920405| ///sending_opeid==920406| ///sending_opeid==920407| ///sending_opeid==920408| ///sending_opeid==920409| ///sending_opeid==922500| ///sending_opeid==922600| ///sending_opeid==923000| ///sending_opeid==923100| ///sending_opeid==923200| ///sending_opeid==923600| ///sending_opeid==924800| ///sending_opeid==925600| ///sending_opeid==925900| ///sending_opeid==926700| ///sending_opeid==927000| ///sending_opeid==927200| ///sending_opeid==927500| ///sending_opeid==927700| ///sending_opeid==927700| ///sending_opeid==928300| ///sending_opeid==928400| ///sending_opeid==928401| ///sending_opeid==929100| ///sending_opeid==931300| ///sending_opeid==931302| ///sending_opeid==931400| ///sending_opeid==932200| ///sending_opeid==932500| ///sending_opeid==933300| ///sending_opeid==933500)replace vsending_opeid=1 if firstime==5 & (sending_opeid==933600| ///sending_opeid==934400| ///sending_opeid==934500| ///sending_opeid==935400| ///sending_opeid==938700| ///sending_opeid==940100| ///sending_opeid==940700| ///sending_opeid==941200| ///sending_opeid==941202| ///sending_opeid==941900| ///sending_opeid==942000| ///sending_opeid==943000| ///sending_opeid==943300| ///sending_opeid==944900| ///sending_opeid==945900| ///sending_opeid==945901| ///sending_opeid==945902| ///sending_opeid==945904| ///sending_opeid==946400| ///sending_opeid==946600| ///sending_opeid==946607| ///sending_opeid==946609| ///sending_opeid==946610| ///sending_opeid==946800| ///sending_opeid==947500| ///sending_opeid==947900| ///sending_opeid==950700| ///sending_opeid==950900| ///sending_opeid==951500| ///sending_opeid==952000| ///sending_opeid==952300| ///sending_opeid==953000| ///sending_opeid==953100| ///sending_opeid==953500| ///sending_opeid==953700| ///sending_opeid==954200| ///sending_opeid==954300| ///sending_opeid==954400| ///sending_opeid==954900| ///sending_opeid==956700| ///sending_opeid==958100| ///sending_opeid==959000| ///sending_opeid==959300| ///sending_opeid==959500| ///sending_opeid==960000| ///sending_opeid==960700| ///sending_opeid==961200| ///sending_opeid==961300| ///sending_opeid==961500| ///sending_opeid==961700| ///sending_opeid==961800| ///sending_opeid==962900| ///sending_opeid==963500| ///sending_opeid==964100| ///sending_opeid==964500| ///sending_opeid==964600| ///sending_opeid==964700| ///sending_opeid==965100| ///sending_opeid==965200| ///sending_opeid==965800| ///sending_opeid==966000| ///sending_opeid==966400| ///sending_opeid==966401| ///sending_opeid==966402| ///sending_opeid==967300| ///sending_opeid==967302| ///sending_opeid==967400| ///sending_opeid==967401| ///sending_opeid==968400| ///sending_opeid==970400| ///sending_opeid==970600| ///sending_opeid==970700| ///sending_opeid==970800| ///sending_opeid==971000| ///sending_opeid==972100| ///sending_opeid==972200| ///sending_opeid==972300| ///sending_opeid==973200| ///sending_opeid==973400| ///sending_opeid==973700| ///sending_opeid==973900| ///sending_opeid==974000| ///sending_opeid==974100| ///sending_opeid==974300| ///sending_opeid==974400| ///sending_opeid==974700| ///sending_opeid==974800| ///sending_opeid==974806| ///sending_opeid==974807| ///sending_opeid==974808| ///sending_opeid==975600| ///sending_opeid==976300| ///sending_opeid==976400| ///sending_opeid==976500| ///sending_opeid==976700| ///sending_opeid==976800| ///sending_opeid==976900| ///sending_opeid==977700| ///sending_opeid==978200| ///sending_opeid==979500| ///sending_opeid==979700| ///sending_opeid==980000| ///sending_opeid==982200| ///sending_opeid==982600| ///sending_opeid==982800| ///sending_opeid==982801| ///sending_opeid==982802| ///sending_opeid==982803| ///sending_opeid==982804| ///sending_opeid==983100| ///sending_opeid==984100| ///sending_opeid==985500| ///sending_opeid==986200| ///sending_opeid==986300| ///sending_opeid==987300| ///sending_opeid==987700| ///sending_opeid==988100| ///sending_opeid==988600| ///sending_opeid==989200| ///sending_opeid==989600| ///sending_opeid==989800| ///sending_opeid==989900| ///sending_opeid==990200| ///sending_opeid==990300| ///sending_opeid==991000| ///sending_opeid==991200| ///sending_opeid==991400| ///sending_opeid==991700| ///sending_opeid==992800| ///sending_opeid==992900| ///sending_opeid==993000| ///sending_opeid==993200| ///sending_opeid==993600| ///sending_opeid==994100| ///sending_opeid==994200| ///sending_opeid==995800| ///sending_opeid==996200| ///sending_opeid==996300| ///sending_opeid==996400| ///sending_opeid==996500| ///sending_opeid==996800| ///sending_opeid==997500| ///sending_opeid==997600| ///sending_opeid==998100| ///sending_opeid==998200| ///sending_opeid==998700| ///sending_opeid==998900| ///sending_opeid==999200| ///sending_opeid==999400| ///sending_opeid==1000600| ///sending_opeid==1001000| ///sending_opeid==1001400| ///sending_opeid==1001700| ///sending_opeid==1001900| ///sending_opeid==1002000| ///sending_opeid==1002700| ///sending_opeid==1004300| ///sending_opeid==1005100| ///sending_opeid==1005200| ///sending_opeid==1005300| ///sending_opeid==1005301| ///sending_opeid==1005302| ///sending_opeid==1005303| ///sending_opeid==1005500| ///sending_opeid==1005600| ///sending_opeid==1005700| ///sending_opeid==1005900| ///sending_opeid==1006000| ///sending_opeid==1006500| ///sending_opeid==1007400| ///sending_opeid==1009700| ///sending_opeid==1009800| ///sending_opeid==1011100| ///sending_opeid==1011500| ///sending_opeid==1012200| ///sending_opeid==1013000| ///sending_opeid==1013800| ///sending_opeid==1014000| ///sending_opeid==1014200| ///sending_opeid==1014700| ///sending_opeid==1014800| ///sending_opeid==1014900| ///sending_opeid==1015100| ///sending_opeid==1015300| ///sending_opeid==1016100| ///sending_opeid==1016800| ///sending_opeid==1017000| ///sending_opeid==1017300| ///sending_opeid==1017600| ///sending_opeid==1018200| ///sending_opeid==1019500| ///sending_opeid==1019800| ///sending_opeid==1021700| ///sending_opeid==1021703| ///sending_opeid==1024800| ///sending_opeid==1025600| ///sending_opeid==1026400| ///sending_opeid==1026600| ///sending_opeid==1027900| ///sending_opeid==1028000| ///sending_opeid==1028600| ///sending_opeid==1031900| ///sending_opeid==1031903| ///sending_opeid==1032300| ///sending_opeid==1032600| ///sending_opeid==1033800| ///sending_opeid==1034000| ///sending_opeid==1034200| ///sending_opeid==1034300| ///sending_opeid==1034500| ///sending_opeid==1035600| ///sending_opeid==1035601| ///sending_opeid==1035602| ///sending_opeid==1036200| ///sending_opeid==1036300| ///sending_opeid==1036400| ///sending_opeid==1036500| ///sending_opeid==1036800| ///sending_opeid==1037400| ///sending_opeid==1037500| ///sending_opeid==1037800| ///sending_opeid==1038700| ///sending_opeid==1038800| ///sending_opeid==1039100| ///sending_opeid==1039500| ///sending_opeid==1040200| ///sending_opeid==1040500| ///sending_opeid==1040501| ///sending_opeid==1040600| ///sending_opeid==1040900| ///sending_opeid==1041000| ///sending_opeid==1041700| ///sending_opeid==1042400| ///sending_opeid==1043400| ///sending_opeid==1043800| ///sending_opeid==1043900| ///sending_opeid==1044100| ///sending_opeid==1044500| ///sending_opeid==1044700| ///sending_opeid==1045300| ///sending_opeid==1046000| ///sending_opeid==1047000| ///sending_opeid==1047400| ///sending_opeid==1048700| ///sending_opeid==1049000| ///sending_opeid==1049100| ///sending_opeid==1050100| ///sending_opeid==1050300| ///sending_opeid==1050700)replace vsending_opeid=1 if firstime==5 & (sending_opeid==1050900| ///sending_opeid==1052900| ///sending_opeid==1053000| ///sending_opeid==1054200| ///sending_opeid==1054600| ///sending_opeid==1054900| ///sending_opeid==1055100| ///sending_opeid==1055400| ///sending_opeid==1056700| ///sending_opeid==1057300| ///sending_opeid==1057900| ///sending_opeid==1061800| ///sending_opeid==1062400| ///sending_opeid==1062900| ///sending_opeid==1063000| ///sending_opeid==1063200| ///sending_opeid==1063300| ///sending_opeid==1064100| ///sending_opeid==1065200| ///sending_opeid==1067400| ///sending_opeid==1068400| ///sending_opeid==1069500| ///sending_opeid==1070000| ///sending_opeid==1071000| ///sending_opeid==1071700| ///sending_opeid==1072400| ///sending_opeid==1073200| ///sending_opeid==1073600| ///sending_opeid==1073700| ///sending_opeid==1074100| ///sending_opeid==1076100| ///sending_opeid==1076200| ///sending_opeid==1076800| ///sending_opeid==1077100| ///sending_opeid==1077900| ///sending_opeid==1081300| ///sending_opeid==1081400| ///sending_opeid==1081900| ///sending_opeid==1082600| ///sending_opeid==1082700| ///sending_opeid==1083100| ///sending_opeid==1083600| ///sending_opeid==1083601| ///sending_opeid==1083603| ///sending_opeid==1083700| ///sending_opeid==1084700| ///sending_opeid==1085100| ///sending_opeid==1085101| ///sending_opeid==1085102| ///sending_opeid==1085400| ///sending_opeid==1085800| ///sending_opeid==1085801| ///sending_opeid==1085802| ///sending_opeid==1086000| ///sending_opeid==1086100| ///sending_opeid==1087900| ///sending_opeid==1088000| ///sending_opeid==1088100| ///sending_opeid==1090300| ///sending_opeid==1090600| ///sending_opeid==1091300| ///sending_opeid==1091302| ///sending_opeid==1091303| ///sending_opeid==1092200| ///sending_opeid==1092300| ///sending_opeid==1093000| ///sending_opeid==1093200| ///sending_opeid==1094300| ///sending_opeid==1095200| ///sending_opeid==1096200| ///sending_opeid==1096300| ///sending_opeid==1096601| ///sending_opeid==1097500| ///sending_opeid==1099300| ///sending_opeid==1099700| ///sending_opeid==1099800| ///sending_opeid==1100500| ///sending_opeid==1100900| ///sending_opeid==1102400| ///sending_opeid==1102401| ///sending_opeid==1102600| ///sending_opeid==1103100| ///sending_opeid==1104600| ///sending_opeid==1107400| ///sending_opeid==1109700| ///sending_opeid==1109800| ///sending_opeid==1110700| ///sending_opeid==1110900| ///sending_opeid==1110901| ///sending_opeid==1110902| ///sending_opeid==1111200| ///sending_opeid==1111300| ///sending_opeid==1111700| ///sending_opeid==1112100| ///sending_opeid==1112102| ///sending_opeid==1112300| ///sending_opeid==1112301| ///sending_opeid==1112700| ///sending_opeid==1113300| ///sending_opeid==1114500| ///sending_opeid==1115000| ///sending_opeid==1115900| ///sending_opeid==1116100| ///sending_opeid==1116300| ///sending_opeid==1116500| ///sending_opeid==1116600| ///sending_opeid==1116601| ///sending_opeid==1116602| ///sending_opeid==1116700| ///sending_opeid==1118900| ///sending_opeid==1119200| ///sending_opeid==1119400| ///sending_opeid==1119700| ///sending_opeid==1120300| ///sending_opeid==1120600| ///sending_opeid==1121000| ///sending_opeid==1122000| ///sending_opeid==1123700| ///sending_opeid==1124500| ///sending_opeid==1138500| ///sending_opeid==1141700| ///sending_opeid==1146000| ///sending_opeid==1146100| ///sending_opeid==1146200| ///sending_opeid==1146205| ///sending_opeid==1147700| ///sending_opeid==1147900| ///sending_opeid==1148100| ///sending_opeid==1148400| ///sending_opeid==1149600| ///sending_opeid==1150500| ///sending_opeid==1151000| ///sending_opeid==1151002| ///sending_opeid==1151900| ///sending_opeid==1152300| ///sending_opeid==1153700| ///sending_opeid==1155300| ///sending_opeid==1157000| ///sending_opeid==1157200| ///sending_opeid==1157400| ///sending_opeid==1159600| ///sending_opeid==1161400| ///sending_opeid==1161700| ///sending_opeid==1162100| ///sending_opeid==1162101| ///sending_opeid==1162200| ///sending_opeid==1162600| ///sending_opeid==1162600| ///sending_opeid==1163100| ///sending_opeid==1164400| ///sending_opeid==1164600| ///sending_opeid==1164700| ///sending_opeid==1164900| ///sending_opeid==1166700| ///sending_opeid==1167000| ///sending_opeid==1167200| ///sending_opeid==1167300| ///sending_opeid==1167700| ///sending_opeid==1167800| ///sending_opeid==1168900| ///sending_opeid==1169600| ///sending_opeid==1169700| ///sending_opeid==1170300| ///sending_opeid==1170700| ///sending_opeid==1170702| ///sending_opeid==1171100| ///sending_opeid==1171500| ///sending_opeid==1171900| ///sending_opeid==1172500| ///sending_opeid==1172700| ///sending_opeid==1173200| ///sending_opeid==1173500| ///sending_opeid==1174400| ///sending_opeid==1174500| ///sending_opeid==1174501| ///sending_opeid==1174900| ///sending_opeid==1179200| ///sending_opeid==1179900| ///sending_opeid==1180200| ///sending_opeid==1181000| ///sending_opeid==1182000| ///sending_opeid==1182100| ///sending_opeid==1182400| ///sending_opeid==1182500| ///sending_opeid==1183000| ///sending_opeid==1184100| ///sending_opeid==1184101| ///sending_opeid==1184300| ///sending_opeid==1185800| ///sending_opeid==1185802| ///sending_opeid==1185803| ///sending_opeid==1185900| ///sending_opeid==1186200| ///sending_opeid==1186400| ///sending_opeid==1186500| ///sending_opeid==1186600| ///sending_opeid==1191100| ///sending_opeid==1191900| ///sending_opeid==1192100| ///sending_opeid==1192200| ///sending_opeid==1192600| ///sending_opeid==1193000| ///sending_opeid==1193400| ///sending_opeid==1194000| ///sending_opeid==1194100| ///sending_opeid==1195000| ///sending_opeid==1198400| ///sending_opeid==1198900| ///sending_opeid==1201100| ///sending_opeid==1201500| ///sending_opeid==1202000| ///sending_opeid==1202600| ///sending_opeid==1202700| ///sending_opeid==1202703| ///sending_opeid==1202704| ///sending_opeid==1203100| ///sending_opeid==1204200| ///sending_opeid==1205000| ///sending_opeid==1205100| ///sending_opeid==1205900| ///sending_opeid==1206100| ///sending_opeid==1206400| ///sending_opeid==1206800| ///sending_opeid==1207200| ///sending_opeid==1208800| ///sending_opeid==1209000| ///sending_opeid==1209200| ///sending_opeid==1210500| ///sending_opeid==1210700| ///sending_opeid==1212200| ///sending_opeid==1212300| ///sending_opeid==1212800| ///sending_opeid==1215400| ///sending_opeid==1216400| ///sending_opeid==1216500| ///sending_opeid==1216600| ///sending_opeid==1216601| ///sending_opeid==1216602| ///sending_opeid==1218200| ///sending_opeid==1218300| ///sending_opeid==1218400| ///sending_opeid==1218500| ///sending_opeid==1218700| ///sending_opeid==1220300| ///sending_opeid==1224800| ///sending_opeid==1226000| ///sending_opeid==1226100| ///sending_opeid==1226300| ///sending_opeid==1226800)replace vsending_opeid=1 if firstime==5 & (sending_opeid==1226801| ///sending_opeid==1227200| ///sending_opeid==1227700| ///sending_opeid==1229100| ///sending_opeid==1229300| ///sending_opeid==1229500| ///sending_opeid==1229700| ///sending_opeid==1230000| ///sending_opeid==1230800| ///sending_opeid==1230900| ///sending_opeid==1231500| ///sending_opeid==1231600| ///sending_opeid==1231700| ///sending_opeid==1232800| ///sending_opeid==1234300| ///sending_opeid==1234600| ///sending_opeid==1234700| ///sending_opeid==1234800| ///sending_opeid==1235000| ///sending_opeid==1235100| ///sending_opeid==1235800| ///sending_opeid==1235900| ///sending_opeid==1236200| ///sending_opeid==1236400| ///sending_opeid==1238600| ///sending_opeid==1239300| ///sending_opeid==1239900| ///sending_opeid==1240400| ///sending_opeid==1240700| ///sending_opeid==1241400| ///sending_opeid==1242500| ///sending_opeid==1244600| ///sending_opeid==1244601| ///sending_opeid==1244603| ///sending_opeid==1245200| ///sending_opeid==1246100| ///sending_opeid==1246106| ///sending_opeid==1246200| ///sending_opeid==1248100| ///sending_opeid==1248200| ///sending_opeid==1248209| ///sending_opeid==1248210| ///sending_opeid==1248300| ///sending_opeid==1248800| ///sending_opeid==1249600| ///sending_opeid==1250000| ///sending_opeid==1252300| ///sending_opeid==1252500| ///sending_opeid==1254400| ///sending_opeid==1254700| ///sending_opeid==1255000| ///sending_opeid==1256100| ///sending_opeid==1257300| ///sending_opeid==1257400| ///sending_opeid==1258000| ///sending_opeid==1258400| ///sending_opeid==1258401| ///sending_opeid==1258406| ///sending_opeid==1258600| ///sending_opeid==1258900| ///sending_opeid==1260100| ///sending_opeid==1260503| ///sending_opeid==1260600| ///sending_opeid==1260601| ///sending_opeid==1260602| ///sending_opeid==1260800| ///sending_opeid==1260801| ///sending_opeid==1261100| ///sending_opeid==1262700| ///sending_opeid==1265000| ///sending_opeid==1265200| ///sending_opeid==1266500| ///sending_opeid==1267000| ///sending_opeid==1267200| ///sending_opeid==1267400| ///sending_opeid==1269300| ///sending_opeid==1273200| ///sending_opeid==1274300| ///sending_opeid==1274400| ///sending_opeid==1275000| ///sending_opeid==1276400| ///sending_opeid==1278300| ///sending_opeid==1280300| ///sending_opeid==1281300| ///sending_opeid==1282300| ///sending_opeid==1283800| ///sending_opeid==1284200| ///sending_opeid==1284800| ///sending_opeid==1285000| ///sending_opeid==1286000| ///sending_opeid==1287000| ///sending_opeid==1287200| ///sending_opeid==1287201| ///sending_opeid==1287300| ///sending_opeid==1287301| ///sending_opeid==1287302| ///sending_opeid==1287500| ///sending_opeid==1287700| ///sending_opeid==1287900| ///sending_opeid==1288000| ///sending_opeid==1288100| ///sending_opeid==1289100| ///sending_opeid==1289101| ///sending_opeid==1289102| ///sending_opeid==1289600| ///sending_opeid==1290400| ///sending_opeid==1290500| ///sending_opeid==1290600| ///sending_opeid==1290700| ///sending_opeid==1291200| ///sending_opeid==1291300| ///sending_opeid==1292700| ///sending_opeid==1292900| ///sending_opeid==1293000| ///sending_opeid==1293100| ///sending_opeid==1293200| ///sending_opeid==1294200| ///sending_opeid==1294800| ///sending_opeid==1295400| ///sending_opeid==1297600| ///sending_opeid==1298200| ///sending_opeid==1298400| ///sending_opeid==1298500| ///sending_opeid==1298900| ///sending_opeid==1300300| ///sending_opeid==1300500| ///sending_opeid==1300600| ///sending_opeid==1300700| ///sending_opeid==1300800| ///sending_opeid==1301000| ///sending_opeid==1301600| ///sending_opeid==1302200| ///sending_opeid==1302600| ///sending_opeid==1302700| ///sending_opeid==1302900| ///sending_opeid==1303900| ///sending_opeid==1303904| ///sending_opeid==1303906| ///sending_opeid==1303907| ///sending_opeid==1303908| ///sending_opeid==1303912| ///sending_opeid==1303915| ///sending_opeid==1303918| ///sending_opeid==1307400| ///sending_opeid==1308700| ///sending_opeid==1308800| ///sending_opeid==1309400| ///sending_opeid==1309500| ///sending_opeid==1310300| ///sending_opeid==1313200| ///sending_opeid==1313400| ///sending_opeid==1314800| ///sending_opeid==1318900| ///sending_opeid==1320800| ///sending_opeid==1321400| ///sending_opeid==1321800| ///sending_opeid==1323100| ///sending_opeid==1323200| ///sending_opeid==1323300| ///sending_opeid==1323400| ///sending_opeid==1324000| ///sending_opeid==1326300| ///sending_opeid==1326400| ///sending_opeid==1465900| ///sending_opeid==1536100| ///sending_opeid==2050300| ///sending_opeid==2052000| ///sending_opeid==2052200| ///sending_opeid==2052300| ///sending_opeid==2052701| ///sending_opeid==2052702| ///sending_opeid==2052703| ///sending_opeid==2053000| ///sending_opeid==2053700| ///sending_opeid==2054300| ///sending_opeid==2054900| ///sending_opeid==2055000| ///sending_opeid==2055100| ///sending_opeid==2055200| ///sending_opeid==2055400| ///sending_opeid==2055500| ///sending_opeid==2056100| ///sending_opeid==2056400| ///sending_opeid==2056500| ///sending_opeid==2056501| ///sending_opeid==2056800| ///sending_opeid==2057400| ///sending_opeid==2058600| ///sending_opeid==2058900| ///sending_opeid==2059800| ///sending_opeid==2060300| ///sending_opeid==2060800| ///sending_opeid==2060900| ///sending_opeid==2061000| ///sending_opeid==2061600| ///sending_opeid==2061800| ///sending_opeid==2063000| ///sending_opeid==2063100| ///sending_opeid==2063101| ///sending_opeid==2063400| ///sending_opeid==2063500| ///sending_opeid==2063700| ///sending_opeid==2063800| ///sending_opeid==2064300| ///sending_opeid==2065100| ///sending_opeid==2065300| ///sending_opeid==2065500| ///sending_opeid==2065700| ///sending_opeid==2066100| ///sending_opeid==2066200| ///sending_opeid==2066900| ///sending_opeid==2067600| ///sending_opeid==2068000| ///sending_opeid==2068100| ///sending_opeid==2068200| ///sending_opeid==2068202| ///sending_opeid==2068204| ///sending_opeid==2068300| ///sending_opeid==2068700| ///sending_opeid==2069000| ///sending_opeid==2069300| ///sending_opeid==2069303| ///sending_opeid==2070100| ///sending_opeid==2070500| ///sending_opeid==2071200| ///sending_opeid==2073200| ///sending_opeid==2073300| ///sending_opeid==2073400| ///sending_opeid==2073500| ///sending_opeid==2073600| ///sending_opeid==2073700| ///sending_opeid==2073900| ///sending_opeid==2074000| ///sending_opeid==2074100| ///sending_opeid==2074600| ///sending_opeid==2074800| ///sending_opeid==2074900| ///sending_opeid==2075300| ///sending_opeid==2075400| ///sending_opeid==2075700| ///sending_opeid==2075800| ///sending_opeid==2077100| ///sending_opeid==2077400| ///sending_opeid==2077800| ///sending_opeid==2078000| ///sending_opeid==2078100| ///sending_opeid==2078800| ///sending_opeid==2078900| ///sending_opeid==2079400)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2079700| ///sending_opeid==2079701| ///sending_opeid==2081400| ///sending_opeid==2083600| ///sending_opeid==2083900| ///sending_opeid==2084800| ///sending_opeid==2086400| ///sending_opeid==2087000| ///sending_opeid==2087600| ///sending_opeid==2089600| ///sending_opeid==2089601| ///sending_opeid==2090200| ///sending_opeid==2090300| ///sending_opeid==2090400| ///sending_opeid==2090700| ///sending_opeid==2091200| ///sending_opeid==2091700| ///sending_opeid==2091701| ///sending_opeid==2092100| ///sending_opeid==2092300| ///sending_opeid==2092400| ///sending_opeid==2092500| ///sending_opeid==2092800| ///sending_opeid==2093600| ///sending_opeid==2096100| ///sending_opeid==2097000| ///sending_opeid==2097100| ///sending_opeid==2097300| ///sending_opeid==2097900| ///sending_opeid==2098300| ///sending_opeid==2098301| ///sending_opeid==2098400| ///sending_opeid==2098800| ///sending_opeid==2099200| ///sending_opeid==2099500| ///sending_opeid==2099700| ///sending_opeid==2100000| ///sending_opeid==2100200| ///sending_opeid==2100300| ///sending_opeid==2100400| ///sending_opeid==2100500| ///sending_opeid==2100502| ///sending_opeid==2100505| ///sending_opeid==2100600| ///sending_opeid==2100612| ///sending_opeid==2101000| ///sending_opeid==2101001| ///sending_opeid==2103500| ///sending_opeid==2103700| ///sending_opeid==2103900| ///sending_opeid==2104000| ///sending_opeid==2104300| ///sending_opeid==2104400| ///sending_opeid==2104401| ///sending_opeid==2104402| ///sending_opeid==2104403| ///sending_opeid==2104404| ///sending_opeid==2104900| ///sending_opeid==2105300| ///sending_opeid==2105900| ///sending_opeid==2106100| ///sending_opeid==2106400| ///sending_opeid==2106600| ///sending_opeid==2106700| ///sending_opeid==2106800| ///sending_opeid==2107300| ///sending_opeid==2107700| ///sending_opeid==2107800| ///sending_opeid==2108800| ///sending_opeid==2110200| ///sending_opeid==2110700| ///sending_opeid==2110701| ///sending_opeid==2110702| ///sending_opeid==2110800| ///sending_opeid==2110900| ///sending_opeid==2111100| ///sending_opeid==2111300| ///sending_opeid==2111600| ///sending_opeid==2112200| ///sending_opeid==2112300| ///sending_opeid==2112301| ///sending_opeid==2112700| ///sending_opeid==2113600| ///sending_opeid==2113800| ///sending_opeid==2114200| ///sending_opeid==2115100| ///sending_opeid==2115300| ///sending_opeid==2115400| ///sending_opeid==2116000| ///sending_opeid==2116300| ///sending_opeid==2116900| ///sending_opeid==2117100| ///sending_opeid==2117300| ///sending_opeid==2117400| ///sending_opeid==2117500| ///sending_opeid==2117800| ///sending_opeid==2118000| ///sending_opeid==2118702| ///sending_opeid==2118900| ///sending_opeid==2119100| ///sending_opeid==2119200| ///sending_opeid==2119300| ///sending_opeid==2119301| ///sending_opeid==2120600| ///sending_opeid==2120700| ///sending_opeid==2120800| ///sending_opeid==2121100| ///sending_opeid==2122000| ///sending_opeid==2123200| ///sending_opeid==2124400| ///sending_opeid==2124500| ///sending_opeid==2125000| ///sending_opeid==2125001| ///sending_opeid==2125200| ///sending_opeid==2125300| ///sending_opeid==2125500| ///sending_opeid==2125600| ///sending_opeid==2126300| ///sending_opeid==2126400| ///sending_opeid==2126500| ///sending_opeid==2127400| ///sending_opeid==2127900| ///sending_opeid==2128200| ///sending_opeid==2128300| ///sending_opeid==2128301| ///sending_opeid==2128302| ///sending_opeid==2128600| ///sending_opeid==2128700| ///sending_opeid==2129000| ///sending_opeid==2129003| ///sending_opeid==2131100| ///sending_opeid==2131600| ///sending_opeid==2132300| ///sending_opeid==2132800| ///sending_opeid==2134500| ///sending_opeid==2134800| ///sending_opeid==2135000| ///sending_opeid==2136600| ///sending_opeid==2136800| ///sending_opeid==2137000| ///sending_opeid==2137100| ///sending_opeid==2137200| ///sending_opeid==2138300| ///sending_opeid==2138500| ///sending_opeid==2139500| ///sending_opeid==2140000| ///sending_opeid==2140400| ///sending_opeid==2140700| ///sending_opeid==2140700| ///sending_opeid==2140800| ///sending_opeid==2141100| ///sending_opeid==2141500| ///sending_opeid==2142200| ///sending_opeid==2143000| ///sending_opeid==2143400| ///sending_opeid==2143500| ///sending_opeid==2143700| ///sending_opeid==2143900| ///sending_opeid==2144000| ///sending_opeid==2144600| ///sending_opeid==2144800| ///sending_opeid==2144900| ///sending_opeid==2145100| ///sending_opeid==2145800| ///sending_opeid==2146000| ///sending_opeid==2146400| ///sending_opeid==2146600| ///sending_opeid==2146800| ///sending_opeid==2147800| ///sending_opeid==2148200| ///sending_opeid==2148300| ///sending_opeid==2148600| ///sending_opeid==2148700| ///sending_opeid==2149900| ///sending_opeid==2149901| ///sending_opeid==2150600| ///sending_opeid==2151000| ///sending_opeid==2151100| ///sending_opeid==2151102| ///sending_opeid==2151500| ///sending_opeid==2151900| ///sending_opeid==2152000| ///sending_opeid==2152102| ///sending_opeid==2153100| ///sending_opeid==2153500| ///sending_opeid==2153600| ///sending_opeid==2154000| ///sending_opeid==2154400| ///sending_opeid==2154900| ///sending_opeid==2155307| ///sending_opeid==2156200| ///sending_opeid==2156300| ///sending_opeid==2156600| ///sending_opeid==2156700| ///sending_opeid==2157100| ///sending_opeid==2157900| ///sending_opeid==2158200| ///sending_opeid==2158300| ///sending_opeid==2158400| ///sending_opeid==2158500| ///sending_opeid==2158600| ///sending_opeid==2158800| ///sending_opeid==2159100| ///sending_opeid==2159600| ///sending_opeid==2159700| ///sending_opeid==2159701| ///sending_opeid==2159800| ///sending_opeid==2160100| ///sending_opeid==2160300| ///sending_opeid==2160900| ///sending_opeid==2160901| ///sending_opeid==2161000| ///sending_opeid==2161400| ///sending_opeid==2161800| ///sending_opeid==2163300| ///sending_opeid==2163400| ///sending_opeid==2163500| ///sending_opeid==2163600| ///sending_opeid==2163900| ///sending_opeid==2164200| ///sending_opeid==2164300| ///sending_opeid==2165100| ///sending_opeid==2165200| ///sending_opeid==2165900| ///sending_opeid==2166000| ///sending_opeid==2166100| ///sending_opeid==2166200| ///sending_opeid==2166400| ///sending_opeid==2166800| ///sending_opeid==2167600| ///sending_opeid==2167800| ///sending_opeid==2168100| ///sending_opeid==2168600| ///sending_opeid==2169100| ///sending_opeid==2169600| ///sending_opeid==2169900| ///sending_opeid==2170000| ///sending_opeid==2170200| ///sending_opeid==2170300| ///sending_opeid==2170600| ///sending_opeid==2170700| ///sending_opeid==2171500| ///sending_opeid==2171900| ///sending_opeid==2172700| ///sending_opeid==2172800| ///sending_opeid==2173200| ///sending_opeid==2173211| ///sending_opeid==2173300| ///sending_opeid==2173900)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2174400| ///sending_opeid==2174401| ///sending_opeid==2174800| ///sending_opeid==2175800| ///sending_opeid==2176000| ///sending_opeid==2176100| ///sending_opeid==2177500| ///sending_opeid==2177900| ///sending_opeid==2178200| ///sending_opeid==2178500| ///sending_opeid==2178700| ///sending_opeid==2178900| ///sending_opeid==2179600| ///sending_opeid==2179900| ///sending_opeid==2179937| ///sending_opeid==2179938| ///sending_opeid==2179941| ///sending_opeid==2179947| ///sending_opeid==2179948| ///sending_opeid==2180000| ///sending_opeid==2180100| ///sending_opeid==2180200| ///sending_opeid==2180600| ///sending_opeid==2181300| ///sending_opeid==2181600| ///sending_opeid==2182100| ///sending_opeid==2182200| ///sending_opeid==2182900| ///sending_opeid==2183000| ///sending_opeid==2183001| ///sending_opeid==2183600| ///sending_opeid==2183601| ///sending_opeid==2184200| ///sending_opeid==2184400| ///sending_opeid==2184900| ///sending_opeid==2185400| ///sending_opeid==2185800| ///sending_opeid==2186400| ///sending_opeid==2186700| ///sending_opeid==2186703| ///sending_opeid==2186705| ///sending_opeid==2186707| ///sending_opeid==2186708| ///sending_opeid==2186709| ///sending_opeid==2187300| ///sending_opeid==2187900| ///sending_opeid==2188000| ///sending_opeid==2188100| ///sending_opeid==2188200| ///sending_opeid==2188300| ///sending_opeid==2188400| ///sending_opeid==2188600| ///sending_opeid==2188900| ///sending_opeid==2189000| ///sending_opeid==2189100| ///sending_opeid==2189101| ///sending_opeid==2189103| ///sending_opeid==2189300| ///sending_opeid==2190400| ///sending_opeid==2190700| ///sending_opeid==2190702| ///sending_opeid==2191600| ///sending_opeid==2191801| ///sending_opeid==2192100| ///sending_opeid==2192200| ///sending_opeid==2192300| ///sending_opeid==2192400| ///sending_opeid==2192800| ///sending_opeid==2193300| ///sending_opeid==2193700| ///sending_opeid==2195400| ///sending_opeid==2195500| ///sending_opeid==2195800| ///sending_opeid==2195900| ///sending_opeid==2196300| ///sending_opeid==2196400| ///sending_opeid==2197300| ///sending_opeid==2197500| ///sending_opeid==2197600| ///sending_opeid==2197900| ///sending_opeid==2198900| ///sending_opeid==2199300| ///sending_opeid==2199700| ///sending_opeid==2199900| ///sending_opeid==2200100| ///sending_opeid==2200800| ///sending_opeid==2201800| ///sending_opeid==2201900| ///sending_opeid==2202200| ///sending_opeid==2202300| ///sending_opeid==2202400| ///sending_opeid==2202500| ///sending_opeid==2202501| ///sending_opeid==2202600| ///sending_opeid==2202700| ///sending_opeid==2202800| ///sending_opeid==2203300| ///sending_opeid==2203301| ///sending_opeid==2203400| ///sending_opeid==2203900| ///sending_opeid==2204200| ///sending_opeid==2204900| ///sending_opeid==2205000| ///sending_opeid==2205200| ///sending_opeid==2205300| ///sending_opeid==2205700| ///sending_opeid==2206000| ///sending_opeid==2206200| ///sending_opeid==2206300| ///sending_opeid==2207000| ///sending_opeid==2208600| ///sending_opeid==2209200| ///sending_opeid==2210400| ///sending_opeid==2210700| ///sending_opeid==2210800| ///sending_opeid==2211000| ///sending_opeid==2211600| ///sending_opeid==2211900| ///sending_opeid==2211901| ///sending_opeid==2211902| ///sending_opeid==2212700| ///sending_opeid==2213000| ///sending_opeid==2213400| ///sending_opeid==2214100| ///sending_opeid==2214500| ///sending_opeid==2214800| ///sending_opeid==2215100| ///sending_opeid==2215400| ///sending_opeid==2215900| ///sending_opeid==2217100| ///sending_opeid==2217200| ///sending_opeid==2217800| ///sending_opeid==2218000| ///sending_opeid==2218200| ///sending_opeid==2218300| ///sending_opeid==2218700| ///sending_opeid==2218800| ///sending_opeid==2218800| ///sending_opeid==2218802| ///sending_opeid==2219500| ///sending_opeid==2219600| ///sending_opeid==2220000| ///sending_opeid==2220200| ///sending_opeid==2220400| ///sending_opeid==2220500| ///sending_opeid==2220800| ///sending_opeid==2220900| ///sending_opeid==2221300| ///sending_opeid==2222000| ///sending_opeid==2222700| ///sending_opeid==2222900| ///sending_opeid==2223100| ///sending_opeid==2223300| ///sending_opeid==2223700| ///sending_opeid==2223900| ///sending_opeid==2224600| ///sending_opeid==2226000| ///sending_opeid==2227800| ///sending_opeid==2227900| ///sending_opeid==2228100| ///sending_opeid==2228300| ///sending_opeid==2228500| ///sending_opeid==2230500| ///sending_opeid==2230600| ///sending_opeid==2230900| ///sending_opeid==2231100| ///sending_opeid==2231600| ///sending_opeid==2231900| ///sending_opeid==2231901| ///sending_opeid==2231902| ///sending_opeid==2232500| ///sending_opeid==2234000| ///sending_opeid==2234200| ///sending_opeid==2234300| ///sending_opeid==2234500| ///sending_opeid==2234600| ///sending_opeid==2234900| ///sending_opeid==2235700| ///sending_opeid==2235900| ///sending_opeid==2236400| ///sending_opeid==2236500| ///sending_opeid==2236800| ///sending_opeid==2236801| ///sending_opeid==2237200| ///sending_opeid==2237500| ///sending_opeid==2237800| ///sending_opeid==2237900| ///sending_opeid==2238100| ///sending_opeid==2238500| ///sending_opeid==2238700| ///sending_opeid==2239100| ///sending_opeid==2239101| ///sending_opeid==2239200| ///sending_opeid==2239800| ///sending_opeid==2241600| ///sending_opeid==2241700| ///sending_opeid==2241800| ///sending_opeid==2241900| ///sending_opeid==2241904| ///sending_opeid==2241907| ///sending_opeid==2241908| ///sending_opeid==2241909| ///sending_opeid==2242400| ///sending_opeid==2242500| ///sending_opeid==2242700| ///sending_opeid==2242900| ///sending_opeid==2244300| ///sending_opeid==2244305| ///sending_opeid==2244900| ///sending_opeid==2245200| ///sending_opeid==2245300| ///sending_opeid==2245400| ///sending_opeid==2245500| ///sending_opeid==2245502| ///sending_opeid==2245504| ///sending_opeid==2245505| ///sending_opeid==2245600| ///sending_opeid==2246300| ///sending_opeid==2247000| ///sending_opeid==2247200| ///sending_opeid==2248200| ///sending_opeid==2248600| ///sending_opeid==2249900| ///sending_opeid==2250600| ///sending_opeid==2250900| ///sending_opeid==2251200| ///sending_opeid==2251500| ///sending_opeid==2251502| ///sending_opeid==2251504| ///sending_opeid==2251600| ///sending_opeid==2251700| ///sending_opeid==2253000| ///sending_opeid==2253700| ///sending_opeid==2253900| ///sending_opeid==2254000| ///sending_opeid==2254001| ///sending_opeid==2254800| ///sending_opeid==2255000| ///sending_opeid==2255200| ///sending_opeid==2255400| ///sending_opeid==2256200| ///sending_opeid==2256201| ///sending_opeid==2256700| ///sending_opeid==2257400| ///sending_opeid==2257700| ///sending_opeid==2257900| ///sending_opeid==2258400| ///sending_opeid==2258600| ///sending_opeid==2259400| ///sending_opeid==2260200)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2260400| ///sending_opeid==2260500| ///sending_opeid==2260600| ///sending_opeid==2260800| ///sending_opeid==2261200| ///sending_opeid==2261300| ///sending_opeid==2261301| ///sending_opeid==2261302| ///sending_opeid==2261303| ///sending_opeid==2261400| ///sending_opeid==2262100| ///sending_opeid==2262400| ///sending_opeid==2262500| ///sending_opeid==2262501| ///sending_opeid==2263100| ///sending_opeid==2263105| ///sending_opeid==2263400| ///sending_opeid==2263600| ///sending_opeid==2263700| ///sending_opeid==2265100| ///sending_opeid==2265200| ///sending_opeid==2265500| ///sending_opeid==2265600| ///sending_opeid==2265900| ///sending_opeid==2266200| ///sending_opeid==2266400| ///sending_opeid==2267100| ///sending_opeid==2267500| ///sending_opeid==2267600| ///sending_opeid==2269300| ///sending_opeid==2269400| ///sending_opeid==2269500| ///sending_opeid==2269600| ///sending_opeid==2269700| ///sending_opeid==2269900| ///sending_opeid==2270100| ///sending_opeid==2270400| ///sending_opeid==2270500| ///sending_opeid==2270600| ///sending_opeid==2270800| ///sending_opeid==2271300| ///sending_opeid==2272400| ///sending_opeid==2272700| ///sending_opeid==2272900| ///sending_opeid==2273400| ///sending_opeid==2274100| ///sending_opeid==2274300| ///sending_opeid==2275000| ///sending_opeid==2275100| ///sending_opeid==2275300| ///sending_opeid==2275500| ///sending_opeid==2275800| ///sending_opeid==2275801| ///sending_opeid==2275900| ///sending_opeid==2276000| ///sending_opeid==2276400| ///sending_opeid==2276401| ///sending_opeid==2276403| ///sending_opeid==2276600| ///sending_opeid==2276800| ///sending_opeid==2276900| ///sending_opeid==2277300| ///sending_opeid==2277400| ///sending_opeid==2277500| ///sending_opeid==2278100| ///sending_opeid==2278700| ///sending_opeid==2278800| ///sending_opeid==2279200| ///sending_opeid==2279600| ///sending_opeid==2279800| ///sending_opeid==2280500| ///sending_opeid==2280900| ///sending_opeid==2282100| ///sending_opeid==2282300| ///sending_opeid==2282500| ///sending_opeid==2283800| ///sending_opeid==2283804| ///sending_opeid==2284200| ///sending_opeid==2284300| ///sending_opeid==2284500| ///sending_opeid==2285000| ///sending_opeid==2285100| ///sending_opeid==2285500| ///sending_opeid==2285700| ///sending_opeid==2285900| ///sending_opeid==2285901| ///sending_opeid==2286100| ///sending_opeid==2286300| ///sending_opeid==2286600| ///sending_opeid==2287100| ///sending_opeid==2287400| ///sending_opeid==2287800| ///sending_opeid==2287801| ///sending_opeid==2287900| ///sending_opeid==2287903| ///sending_opeid==2288400| ///sending_opeid==2288900| ///sending_opeid==2289000| ///sending_opeid==2289200| ///sending_opeid==2289500| ///sending_opeid==2289600| ///sending_opeid==2289700| ///sending_opeid==2289800| ///sending_opeid==2290400| ///sending_opeid==2291200| ///sending_opeid==2291300| ///sending_opeid==2291700| ///sending_opeid==2292400| ///sending_opeid==2292700| ///sending_opeid==2293200| ///sending_opeid==2293201| ///sending_opeid==2293600| ///sending_opeid==2293900| ///sending_opeid==2294000| ///sending_opeid==2294800| ///sending_opeid==2294900| ///sending_opeid==2295000| ///sending_opeid==2295500| ///sending_opeid==2295700| ///sending_opeid==2296000| ///sending_opeid==2296100| ///sending_opeid==2297000| ///sending_opeid==2297100| ///sending_opeid==2297500| ///sending_opeid==2297700| ///sending_opeid==2297701| ///sending_opeid==2297702| ///sending_opeid==2297705| ///sending_opeid==2297800| ///sending_opeid==2298000| ///sending_opeid==2298200| ///sending_opeid==2298500| ///sending_opeid==2299300| ///sending_opeid==2300000| ///sending_opeid==2300100| ///sending_opeid==2300101| ///sending_opeid==2300200| ///sending_opeid==2300900| ///sending_opeid==2301100| ///sending_opeid==2301300| ///sending_opeid==2301400| ///sending_opeid==2301900| ///sending_opeid==2302700| ///sending_opeid==2302800| ///sending_opeid==2303500| ///sending_opeid==2303800| ///sending_opeid==2304000| ///sending_opeid==2304300| ///sending_opeid==2304400| ///sending_opeid==2304500| ///sending_opeid==2304700| ///sending_opeid==2304800| ///sending_opeid==2305300| ///sending_opeid==2305700| ///sending_opeid==2305800| ///sending_opeid==2306200| ///sending_opeid==2306300| ///sending_opeid==2306302| ///sending_opeid==2306500| ///sending_opeid==2306700| ///sending_opeid==2306800| ///sending_opeid==2306801| ///sending_opeid==2306804| ///sending_opeid==2306805| ///sending_opeid==2306806| ///sending_opeid==2306900| ///sending_opeid==2307400| ///sending_opeid==2308900| ///sending_opeid==2309100| ///sending_opeid==2309500| ///sending_opeid==2310300| ///sending_opeid==2310800| ///sending_opeid==2311000| ///sending_opeid==2311000| ///sending_opeid==2311100| ///sending_opeid==2311200| ///sending_opeid==2312000| ///sending_opeid==2312200| ///sending_opeid==2312300| ///sending_opeid==2312400| ///sending_opeid==2313000| ///sending_opeid==2313900| ///sending_opeid==2314000| ///sending_opeid==2314100| ///sending_opeid==2314200| ///sending_opeid==2314800| ///sending_opeid==2315400| ///sending_opeid==2315500| ///sending_opeid==2315500| ///sending_opeid==2316200| ///sending_opeid==2316600| ///sending_opeid==2316601| ///sending_opeid==2316603| ///sending_opeid==2317200| ///sending_opeid==2317300| ///sending_opeid==2317800| ///sending_opeid==2318200| ///sending_opeid==2318600| ///sending_opeid==2319200| ///sending_opeid==2319800| ///sending_opeid==2319801| ///sending_opeid==2320100| ///sending_opeid==2320200| ///sending_opeid==2320800| ///sending_opeid==2320900| ///sending_opeid==2321200| ///sending_opeid==2321300| ///sending_opeid==2321400| ///sending_opeid==2323000| ///sending_opeid==2323100| ///sending_opeid==2323300| ///sending_opeid==2323700| ///sending_opeid==2323800| ///sending_opeid==2324400| ///sending_opeid==2324500| ///sending_opeid==2325100| ///sending_opeid==2325600| ///sending_opeid==2325700| ///sending_opeid==2325800| ///sending_opeid==2326000| ///sending_opeid==2326200| ///sending_opeid==2326300| ///sending_opeid==2326500| ///sending_opeid==2326800| ///sending_opeid==2326900| ///sending_opeid==2327800| ///sending_opeid==2328500| ///sending_opeid==2328900| ///sending_opeid==2329900| ///sending_opeid==2330100| ///sending_opeid==2330300| ///sending_opeid==2330500| ///sending_opeid==2330600| ///sending_opeid==2330800| ///sending_opeid==2330900| ///sending_opeid==2331000| ///sending_opeid==2331200| ///sending_opeid==2331300| ///sending_opeid==2331400| ///sending_opeid==2332200| ///sending_opeid==2332300| ///sending_opeid==2332800| ///sending_opeid==2332804| ///sending_opeid==2332809| ///sending_opeid==2332814| ///sending_opeid==2332820| ///sending_opeid==2332823| ///sending_opeid==2332824)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2332829| ///sending_opeid==2332838| ///sending_opeid==2332839| ///sending_opeid==2333000| ///sending_opeid==2333200| ///sending_opeid==2334300| ///sending_opeid==2334400| ///sending_opeid==2334401| ///sending_opeid==2334402| ///sending_opeid==2334403| ///sending_opeid==2335500| ///sending_opeid==2335701| ///sending_opeid==2335702| ///sending_opeid==2335900| ///sending_opeid==2336300| ///sending_opeid==2336700| ///sending_opeid==2337000| ///sending_opeid==2337200| ///sending_opeid==2337203| ///sending_opeid==2337400| ///sending_opeid==2337700| ///sending_opeid==2337800| ///sending_opeid==2337900| ///sending_opeid==2338000| ///sending_opeid==2338200| ///sending_opeid==2338400| ///sending_opeid==2338500| ///sending_opeid==2338600| ///sending_opeid==2338700| ///sending_opeid==2339400| ///sending_opeid==2339600| ///sending_opeid==2339700| ///sending_opeid==2339800| ///sending_opeid==2340000| ///sending_opeid==2340500| ///sending_opeid==2340600| ///sending_opeid==2340700| ///sending_opeid==2340800| ///sending_opeid==2341000| ///sending_opeid==2341100| ///sending_opeid==2341103| ///sending_opeid==2341104| ///sending_opeid==2341300| ///sending_opeid==2341700| ///sending_opeid==2342400| ///sending_opeid==2342401| ///sending_opeid==2342700| ///sending_opeid==2343000| ///sending_opeid==2343400| ///sending_opeid==2343600| ///sending_opeid==2343800| ///sending_opeid==2344100| ///sending_opeid==2344300| ///sending_opeid==2345100| ///sending_opeid==2345600| ///sending_opeid==2345800| ///sending_opeid==2346200| ///sending_opeid==2346500| ///sending_opeid==2347100| ///sending_opeid==2347600| ///sending_opeid==2348200| ///sending_opeid==2348500| ///sending_opeid==2349200| ///sending_opeid==2349400| ///sending_opeid==2349500| ///sending_opeid==2349700| ///sending_opeid==2349900| ///sending_opeid==2350100| ///sending_opeid==2350200| ///sending_opeid==2350600| ///sending_opeid==2351300| ///sending_opeid==2351500| ///sending_opeid==2351500| ///sending_opeid==2351700| ///sending_opeid==2351900| ///sending_opeid==2351901| ///sending_opeid==2352200| ///sending_opeid==2352500| ///sending_opeid==2352800| ///sending_opeid==2353100| ///sending_opeid==2354200| ///sending_opeid==2356600| ///sending_opeid==2357600| ///sending_opeid==2357700| ///sending_opeid==2358000| ///sending_opeid==2358200| ///sending_opeid==2358500| ///sending_opeid==2358600| ///sending_opeid==2359200| ///sending_opeid==2359300| ///sending_opeid==2360800| ///sending_opeid==2360802| ///sending_opeid==2361200| ///sending_opeid==2361300| ///sending_opeid==2361400| ///sending_opeid==2361500| ///sending_opeid==2361600| ///sending_opeid==2362000| ///sending_opeid==2362002| ///sending_opeid==2362100| ///sending_opeid==2362300| ///sending_opeid==2362800| ///sending_opeid==2363500| ///sending_opeid==2363800| ///sending_opeid==2453500| ///sending_opeid==2454400| ///sending_opeid==2460000| ///sending_opeid==2482100| ///sending_opeid==2482400| ///sending_opeid==2482700| ///sending_opeid==2490200| ///sending_opeid==2490500| ///sending_opeid==2490800| ///sending_opeid==2491000| ///sending_opeid==2491100| ///sending_opeid==2491400| ///sending_opeid==2491500| ///sending_opeid==2491700| ///sending_opeid==2492500| ///sending_opeid==2492600| ///sending_opeid==2493400| ///sending_opeid==2494300| ///sending_opeid==2494700| ///sending_opeid==2494800| ///sending_opeid==2495000| ///sending_opeid==2495100| ///sending_opeid==2495500| ///sending_opeid==2495800| ///sending_opeid==2496900| ///sending_opeid==2497300| ///sending_opeid==2497305| ///sending_opeid==2497309| ///sending_opeid==2497500| ///sending_opeid==2497800| ///sending_opeid==2498000| ///sending_opeid==2498200| ///sending_opeid==2498300| ///sending_opeid==2499000| ///sending_opeid==2500000| ///sending_opeid==2501500| ///sending_opeid==2502100| ///sending_opeid==2502400| ///sending_opeid==2502400| ///sending_opeid==2503400| ///sending_opeid==2503900| ///sending_opeid==2504200| ///sending_opeid==2504500| ///sending_opeid==2504600| ///sending_opeid==2504900| ///sending_opeid==2505400| ///sending_opeid==2505400| ///sending_opeid==2505800| ///sending_opeid==2505900| ///sending_opeid==2506000| ///sending_opeid==2506200| ///sending_opeid==2506800| ///sending_opeid==2508300| ///sending_opeid==2508303| ///sending_opeid==2508600| ///sending_opeid==2508900| ///sending_opeid==2510300| ///sending_opeid==2510600| ///sending_opeid==2511000| ///sending_opeid==2511500| ///sending_opeid==2511700| ///sending_opeid==2512400| ///sending_opeid==2512600| ///sending_opeid==2513200| ///sending_opeid==2513500| ///sending_opeid==2514100| ///sending_opeid==2515400| ///sending_opeid==2516200| ///sending_opeid==2517100| ///sending_opeid==2517500| ///sending_opeid==2518300| ///sending_opeid==2518400| ///sending_opeid==2518500| ///sending_opeid==2518900| ///sending_opeid==2519300| ///sending_opeid==2519800| ///sending_opeid==2520000| ///sending_opeid==2520200| ///sending_opeid==2520300| ///sending_opeid==2520400| ///sending_opeid==2520800| ///sending_opeid==2521200| ///sending_opeid==2521500| ///sending_opeid==2521800| ///sending_opeid==2522700| ///sending_opeid==2522800| ///sending_opeid==2523100| ///sending_opeid==2523700| ///sending_opeid==2523900| ///sending_opeid==2524000| ///sending_opeid==2524200| ///sending_opeid==2524500| ///sending_opeid==2525600| ///sending_opeid==2525800| ///sending_opeid==2525900| ///sending_opeid==2526100| ///sending_opeid==2527500| ///sending_opeid==2527600| ///sending_opeid==2528200| ///sending_opeid==2528300| ///sending_opeid==2529500| ///sending_opeid==2529800| ///sending_opeid==2530400| ///sending_opeid==2530600| ///sending_opeid==2530704| ///sending_opeid==2531200| ///sending_opeid==2531800| ///sending_opeid==2531801| ///sending_opeid==2531802| ///sending_opeid==2531804| ///sending_opeid==2532200| ///sending_opeid==2532600| ///sending_opeid==2532900| ///sending_opeid==2533200| ///sending_opeid==2533600| ///sending_opeid==2534000| ///sending_opeid==2534800| ///sending_opeid==2534900| ///sending_opeid==2535400| ///sending_opeid==2535500| ///sending_opeid==2535600| ///sending_opeid==2536400| ///sending_opeid==2536600| ///sending_opeid==2536700| ///sending_opeid==2537200| ///sending_opeid==2538100| ///sending_opeid==2538300| ///sending_opeid==2538500| ///sending_opeid==2538501| ///sending_opeid==2538502| ///sending_opeid==2538800| ///sending_opeid==2538900| ///sending_opeid==2538901| ///sending_opeid==2538902| ///sending_opeid==2539100| ///sending_opeid==2539500| ///sending_opeid==2539800| ///sending_opeid==2539900| ///sending_opeid==2540000| ///sending_opeid==2540800| ///sending_opeid==2541000| ///sending_opeid==2541200| ///sending_opeid==2541400| ///sending_opeid==2541900| ///sending_opeid==2542000)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2542300| ///sending_opeid==2543400| ///sending_opeid==2543600| ///sending_opeid==2543800| ///sending_opeid==2544300| ///sending_opeid==2544301| ///sending_opeid==2544302| ///sending_opeid==2544303| ///sending_opeid==2545000| ///sending_opeid==2545200| ///sending_opeid==2545400| ///sending_opeid==2545800| ///sending_opeid==2545900| ///sending_opeid==2546000| ///sending_opeid==2546200| ///sending_opeid==2546300| ///sending_opeid==2546400| ///sending_opeid==2547600| ///sending_opeid==2548500| ///sending_opeid==2548800| ///sending_opeid==2549000| ///sending_opeid==2549400| ///sending_opeid==2549700| ///sending_opeid==2550000| ///sending_opeid==2550600| ///sending_opeid==2550800| ///sending_opeid==2551100| ///sending_opeid==2551200| ///sending_opeid==2552300| ///sending_opeid==2552400| ///sending_opeid==2553000| ///sending_opeid==2553100| ///sending_opeid==2553500| ///sending_opeid==2553600| ///sending_opeid==2553700| ///sending_opeid==2554200| ///sending_opeid==2554300| ///sending_opeid==2554500| ///sending_opeid==2554600| ///sending_opeid==2554800| ///sending_opeid==2555301| ///sending_opeid==2555400| ///sending_opeid==2556100| ///sending_opeid==2556101| ///sending_opeid==2556500| ///sending_opeid==2556600| ///sending_opeid==2556700| ///sending_opeid==2556800| ///sending_opeid==2557400| ///sending_opeid==2557700| ///sending_opeid==2557800| ///sending_opeid==2558700| ///sending_opeid==2558900| ///sending_opeid==2559000| ///sending_opeid==2559300| ///sending_opeid==2559400| ///sending_opeid==2559500| ///sending_opeid==2560000| ///sending_opeid==2560200| ///sending_opeid==2560600| ///sending_opeid==2560700| ///sending_opeid==2560800| ///sending_opeid==2561900| ///sending_opeid==2562300| ///sending_opeid==2562400| ///sending_opeid==2562500| ///sending_opeid==2563000| ///sending_opeid==2563300| ///sending_opeid==2563500| ///sending_opeid==2563501| ///sending_opeid==2564700| ///sending_opeid==2565000| ///sending_opeid==2565400| ///sending_opeid==2566800| ///sending_opeid==2567300| ///sending_opeid==2567600| ///sending_opeid==2568100| ///sending_opeid==2568500| ///sending_opeid==2568600| ///sending_opeid==2568800| ///sending_opeid==2569300| ///sending_opeid==2569305| ///sending_opeid==2569400| ///sending_opeid==2569600| ///sending_opeid==2570300| ///sending_opeid==2570400| ///sending_opeid==2570402| ///sending_opeid==2570403| ///sending_opeid==2571500| ///sending_opeid==2572000| ///sending_opeid==2572100| ///sending_opeid==2572200| ///sending_opeid==2572500| ///sending_opeid==2572700| ///sending_opeid==2572800| ///sending_opeid==2572802| ///sending_opeid==2572900| ///sending_opeid==2573100| ///sending_opeid==2573200| ///sending_opeid==2573700| ///sending_opeid==2573800| ///sending_opeid==2574800| ///sending_opeid==2575400| ///sending_opeid==2576100| ///sending_opeid==2576200| ///sending_opeid==2576900| ///sending_opeid==2577000| ///sending_opeid==2577700| ///sending_opeid==2577900| ///sending_opeid==2578000| ///sending_opeid==2578200| ///sending_opeid==2578300| ///sending_opeid==2578400| ///sending_opeid==2578800| ///sending_opeid==2579200| ///sending_opeid==2579800| ///sending_opeid==2579900| ///sending_opeid==2580101| ///sending_opeid==2580200| ///sending_opeid==2581100| ///sending_opeid==2581200| ///sending_opeid==2582200| ///sending_opeid==2582700| ///sending_opeid==2582900| ///sending_opeid==2583000| ///sending_opeid==2584200| ///sending_opeid==2584400| ///sending_opeid==2584900| ///sending_opeid==2586000| ///sending_opeid==2586400| ///sending_opeid==2586800| ///sending_opeid==2586801| ///sending_opeid==2586802| ///sending_opeid==2586900| ///sending_opeid==2586902| ///sending_opeid==2587500| ///sending_opeid==2587600| ///sending_opeid==2587700| ///sending_opeid==2587800| ///sending_opeid==2588200| ///sending_opeid==2588500| ///sending_opeid==2588600| ///sending_opeid==2588900| ///sending_opeid==2590900| ///sending_opeid==2591100| ///sending_opeid==2591101| ///sending_opeid==2591600| ///sending_opeid==2591900| ///sending_opeid==2591900| ///sending_opeid==2591905| ///sending_opeid==2593700| ///sending_opeid==2594300| ///sending_opeid==2594301| ///sending_opeid==2594302| ///sending_opeid==2594303| ///sending_opeid==2594600| ///sending_opeid==2595000| ///sending_opeid==2595600| ///sending_opeid==2595700| ///sending_opeid==2596400| ///sending_opeid==2596500| ///sending_opeid==2596503| ///sending_opeid==2596600| ///sending_opeid==2596601| ///sending_opeid==2596602| ///sending_opeid==2597100| ///sending_opeid==2597300| ///sending_opeid==2597400| ///sending_opeid==2597600| ///sending_opeid==2598200| ///sending_opeid==2599400| ///sending_opeid==2599700| ///sending_opeid==2599701| ///sending_opeid==2599702| ///sending_opeid==2599703| ///sending_opeid==2599705| ///sending_opeid==2599706| ///sending_opeid==2599709| ///sending_opeid==2599710| ///sending_opeid==2599711| ///sending_opeid==2599712| ///sending_opeid==2599800| ///sending_opeid==2600000| ///sending_opeid==2600001| ///sending_opeid==2600100| ///sending_opeid==2600200| ///sending_opeid==2600500| ///sending_opeid==2600900| ///sending_opeid==2601000| ///sending_opeid==2601100| ///sending_opeid==2601600| ///sending_opeid==2601700| ///sending_opeid==2602100| ///sending_opeid==2602300| ///sending_opeid==2603100| ///sending_opeid==2603700| ///sending_opeid==2603800| ///sending_opeid==2604700| ///sending_opeid==2605900| ///sending_opeid==2606200| ///sending_opeid==2606201| ///sending_opeid==2606202| ///sending_opeid==2606300| ///sending_opeid==2607000| ///sending_opeid==2607100| ///sending_opeid==2608000| ///sending_opeid==2608001| ///sending_opeid==2608300| ///sending_opeid==2608900| ///sending_opeid==2609000| ///sending_opeid==2609200| ///sending_opeid==2609202| ///sending_opeid==2609203| ///sending_opeid==2609204| ///sending_opeid==2609205| ///sending_opeid==2609400| ///sending_opeid==2609500| ///sending_opeid==2609501| ///sending_opeid==2609502| ///sending_opeid==2610100| ///sending_opeid==2610500| ///sending_opeid==2610900| ///sending_opeid==2611000| ///sending_opeid==2611100| ///sending_opeid==2612200| ///sending_opeid==2612700| ///sending_opeid==2612800| ///sending_opeid==2613000| ///sending_opeid==2614200| ///sending_opeid==2614700| ///sending_opeid==2614900| ///sending_opeid==2614901| ///sending_opeid==2615000| ///sending_opeid==2615800| ///sending_opeid==2616100| ///sending_opeid==2616400| ///sending_opeid==2616600| ///sending_opeid==2616700| ///sending_opeid==2617001| ///sending_opeid==2617100| ///sending_opeid==2617500| ///sending_opeid==2618400| ///sending_opeid==2619200| ///sending_opeid==2619300| ///sending_opeid==2620000| ///sending_opeid==2620300| ///sending_opeid==2621300| ///sending_opeid==2621500| ///sending_opeid==2622000)replace vsending_opeid=1 if firstime==5 & (sending_opeid==2622001| ///sending_opeid==2622002| ///sending_opeid==2622700| ///sending_opeid==2622900| ///sending_opeid==2623600| ///sending_opeid==2623800| ///sending_opeid==2623800| ///sending_opeid==2903100| ///sending_opeid==2926100| ///sending_opeid==3000100| ///sending_opeid==3001200| ///sending_opeid==3001500| ///sending_opeid==3001800| ///sending_opeid==3002000| ///sending_opeid==3002100| ///sending_opeid==3002200| ///sending_opeid==3002400| ///sending_opeid==3002500| ///sending_opeid==3003600| ///sending_opeid==3004000| ///sending_opeid==3004700| ///sending_opeid==3005000| ///sending_opeid==3005100| ///sending_opeid==3005400| ///sending_opeid==3005700| ///sending_opeid==3006300| ///sending_opeid==3006800| ///sending_opeid==3007000| ///sending_opeid==3007100| ///sending_opeid==3007200| ///sending_opeid==3007300| ///sending_opeid==3007400| ///sending_opeid==3007600| ///sending_opeid==3007900| ///sending_opeid==3008600| ///sending_opeid==3008601| ///sending_opeid==3008602| ///sending_opeid==3008603| ///sending_opeid==3008700| ///sending_opeid==3008800| ///sending_opeid==3009400| ///sending_opeid==3009500| ///sending_opeid==3009700| ///sending_opeid==3010000| ///sending_opeid==3010300| ///sending_opeid==3010600| ///sending_opeid==3010611| ///sending_opeid==3010700| ///sending_opeid==3010800| ///sending_opeid==3011300| ///sending_opeid==3011500| ///sending_opeid==3011600| ///sending_opeid==3011800| ///sending_opeid==3012100| ///sending_opeid==3012100| ///sending_opeid==3012106| ///sending_opeid==3012300| ///sending_opeid==3012500| ///sending_opeid==3013100| ///sending_opeid==3014700| ///sending_opeid==3014900| ///sending_opeid==3015100| ///sending_opeid==3015300| ///sending_opeid==3016000| ///sending_opeid==3017800| ///sending_opeid==3018500| ///sending_opeid==3018900| ///sending_opeid==3019201| ///sending_opeid==3019800| ///sending_opeid==3019900| ///sending_opeid==3020800| ///sending_opeid==3021000| ///sending_opeid==3021001| ///sending_opeid==3021002| ///sending_opeid==3021500| ///sending_opeid==3021900| ///sending_opeid==3022400| ///sending_opeid==3022600| ///sending_opeid==3023300| ///sending_opeid==3023400| ///sending_opeid==3023500| ///sending_opeid==3023700| ///sending_opeid==3023800| ///sending_opeid==3024300| ///sending_opeid==3024301| ///sending_opeid==3024700| ///sending_opeid==3024700| ///sending_opeid==3024900| ///sending_opeid==3025000| ///sending_opeid==3025001| ///sending_opeid==3025100| ///sending_opeid==3025500| ///sending_opeid==3025600| ///sending_opeid==3025800| ///sending_opeid==3025900| ///sending_opeid==3026100| ///sending_opeid==3026200| ///sending_opeid==3026500| ///sending_opeid==3026501| ///sending_opeid==3026504| ///sending_opeid==3026506| ///sending_opeid==3026507| ///sending_opeid==3026508| ///sending_opeid==3026509| ///sending_opeid==3026511| ///sending_opeid==3026511| ///sending_opeid==3026513| ///sending_opeid==3026514| ///sending_opeid==3026515| ///sending_opeid==3026516| ///sending_opeid==3026517| ///sending_opeid==3026518| ///sending_opeid==3026519| ///sending_opeid==3026520| ///sending_opeid==3026521| ///sending_opeid==3027100| ///sending_opeid==3027200| ///sending_opeid==3027400| ///sending_opeid==3027700| ///sending_opeid==3027701| ///sending_opeid==3027702| ///sending_opeid==3028200| ///sending_opeid==3028500| ///sending_opeid==3028501| ///sending_opeid==3028800| ///sending_opeid==3029200| ///sending_opeid==3029600| ///sending_opeid==3029700| ///sending_opeid==3029900| ///sending_opeid==3030000| ///sending_opeid==3030600| ///sending_opeid==3030601| ///sending_opeid==3030700| ///sending_opeid==3030800| ///sending_opeid==3030900| ///sending_opeid==3031300| ///sending_opeid==3031400| ///sending_opeid==3031600| ///sending_opeid==3032100| ///sending_opeid==3032300| ///sending_opeid==3032400| ///sending_opeid==3032500| ///sending_opeid==3033000| ///sending_opeid==3034200| ///sending_opeid==3034400| ///sending_opeid==3034500| ///sending_opeid==3035200| ///sending_opeid==3035300| ///sending_opeid==3035700| ///sending_opeid==3035800| ///sending_opeid==3035900| ///sending_opeid==3037500| ///sending_opeid==3039900| ///sending_opeid==3042400| ///sending_opeid==3042500| ///sending_opeid==3042700| ///sending_opeid==3042800| ///sending_opeid==3043100| ///sending_opeid==3043200| ///sending_opeid==3043900| ///sending_opeid==3044500| ///sending_opeid==3044500| ///sending_opeid==3050900| ///sending_opeid==3051100| ///sending_opeid==3051400| ///sending_opeid==3051500| ///sending_opeid==3051900| ///sending_opeid==3052000| ///sending_opeid==3052200| ///sending_opeid==3052201| ///sending_opeid==3052202| ///sending_opeid==3052300| ///sending_opeid==3052800| ///sending_opeid==3054100| ///sending_opeid==3054200| ///sending_opeid==3061100| ///sending_opeid==3061200| ///sending_opeid==3061201| ///sending_opeid==3061400| ///sending_opeid==3061800| ///sending_opeid==3061801| ///sending_opeid==3061900| ///sending_opeid==3062300| ///sending_opeid==3062400| ///sending_opeid==3062700| ///sending_opeid==3062701| ///sending_opeid==3063300| ///sending_opeid==3063400| ///sending_opeid==3064400| ///sending_opeid==3064600| ///sending_opeid==3064900| ///sending_opeid==3065000| ///sending_opeid==3065100| ///sending_opeid==3065300| ///sending_opeid==3065900| ///sending_opeid==3066200| ///sending_opeid==3066300| ///sending_opeid==3066500| ///sending_opeid==3066500| ///sending_opeid==3066600| ///sending_opeid==3066700| ///sending_opeid==3066900| ///sending_opeid==3067000| ///sending_opeid==3067300| ///sending_opeid==3067400| ///sending_opeid==3067500| ///sending_opeid==3067600| ///sending_opeid==3068200| ///sending_opeid==3068201| ///sending_opeid==3068202| ///sending_opeid==3068400| ///sending_opeid==3069100| ///sending_opeid==3069300| ///sending_opeid==3069500| ///sending_opeid==3070200| ///sending_opeid==3070500| ///sending_opeid==3070900| ///sending_opeid==3071600| ///sending_opeid==3071800| ///sending_opeid==3071900| ///sending_opeid==3072200| ///sending_opeid==3072300| ///sending_opeid==3072303| ///sending_opeid==3072304| ///sending_opeid==3072500| ///sending_opeid==3072600| ///sending_opeid==3072700| ///sending_opeid==3072800| ///sending_opeid==3074400| ///sending_opeid==3074500| ///sending_opeid==3074900| ///sending_opeid==3075200| ///sending_opeid==3075400| ///sending_opeid==3075600| ///sending_opeid==3076000| ///sending_opeid==3076100| ///sending_opeid==3076300| ///sending_opeid==3076400| ///sending_opeid==3076500| ///sending_opeid==3077200| ///sending_opeid==3077500| ///sending_opeid==3078000| ///sending_opeid==3078200| ///sending_opeid==3078400| ///sending_opeid==3078500| ///sending_opeid==3079000| ///sending_opeid==3079100| ///sending_opeid==3079200| ///sending_opeid==3079400)replace vsending_opeid=1 if firstime==5 & (sending_opeid==3079800| ///sending_opeid==3079900| ///sending_opeid==3080000| ///sending_opeid==3081200| ///sending_opeid==3081300| ///sending_opeid==3081500| ///sending_opeid==3081600| ///sending_opeid==3081900| ///sending_opeid==3082100| ///sending_opeid==3082900| ///sending_opeid==3083000| ///sending_opeid==3083700| ///sending_opeid==3083800| ///sending_opeid==3084200| ///sending_opeid==3084400| ///sending_opeid==3084700| ///sending_opeid==3084800| ///sending_opeid==3085200| ///sending_opeid==3085201| ///sending_opeid==3085700| ///sending_opeid==3087200| ///sending_opeid==3087700| ///sending_opeid==3088200| ///sending_opeid==3088300| ///sending_opeid==3088500| ///sending_opeid==3088800| ///sending_opeid==3089100| ///sending_opeid==3089200| ///sending_opeid==3089300| ///sending_opeid==3089400| ///sending_opeid==3089700| ///sending_opeid==3089701| ///sending_opeid==3090000| ///sending_opeid==3090000| ///sending_opeid==3090600| ///sending_opeid==3090800| ///sending_opeid==3091100| ///sending_opeid==3091200| ///sending_opeid==3091300| ///sending_opeid==3092600| ///sending_opeid==3092700| ///sending_opeid==3094400| ///sending_opeid==3094800| ///sending_opeid==3095100| ///sending_opeid==3095500| ///sending_opeid==3095600| ///sending_opeid==3096200| ///sending_opeid==3096300| ///sending_opeid==3096400| ///sending_opeid==3096500| ///sending_opeid==3097000| ///sending_opeid==3097200| ///sending_opeid==3097600| ///sending_opeid==3097700| ///sending_opeid==3097800| ///sending_opeid==3097801| ///sending_opeid==3098000| ///sending_opeid==3098002| ///sending_opeid==3098100| ///sending_opeid==3098200| ///sending_opeid==3098300| ///sending_opeid==3098600| ///sending_opeid==3098700| ///sending_opeid==3099000| ///sending_opeid==3099100| ///sending_opeid==3099200| ///sending_opeid==3099300| ///sending_opeid==3099301| ///sending_opeid==3099600| ///sending_opeid==3099700| ///sending_opeid==3099800| ///sending_opeid==3100100| ///sending_opeid==3100400| ///sending_opeid==3100600| ///sending_opeid==3100700| ///sending_opeid==3100800| ///sending_opeid==3100900| ///sending_opeid==3101000| ///sending_opeid==3101200| ///sending_opeid==3101300| ///sending_opeid==3101400| ///sending_opeid==3101500| ///sending_opeid==3101800| ///sending_opeid==3101900| ///sending_opeid==3102000| ///sending_opeid==3102100| ///sending_opeid==3103300| ///sending_opeid==3103400| ///sending_opeid==3103500| ///sending_opeid==3103700| ///sending_opeid==3103800| ///sending_opeid==3103801| ///sending_opeid==3103900| ///sending_opeid==3104000| ///sending_opeid==3104200| ///sending_opeid==3104300| ///sending_opeid==3104400| ///sending_opeid==3104500| ///sending_opeid==3104900| ///sending_opeid==3105200| ///sending_opeid==3105400| ///sending_opeid==3105700| ///sending_opeid==3105702| ///sending_opeid==3105900| ///sending_opeid==3106000| ///sending_opeid==3106200| ///sending_opeid==3106500| ///sending_opeid==3106700| ///sending_opeid==3106900| ///sending_opeid==3107000| ///sending_opeid==3108100| ///sending_opeid==3108200| ///sending_opeid==3108500| ///sending_opeid==3108600| ///sending_opeid==3108700| ///sending_opeid==3109000| ///sending_opeid==3109100| ///sending_opeid==3109500| ///sending_opeid==3109700| ///sending_opeid==3109800| ///sending_opeid==3110000| ///sending_opeid==3110200| ///sending_opeid==3110300| ///sending_opeid==3110400| ///sending_opeid==3110700| ///sending_opeid==3110800| ///sending_opeid==3110900| ///sending_opeid==3111000| ///sending_opeid==3111100| ///sending_opeid==3112100| ///sending_opeid==3113100| ///sending_opeid==3113102| ///sending_opeid==3113105| ///sending_opeid==3113106| ///sending_opeid==3113300| ///sending_opeid==3113400| ///sending_opeid==3113600| ///sending_opeid==3114700| ///sending_opeid==3114900| ///sending_opeid==3115000| ///sending_opeid==3115100| ///sending_opeid==3115200| ///sending_opeid==3115300| ///sending_opeid==3115400| ///sending_opeid==3115500| ///sending_opeid==3115900| ///sending_opeid==3116100| ///sending_opeid==3116200| ///sending_opeid==3116300| ///sending_opeid==3116400| ///sending_opeid==3116600| ///sending_opeid==3116800| ///sending_opeid==3116900| ///sending_opeid==3117000| ///sending_opeid==3120300| ///sending_opeid==3120301| ///sending_opeid==3120700| ///sending_opeid==3120800| ///sending_opeid==3122500| ///sending_opeid==3122600| ///sending_opeid==3122601| ///sending_opeid==3122900| ///sending_opeid==3123000| ///sending_opeid==3123100| ///sending_opeid==3123200| ///sending_opeid==3123203| ///sending_opeid==3123210| ///sending_opeid==3123900| ///sending_opeid==3123901| ///sending_opeid==3124000| ///sending_opeid==3124200| ///sending_opeid==3124800| ///sending_opeid==3124900| ///sending_opeid==3125100| ///sending_opeid==3125300| ///sending_opeid==3125600| ///sending_opeid==3125800| ///sending_opeid==3126000| ///sending_opeid==3126200| ///sending_opeid==3126300| ///sending_opeid==3126400| ///sending_opeid==3126401| ///sending_opeid==3126800| ///sending_opeid==3126900| ///sending_opeid==3127100| ///sending_opeid==3127200| ///sending_opeid==3127500| ///sending_opeid==3127900| ///sending_opeid==3128000| ///sending_opeid==3128100| ///sending_opeid==3128200| ///sending_opeid==3128300| ///sending_opeid==3128400| ///sending_opeid==3128500| ///sending_opeid==3128700| ///sending_opeid==3128800| ///sending_opeid==3129100| ///sending_opeid==3129200| ///sending_opeid==3130500| ///sending_opeid==3131300| ///sending_opeid==3135300| ///sending_opeid==3138400| ///sending_opeid==3142300| ///sending_opeid==3144300| ///sending_opeid==3144400| ///sending_opeid==3147300| ///sending_opeid==3148300| ///sending_opeid==3149300| ///sending_opeid==3150500| ///sending_opeid==3153300| ///sending_opeid==3155500| ///sending_opeid==3156300| ///sending_opeid==3156400| ///sending_opeid==3157600| ///sending_opeid==3158300| ///sending_opeid==3159300| ///sending_opeid==3160300| ///sending_opeid==3162300| ///sending_opeid==3163300| ///sending_opeid==3164300| ///sending_opeid==3166300| ///sending_opeid==3169300| ///sending_opeid==3170300| ///sending_opeid==3171300| ///sending_opeid==3172400| ///sending_opeid==3173300| ///sending_opeid==3174300| ///sending_opeid==3176300| ///sending_opeid==3177300| ///sending_opeid==3178400| ///sending_opeid==3179500| ///sending_opeid==3180400| ///sending_opeid==3181300| ///sending_opeid==3181400| ///sending_opeid==3182300| ///sending_opeid==3185300| ///sending_opeid==3187301| ///sending_opeid==3189300| ///sending_opeid==3189400| ///sending_opeid==3191300| ///sending_opeid==3193300| ///sending_opeid==3194300| ///sending_opeid==3195400| ///sending_opeid==3197300| ///sending_opeid==3198400| ///sending_opeid==3199300| ///sending_opeid==3200500| ///sending_opeid==3203300| ///sending_opeid==3205300)replace vsending_opeid=1 if firstime==5 & (sending_opeid==3205400| ///sending_opeid==3206300| ///sending_opeid==3208300| ///sending_opeid==3210300| ///sending_opeid==3212300| ///sending_opeid==3214300| ///sending_opeid==3216300| ///sending_opeid==3218300| ///sending_opeid==3220300| ///sending_opeid==3224300| ///sending_opeid==3225300| ///sending_opeid==3230300| ///sending_opeid==3231400| ///sending_opeid==3232303| ///sending_opeid==3232305| ///sending_opeid==3234300| ///sending_opeid==3235300| ///sending_opeid==3236400| ///sending_opeid==3237300| ///sending_opeid==3237400| ///sending_opeid==3238300| ///sending_opeid==3240300| ///sending_opeid==3242300| ///sending_opeid==3247300| ///sending_opeid==3248300| ///sending_opeid==3250300| ///sending_opeid==3251300| ///sending_opeid==3253300| ///sending_opeid==3253304| ///sending_opeid==3254300| ///sending_opeid==3254300| ///sending_opeid==3255300| ///sending_opeid==3256300| ///sending_opeid==3258300| ///sending_opeid==3260300| ///sending_opeid==3262300| ///sending_opeid==3263300| ///sending_opeid==3264300| ///sending_opeid==3266300| ///sending_opeid==3267300| ///sending_opeid==3268300| ///sending_opeid==3271300| ///sending_opeid==3272300| ///sending_opeid==3275300| ///sending_opeid==3276300| ///sending_opeid==3276301| ///sending_opeid==3277300| ///sending_opeid==3278300| ///sending_opeid==3279300| ///sending_opeid==3280300| ///sending_opeid==3280400| ///sending_opeid==3282300| ///sending_opeid==3283300| ///sending_opeid==3284300| ///sending_opeid==3288300| ///sending_opeid==3289300| ///sending_opeid==3293300| ///sending_opeid==3294300| ///sending_opeid==3294301| ///sending_opeid==3294303| ///sending_opeid==3294304| ///sending_opeid==3294305| ///sending_opeid==3294306| ///sending_opeid==3294307| ///sending_opeid==3296300| ///sending_opeid==3299300| ///sending_opeid==3303300| ///sending_opeid==3304300| ///sending_opeid==3304301| ///sending_opeid==3305300| ///sending_opeid==3306300| ///sending_opeid==3308300| ///sending_opeid==3309300| ///sending_opeid==3315300| ///sending_opeid==3316300| ///sending_opeid==3316400| ///sending_opeid==3317300| ///sending_opeid==3319300| ///sending_opeid==3319301| ///sending_opeid==3321300| ///sending_opeid==3323300| ///sending_opeid==3324300| ///sending_opeid==3326300| ///sending_opeid==3327300| ///sending_opeid==3327400| ///sending_opeid==3327500| ///sending_opeid==3328300| ///sending_opeid==3329400| ///sending_opeid==3330300| ///sending_opeid==3332300| ///sending_opeid==3332600| ///sending_opeid==3336300| ///sending_opeid==3339400| ///sending_opeid==3340300| ///sending_opeid==3341300| ///sending_opeid==3342400| ///sending_opeid==3346300| ///sending_opeid==3347300| ///sending_opeid==3348400| ///sending_opeid==3353300| ///sending_opeid==3355300| ///sending_opeid==3355400| ///sending_opeid==3356300| ///sending_opeid==3358300| ///sending_opeid==3359300| ///sending_opeid==3360500| ///sending_opeid==3361300| ///sending_opeid==3361400| ///sending_opeid==3361500| ///sending_opeid==3361600| ///sending_opeid==3367300| ///sending_opeid==3367400| ///sending_opeid==3368300| ///sending_opeid==3368301| ///sending_opeid==3368302| ///sending_opeid==3370300| ///sending_opeid==3371300| ///sending_opeid==3372300| ///sending_opeid==3373300| ///sending_opeid==3374300| ///sending_opeid==3380300| ///sending_opeid==3380301| ///sending_opeid==3380302| ///sending_opeid==3381300| ///sending_opeid==3382300| ///sending_opeid==3389300| ///sending_opeid==3390300| ///sending_opeid==3391300| ///sending_opeid==3392300| ///sending_opeid==3394300| ///sending_opeid==3395300| ///sending_opeid==3396300| ///sending_opeid==3396400| ///sending_opeid==3396500| ///sending_opeid==3397500| ///sending_opeid==3399300| ///sending_opeid==3400300| ///sending_opeid==3403300| ///sending_opeid==3409500| ///sending_opeid==3409600| ///sending_opeid==3411400| ///sending_opeid==3412300| ///sending_opeid==3413300| ///sending_opeid==3413400| ///sending_opeid==3414300| ///sending_opeid==3414500| ///sending_opeid==3415300| ///sending_opeid==3416300| ///sending_opeid==3416400| ///sending_opeid==3416500| ///sending_opeid==3418300| ///sending_opeid==3419400| ///sending_opeid==3422300| ///sending_opeid==3422400| ///sending_opeid==3424400| ///sending_opeid==3424500| ///sending_opeid==3425300| ///sending_opeid==3425400| ///sending_opeid==3426300| ///sending_opeid==3426400| ///sending_opeid==3427400| ///sending_opeid==3427500| ///sending_opeid==3428300| ///sending_opeid==3429300| ///sending_opeid==3429600| ///sending_opeid==3429700| ///sending_opeid==3430300| ///sending_opeid==3433400| ///sending_opeid==3433500| ///sending_opeid==3434300| ///sending_opeid==3437300| ///sending_opeid==3438300| ///sending_opeid==3439400| ///sending_opeid==3440300| ///sending_opeid==3440400| ///sending_opeid==3441300| ///sending_opeid==3441400| ///sending_opeid==3443300| ///sending_opeid==3445300| ///sending_opeid==3445500| ///sending_opeid==3448300| ///sending_opeid==3450300| ///sending_opeid==3450301| ///sending_opeid==3450302| ///sending_opeid==3451300| ///sending_opeid==3452300| ///sending_opeid==3453400| ///sending_opeid==3454300| ///sending_opeid==3455300| ///sending_opeid==3455400| ///sending_opeid==3455500| ///sending_opeid==3455700| ///sending_opeid==3455900| ///sending_opeid==3456300| ///sending_opeid==3456700| ///sending_opeid==3457300| ///sending_opeid==3458300| ///sending_opeid==3459300| ///sending_opeid==3459300)replace vsending_opeid=1 if firstime==5 & (sending_opeid==3459400| ///sending_opeid==3461300| ///sending_opeid==3461400| ///sending_opeid==3462300| ///sending_opeid==3463300| ///sending_opeid==3464300| ///sending_opeid==3466400| ///sending_opeid==3467300| ///sending_opeid==3468400| ///sending_opeid==3468500| ///sending_opeid==3469300| ///sending_opeid==3471400| ///sending_opeid==3472300| ///sending_opeid==3473400| ///sending_opeid==3474400| ///sending_opeid==3474700| ///sending_opeid==3475400| ///sending_opeid==3478400| ///sending_opeid==3479300| ///sending_opeid==3479400| ///sending_opeid==3480300| ///sending_opeid==3483500| ///sending_opeid==3485400| ///sending_opeid==3486300| ///sending_opeid==3490300| ///sending_opeid==3490400| ///sending_opeid==3491400| ///sending_opeid==3493300| ///sending_opeid==3493301| ///sending_opeid==3493302| ///sending_opeid==3496300| ///sending_opeid==3498400| ///sending_opeid==3503300| ///sending_opeid==3504300| ///sending_opeid==3506300| ///sending_opeid==3509400| ///sending_opeid==3510300| ///sending_opeid==3513300| ///sending_opeid==3513400| ///sending_opeid==3513500| ///sending_opeid==3516300| ///sending_opeid==3516500| ///sending_opeid==3519300| ///sending_opeid==3519400| ///sending_opeid==3520300| ///sending_opeid==3522300| ///sending_opeid==3523300| ///sending_opeid==3528300| ///sending_opeid==3529300| ///sending_opeid==3530300| ///sending_opeid==3531300| ///sending_opeid==3532400| ///sending_opeid==3534300| ///sending_opeid==3534400| ///sending_opeid==3535300| ///sending_opeid==3536300| ///sending_opeid==3537300| ///sending_opeid==3538300| ///sending_opeid==3541300| ///sending_opeid==3542300| ///sending_opeid==3542400| ///sending_opeid==3543300| ///sending_opeid==3543300| ///sending_opeid==3544300| ///sending_opeid==3544400| ///sending_opeid==3545300| ///sending_opeid==3549300| ///sending_opeid==3550300| ///sending_opeid==3551400| ///sending_opeid==3552300| ///sending_opeid==3553300| ///sending_opeid==3555300| ///sending_opeid==3555400| ///sending_opeid==3556400| ///sending_opeid==3557300| ///sending_opeid==3559300| ///sending_opeid==3561400| ///sending_opeid==3563300| ///sending_opeid==3564300| ///sending_opeid==3568300| ///sending_opeid==3570300| ///sending_opeid==3570400| ///sending_opeid==3570500| ///sending_opeid==3572300| ///sending_opeid==3572300| ///sending_opeid==3573300| ///sending_opeid==3574400| ///sending_opeid==3576300| ///sending_opeid==3577300| ///sending_opeid==3578300| ///sending_opeid==3579300| ///sending_opeid==3584400| ///sending_opeid==3585300| ///sending_opeid==3586400| ///sending_opeid==3588300| ///sending_opeid==3590400| ///sending_opeid==3592400| ///sending_opeid==3593300| ///sending_opeid==3595300| ///sending_opeid==3595300| ///sending_opeid==3595400| ///sending_opeid==3598300| ///sending_opeid==3600300| ///sending_opeid==3602400| ///sending_opeid==3607400| ///sending_opeid==3608300| ///sending_opeid==3610300| ///sending_opeid==3611300| ///sending_opeid==3611400| ///sending_opeid==3611500| ///sending_opeid==3612300| ///sending_opeid==3612400| ///sending_opeid==3614300| ///sending_opeid==3615300| ///sending_opeid==3616300| ///sending_opeid==3617300| ///sending_opeid==3617500| ///sending_opeid==3618300| ///sending_opeid==3620300| ///sending_opeid==3621300| ///sending_opeid==3622300| ///sending_opeid==3623300| ///sending_opeid==3625300| ///sending_opeid==3626300| ///sending_opeid==3627300| ///sending_opeid==3627400| ///sending_opeid==3627600| ///sending_opeid==3629300| ///sending_opeid==3631500| ///sending_opeid==3633300| ///sending_opeid==3635300| ///sending_opeid==3637300| ///sending_opeid==3638300| ///sending_opeid==3638400| ///sending_opeid==3639300| ///sending_opeid==3642300| ///sending_opeid==3643300| ///sending_opeid==3645400| ///sending_opeid==3646300| ///sending_opeid==3647300| ///sending_opeid==3649300| ///sending_opeid==3650600| ///sending_opeid==3651300| ///sending_opeid==3652300| ///sending_opeid==3654300| ///sending_opeid==3655300| ///sending_opeid==3659300| ///sending_opeid==3660300| ///sending_opeid==3661400| ///sending_opeid==3662400| ///sending_opeid==3663300| ///sending_opeid==3663400| ///sending_opeid==3664300| ///sending_opeid==3665400| ///sending_opeid==3666300| ///sending_opeid==3667300| ///sending_opeid==3668300| ///sending_opeid==3669300| ///sending_opeid==3670300| ///sending_opeid==3670301| ///sending_opeid==3676300| ///sending_opeid==3676400| ///sending_opeid==3678300| ///sending_opeid==3680300| ///sending_opeid==3681300| ///sending_opeid==3682400| ///sending_opeid==3683300| ///sending_opeid==3684300| ///sending_opeid==3686300| ///sending_opeid==3689400| ///sending_opeid==3691300| ///sending_opeid==3691400| ///sending_opeid==3693300| ///sending_opeid==3695300| ///sending_opeid==3695500| ///sending_opeid==3695700| ///sending_opeid==3696300| ///sending_opeid==3696400| ///sending_opeid==3698300| ///sending_opeid==3698400| ///sending_opeid==3700300| ///sending_opeid==3701300| ///sending_opeid==3702300| ///sending_opeid==3704300| ///sending_opeid==3706300| ///sending_opeid==3707500| ///sending_opeid==3708300| ///sending_opeid==3709300| ///sending_opeid==3713300| ///sending_opeid==3714300| ///sending_opeid==3720300| ///sending_opeid==3721400| ///sending_opeid==3723300| ///sending_opeid==3724300| ///sending_opeid==3726300| ///sending_opeid==3727500| ///sending_opeid==3727600| ///sending_opeid==3729300| ///sending_opeid==3729301| ///sending_opeid==3730300| ///sending_opeid==3731300| ///sending_opeid==3732300| ///sending_opeid==3733300| ///sending_opeid==3734300| ///sending_opeid==3735300| ///sending_opeid==3735400| ///sending_opeid==3736300| ///sending_opeid==3740400| ///sending_opeid==3740401| ///sending_opeid==3742300| ///sending_opeid==3744300| ///sending_opeid==3746300| ///sending_opeid==3746400| ///sending_opeid==3747300| ///sending_opeid==3748300| ///sending_opeid==3748500| ///sending_opeid==3750300| ///sending_opeid==3751300| ///sending_opeid==3752400| ///sending_opeid==3755300| ///sending_opeid==3756301| ///sending_opeid==3757300| ///sending_opeid==3758300| ///sending_opeid==3759300| ///sending_opeid==3763300| ///sending_opeid==3763400| ///sending_opeid==3766300| ///sending_opeid==3768400| ///sending_opeid==3769300| ///sending_opeid==3771300| ///sending_opeid==3772300| ///sending_opeid==3773300| ///sending_opeid==3774400| ///sending_opeid==3775300| ///sending_opeid==3776300| ///sending_opeid==3776400| ///sending_opeid==3777300| ///sending_opeid==3778300| ///sending_opeid==3781300| ///sending_opeid==3781400| ///sending_opeid==3783300| ///sending_opeid==3783400| ///sending_opeid==3784400| ///sending_opeid==3785300| ///sending_opeid==3786300| ///sending_opeid==3787300| ///sending_opeid==3789300| ///sending_opeid==3789400| ///sending_opeid==3795300| ///sending_opeid==3797400| ///sending_opeid==3800300| ///sending_opeid==3800400| ///sending_opeid==3801400| ///sending_opeid==3802300| ///sending_opeid==3803300| ///sending_opeid==3804300| ///sending_opeid==3804400| ///sending_opeid==3805300| ///sending_opeid==3806300| ///sending_opeid==3808300| ///sending_opeid==3809400| ///sending_opeid==3810300| ///sending_opeid==3810400| ///sending_opeid==3810500| ///sending_opeid==3811300| ///sending_opeid==3812300| ///sending_opeid==3813300| ///sending_opeid==3814300| ///sending_opeid==3814400| ///sending_opeid==3815300| ///sending_opeid==3816300| ///sending_opeid==3817300| ///sending_opeid==3819300| ///sending_opeid==3819400| ///sending_opeid==3821400| ///sending_opeid==3822300| ///sending_opeid==3822400| ///sending_opeid==3823300| ///sending_opeid==3827300| ///sending_opeid==3829500| ///sending_opeid==3830300| ///sending_opeid==3831300| ///sending_opeid==3832300| ///sending_opeid==3832400| ///sending_opeid==3833300| ///sending_opeid==3837300| ///sending_opeid==3838300| ///sending_opeid==3838400| ///sending_opeid==3838500| ///sending_opeid==3839300| ///sending_opeid==3840300| ///sending_opeid==3841300| ///sending_opeid==3842300| ///sending_opeid==3842500| ///sending_opeid==3843300| ///sending_opeid==3848300| ///sending_opeid==3853300| ///sending_opeid==3853400| ///sending_opeid==3855300)replace vsending_opeid=1 if firstime==5 & (sending_opeid==3856300| ///sending_opeid==3856400| ///sending_opeid==3856500| ///sending_opeid==3859300| ///sending_opeid==3862300| ///sending_opeid==3862600| ///sending_opeid==3866300| ///sending_opeid==3868300| ///sending_opeid==3868400| ///sending_opeid==3871300| ///sending_opeid==3872400| ///sending_opeid==3872500| ///sending_opeid==3874300| ///sending_opeid==3874400| ///sending_opeid==3875300| ///sending_opeid==3876300| ///sending_opeid==3878300| ///sending_opeid==3881300| ///sending_opeid==3881400| ///sending_opeid==3883400| ///sending_opeid==3885300| ///sending_opeid==3885400| ///sending_opeid==3885700| ///sending_opeid==3886300| ///sending_opeid==3888300| ///sending_opeid==3889300| ///sending_opeid==3891300| ///sending_opeid==3892300| ///sending_opeid==3894300| ///sending_opeid==3899300| ///sending_opeid==3901300| ///sending_opeid==3902300| ///sending_opeid==3903400| ///sending_opeid==3903500| ///sending_opeid==3907300| ///sending_opeid==3909300| ///sending_opeid==3910400| ///sending_opeid==3911300| ///sending_opeid==3912300| ///sending_opeid==3914300| ///sending_opeid==3915300| ///sending_opeid==3916300| ///sending_opeid==3917300| ///sending_opeid==3918300| ///sending_opeid==3920300| ///sending_opeid==3921300| ///sending_opeid==3921400| ///sending_opeid==3922300| ///sending_opeid==3923300| ///sending_opeid==3924300| ///sending_opeid==3925300| ///sending_opeid==3926300| ///sending_opeid==3927300| ///sending_opeid==3927301| ///sending_opeid==3928300| ///sending_opeid==3930300| ///sending_opeid==3932400| ///sending_opeid==3932500| ///sending_opeid==3933300| ///sending_opeid==3935300| ///sending_opeid==3937300| ///sending_opeid==3939300| ///sending_opeid==3939400| ///sending_opeid==3939500| ///sending_opeid==3939600| ///sending_opeid==3941300| ///sending_opeid==3941400| ///sending_opeid==3944300| ///sending_opeid==3944400| ///sending_opeid==3946300| ///sending_opeid==3948300| ///sending_opeid==3949300| ///sending_opeid==3950500| ///sending_opeid==3951300| ///sending_opeid==3952300| ///sending_opeid==3953300| ///sending_opeid==3955400| ///sending_opeid==3956300| ///sending_opeid==3957300| ///sending_opeid==3957400| ///sending_opeid==3960300| ///sending_opeid==3962300| ///sending_opeid==3963300| ///sending_opeid==3964400| ///sending_opeid==3965300| ///sending_opeid==3965400| ///sending_opeid==3965500| ///sending_opeid==3968300| ///sending_opeid==3969600| ///sending_opeid==3970300| ///sending_opeid==3970400| ///sending_opeid==3971300| ///sending_opeid==3972300| ///sending_opeid==3973300| ///sending_opeid==3974500| ///sending_opeid==3975300| ///sending_opeid==3976300| ///sending_opeid==3976500| ///sending_opeid==3980300| ///sending_opeid==3982300| ///sending_opeid==3983300| ///sending_opeid==3985300| ///sending_opeid==3986300| ///sending_opeid==3987300| ///sending_opeid==3988300| ///sending_opeid==3989300| ///sending_opeid==3995300| ///sending_opeid==3997300| ///sending_opeid==3999300| ///sending_opeid==3999400| ///sending_opeid==4001300| ///sending_opeid==4001400| ///sending_opeid==4002400| ///sending_opeid==4003300| ///sending_opeid==4004300| ///sending_opeid==4005300| ///sending_opeid==4006300| ///sending_opeid==4014300| ///sending_opeid==4014400| ///sending_opeid==4016500| ///sending_opeid==4021300| ///sending_opeid==4023400| ///sending_opeid==4024300| ///sending_opeid==4025300| ///sending_opeid==4027300| ///sending_opeid==4028300| ///sending_opeid==4029300| ///sending_opeid==4031300| ///sending_opeid==4035300| ///sending_opeid==4036300| ///sending_opeid==4037300| ///sending_opeid==4037500| ///sending_opeid==4038300| ///sending_opeid==4038400| ///sending_opeid==4038500| ///sending_opeid==4038600| ///sending_opeid==4038700| ///sending_opeid==4040300| ///sending_opeid==4041300| ///sending_opeid==4041400| ///sending_opeid==4043300| ///sending_opeid==4043400| ///sending_opeid==4044300| ///sending_opeid==4045300| ///sending_opeid==4045400| ///sending_opeid==4047300| ///sending_opeid==4048300| ///sending_opeid==4049300| ///sending_opeid==4050400| ///sending_opeid==4051300| ///sending_opeid==4054300| ///sending_opeid==4055300| ///sending_opeid==4056300| ///sending_opeid==4057300| ///sending_opeid==4058300| ///sending_opeid==4059300| ///sending_opeid==4060300| ///sending_opeid==4062300| ///sending_opeid==4065300| ///sending_opeid==4066300| ///sending_opeid==4067300| ///sending_opeid==4068300| ///sending_opeid==4071300| ///sending_opeid==4072300| ///sending_opeid==4073300| ///sending_opeid==4074300| ///sending_opeid==4076400| ///sending_opeid==4080300| ///sending_opeid==4081300| ///sending_opeid==4082300| ///sending_opeid==4083400| ///sending_opeid==4088300| ///sending_opeid==4089300| ///sending_opeid==4089400| ///sending_opeid==4091300| ///sending_opeid==4092300| ///sending_opeid==4092400| ///sending_opeid==4093300| ///sending_opeid==4094300| ///sending_opeid==4095300| ///sending_opeid==4096300| ///sending_opeid==4098300| ///sending_opeid==4100300| ///sending_opeid==4100400| ///sending_opeid==4101300| ///sending_opeid==4102300| ///sending_opeid==4104300| ///sending_opeid==4105400| ///sending_opeid==4106300| ///sending_opeid==4107300| ///sending_opeid==4109300| ///sending_opeid==4110300| ///sending_opeid==4111300| ///sending_opeid==4112300| ///sending_opeid==4114300| ///sending_opeid==4114400| ///sending_opeid==4114500| ///sending_opeid==4115300| ///sending_opeid==4115500| ///sending_opeid==4115600| ///sending_opeid==4115700| ///sending_opeid==4115800| ///sending_opeid==4116000| ///sending_opeid==4116400| ///sending_opeid==4116500| ///sending_opeid==4116600| ///sending_opeid==4116700| ///sending_opeid==4116900| ///sending_opeid==4117100| ///sending_opeid==4117200| ///sending_opeid==4117300| ///sending_opeid==4117400| ///sending_opeid==4117500| ///sending_opeid==4117700| ///sending_opeid==4117900| ///sending_opeid==4118000| ///sending_opeid==4118100| ///sending_opeid==4118300| ///sending_opeid==4118400| ///sending_opeid==4118600| ///sending_opeid==4118700| ///sending_opeid==4119000| ///sending_opeid==4119100| ///sending_opeid==4119200| ///sending_opeid==4119400| ///sending_opeid==4119600| ///sending_opeid==4119700| ///sending_opeid==4119900| ///sending_opeid==4120000| ///sending_opeid==4120300| ///sending_opeid==4120400| ///sending_opeid==4120500| ///sending_opeid==4120700| ///sending_opeid==4120900| ///sending_opeid==4121000| ///sending_opeid==4121100| ///sending_opeid==4121200| ///sending_opeid==4121300| ///sending_opeid==4121500| ///sending_opeid==4121600| ///sending_opeid==4121700| ///sending_opeid==4121800| ///sending_opeid==4122000| ///sending_opeid==4122300| ///sending_opeid==4123300| ///sending_opeid==4123400| ///sending_opeid==4123900| ///sending_opeid==4124000| ///sending_opeid==4124100)replace vsending_opeid=1 if firstime==5 & (sending_opeid==4124500| ///sending_opeid==4124700| ///sending_opeid==4124800| ///sending_opeid==4125000| ///sending_opeid==4125100| ///sending_opeid==4125400| ///sending_opeid==4125500| ///sending_opeid==4125600| ///sending_opeid==4125700| ///sending_opeid==4126000| ///sending_opeid==4126400| ///sending_opeid==4126500| ///sending_opeid==4126800| ///sending_opeid==4126900| ///sending_opeid==4127000| ///sending_opeid==4127100| ///sending_opeid==4127200| ///sending_opeid==4127300| ///sending_opeid==4127400| ///sending_opeid==4127500| ///sending_opeid==4127700| ///sending_opeid==4127800| ///sending_opeid==4127900| ///sending_opeid==4128000| ///sending_opeid==4128400| ///sending_opeid==4128800| ///sending_opeid==4128900| ///sending_opeid==4129300| ///sending_opeid==4129400| ///sending_opeid==4129700| ///sending_opeid==4129800| ///sending_opeid==4129900| ///sending_opeid==4130100| ///sending_opeid==4130200| ///sending_opeid==4130300| ///sending_opeid==4130400| ///sending_opeid==4130500| ///sending_opeid==4130600| ///sending_opeid==4130700| ///sending_opeid==4130800| ///sending_opeid==4130900| ///sending_opeid==4131100| ///sending_opeid==4131200| ///sending_opeid==4131300| ///sending_opeid==4131400| ///sending_opeid==4131500| ///sending_opeid==4131600| ///sending_opeid==4131700| ///sending_opeid==4131900| ///sending_opeid==4132000| ///sending_opeid==4132100| ///sending_opeid==4132200| ///sending_opeid==4132300| ///sending_opeid==4132400| ///sending_opeid==4132600| ///sending_opeid==4132700| ///sending_opeid==4132800| ///sending_opeid==4132900| ///sending_opeid==4133000| ///sending_opeid==4133100| ///sending_opeid==4133300| ///sending_opeid==4133400| ///sending_opeid==4133500| ///sending_opeid==4133600| ///sending_opeid==4133700| ///sending_opeid==4133800| ///sending_opeid==4133900| ///sending_opeid==4134000| ///sending_opeid==4134100| ///sending_opeid==4134300| ///sending_opeid==4134500| ///sending_opeid==4134700| ///sending_opeid==4134800| ///sending_opeid==4134900| ///sending_opeid==4135000| ///sending_opeid==4135600| ///sending_opeid==4135900| ///sending_opeid==4136300| ///sending_opeid==4136400| ///sending_opeid==4136500| ///sending_opeid==4136900| ///sending_opeid==4137000| ///sending_opeid==4137100| ///sending_opeid==4137200| ///sending_opeid==4137300| ///sending_opeid==4137400| ///sending_opeid==4137500| ///sending_opeid==4137700| ///sending_opeid==4137800| ///sending_opeid==4137900| ///sending_opeid==4137900| ///sending_opeid==4138000| ///sending_opeid==4138100| ///sending_opeid==4138200| ///sending_opeid==4138300| ///sending_opeid==4138400| ///sending_opeid==4138500| ///sending_opeid==4138600| ///sending_opeid==4138700| ///sending_opeid==4138800| ///sending_opeid==4139000| ///sending_opeid==4139200| ///sending_opeid==4139300| ///sending_opeid==4139400| ///sending_opeid==4139600| ///sending_opeid==4139700| ///sending_opeid==4139800| ///sending_opeid==4139900| ///sending_opeid==4140000| ///sending_opeid==4140200| ///sending_opeid==4140300| ///sending_opeid==4140400| ///sending_opeid==4140500| ///sending_opeid==4140600| ///sending_opeid==4140700| ///sending_opeid==4140800| ///sending_opeid==4140900| ///sending_opeid==4141000| ///sending_opeid==4141100| ///sending_opeid==4141200| ///sending_opeid==4141300| ///sending_opeid==4141400| ///sending_opeid==4141600| ///sending_opeid==4141700| ///sending_opeid==4142100| ///sending_opeid==4142300| ///sending_opeid==4142600| ///sending_opeid==4142700| ///sending_opeid==4142900| ///sending_opeid==4143000| ///sending_opeid==4143100| ///sending_opeid==4143200| ///sending_opeid==4143300| ///sending_opeid==4143400| ///sending_opeid==4143500| ///sending_opeid==4143800| ///sending_opeid==4144200| ///sending_opeid==4144300| ///sending_opeid==4144400| ///sending_opeid==4144500| ///sending_opeid==4144800| ///sending_opeid==4145000| ///sending_opeid==4145200| ///sending_opeid==4145400| ///sending_opeid==4145500| ///sending_opeid==4145600| ///sending_opeid==4145700| ///sending_opeid==4145800| ///sending_opeid==4145900| ///sending_opeid==4146000| ///sending_opeid==4146100| ///sending_opeid==4146200| ///sending_opeid==4146300| ///sending_opeid==4146400| ///sending_opeid==4146500| ///sending_opeid==4146600| ///sending_opeid==4146800| ///sending_opeid==4146900| ///sending_opeid==4147000| ///sending_opeid==4147100| ///sending_opeid==4147200| ///sending_opeid==4147300| ///sending_opeid==4147400| ///sending_opeid==4147500| ///sending_opeid==4147600| ///sending_opeid==4147700| ///sending_opeid==4147800| ///sending_opeid==4148000| ///sending_opeid==4148200| ///sending_opeid==4148300| ///sending_opeid==4148400| ///sending_opeid==4148500| ///sending_opeid==4148700| ///sending_opeid==4148800| ///sending_opeid==4148900| ///sending_opeid==4149100| ///sending_opeid==4149200| ///sending_opeid==4149300| ///sending_opeid==4149400| ///sending_opeid==4149500| ///sending_opeid==4149600| ///sending_opeid==4149700| ///sending_opeid==4149800| ///sending_opeid==4149900| ///sending_opeid==4150000| ///sending_opeid==4150100| ///sending_opeid==4150200| ///sending_opeid==4150300| ///sending_opeid==4150500| ///sending_opeid==4150600| ///sending_opeid==4150800| ///sending_opeid==4150900| ///sending_opeid==4151100| ///sending_opeid==4151200| ///sending_opeid==4151300| ///sending_opeid==4151400| ///sending_opeid==4151500| ///sending_opeid==4151600| ///sending_opeid==4151700| ///sending_opeid==4151800| ///sending_opeid==4151900| ///sending_opeid==4152100| ///sending_opeid==4152200| ///sending_opeid==4152300| ///sending_opeid==4152400| ///sending_opeid==4152600| ///sending_opeid==4152700| ///sending_opeid==4152800| ///sending_opeid==4152900| ///sending_opeid==4153000| ///sending_opeid==4153200| ///sending_opeid==4153300| ///sending_opeid==4153800| ///sending_opeid==4153900| ///sending_opeid==4154000| ///sending_opeid==4154200| ///sending_opeid==4154300| ///sending_opeid==4154400| ///sending_opeid==4154500| ///sending_opeid==4154800| ///sending_opeid==4154900| ///sending_opeid==4155000| ///sending_opeid==4155100| ///sending_opeid==4155200| ///sending_opeid==4155300| ///sending_opeid==4155500| ///sending_opeid==4155800| ///sending_opeid==4155900| ///sending_opeid==4156000| ///sending_opeid==4156100| ///sending_opeid==4156200| ///sending_opeid==4156300| ///sending_opeid==4156400| ///sending_opeid==4156500| ///sending_opeid==4157100| ///sending_opeid==4157200| ///sending_opeid==4157400| ///sending_opeid==4157500| ///sending_opeid==4157600| ///sending_opeid==4157700| ///sending_opeid==4157800| ///sending_opeid==4158000| ///sending_opeid==4158100| ///sending_opeid==4158200| ///sending_opeid==4158300| ///sending_opeid==4158400| ///sending_opeid==4158500| ///sending_opeid==4158600| ///sending_opeid==4158900)replace vsending_opeid=1 if firstime==5 & (sending_opeid==4159300| ///sending_opeid==4159400|sending_opeid==4159600|sending_opeid==4159700|sending_opeid==4160100| ///sending_opeid==4160200|sending_opeid==4160400|sending_opeid==4160500|sending_opeid==4160600| ///sending_opeid==4160700|sending_opeid==4161100|sending_opeid==4161200|sending_opeid==4161300| ///sending_opeid==4161700|sending_opeid==4161800|sending_opeid==4161900|sending_opeid==4162000| ///sending_opeid==4162200|sending_opeid==4162400|sending_opeid==4162500|sending_opeid==4162700| ///sending_opeid==4162800|sending_opeid==4162900|sending_opeid==4163000|sending_opeid==4163100| ///sending_opeid==4163200|sending_opeid==4163300|sending_opeid==4163400|sending_opeid==4163700| ///sending_opeid==4163800|sending_opeid==4163900|sending_opeid==4164100|sending_opeid==4164300| ///sending_opeid==4164400|sending_opeid==4164500|sending_opeid==4164600|sending_opeid==4164700| ///sending_opeid==4164900|sending_opeid==4165000|sending_opeid==4165200|sending_opeid==4165300| ///sending_opeid==4165500|sending_opeid==4165700|sending_opeid==4165800|sending_opeid==4165900| ///sending_opeid==4166000|sending_opeid==4166700|sending_opeid==4166800|sending_opeid==4166900| ///sending_opeid==4167000|sending_opeid==4167100|sending_opeid==4167200|sending_opeid==4167300| ///sending_opeid==4167400| ///sending_opeid==4167500| ///sending_opeid==4167600| ///sending_opeid==4167700| ///sending_opeid==4167800| ///sending_opeid==4168300| ///sending_opeid==4168500| ///sending_opeid==4168600| ///sending_opeid==4168700| ///sending_opeid==4168800| ///sending_opeid==4168900| ///sending_opeid==4169000| ///sending_opeid==4169100| ///sending_opeid==4169200| ///sending_opeid==4169300| ///sending_opeid==4169400| ///sending_opeid==4169600| ///sending_opeid==4169700| ///sending_opeid==4169800| ///sending_opeid==4169900| ///sending_opeid==4170000| ///sending_opeid==4170100| ///sending_opeid==4170200| ///sending_opeid==4170300| ///sending_opeid==4170600| ///sending_opeid==4170700| ///sending_opeid==4170800| ///sending_opeid==4171000| ///sending_opeid==4171100| ///sending_opeid==4171400| ///sending_opeid==4171500| ///sending_opeid==4171600| ///sending_opeid==4171700| ///sending_opeid==4172000| ///sending_opeid==4172100| ///sending_opeid==4172200| ///sending_opeid==4172300| ///sending_opeid==4172500| ///sending_opeid==4172600| ///sending_opeid==4172700| ///sending_opeid==4172800| ///sending_opeid==4172900| ///sending_opeid==4173000| ///sending_opeid==4173100| ///sending_opeid==4173200| ///sending_opeid==4173400| ///sending_opeid==4173500| ///sending_opeid==4173600| ///sending_opeid==4173700| ///sending_opeid==4173800| ///sending_opeid==4173900| ///sending_opeid==4174000| ///sending_opeid==4174100| ///sending_opeid==4174200| ///sending_opeid==4174400| ///sending_opeid==4174500| ///sending_opeid==4174600| ///sending_opeid==4174800| ///sending_opeid==4174900| ///sending_opeid==4175000| ///sending_opeid==4175100| ///sending_opeid==4175200| ///sending_opeid==4175300| ///sending_opeid==4175400| ///sending_opeid==4175600| ///sending_opeid==4175700| ///sending_opeid==4175800| ///sending_opeid==4175900| ///sending_opeid==4176100| ///sending_opeid==4176200| ///sending_opeid==4176300| ///sending_opeid==4176700| ///sending_opeid==4176800| ///sending_opeid==4176900| ///sending_opeid==4177100| ///sending_opeid==4177200| ///sending_opeid==4177300| ///sending_opeid==4177400| ///sending_opeid==4177500| ///sending_opeid==4177600| ///sending_opeid==4177700| ///sending_opeid==4177800| ///sending_opeid==4177900| ///sending_opeid==4178000| ///sending_opeid==4178100| ///sending_opeid==4178200| ///sending_opeid==4178300| ///sending_opeid==4178400| ///sending_opeid==4178500| ///sending_opeid==4178700| ///sending_opeid==4178900| ///sending_opeid==4178900| ///sending_opeid==4179100| ///sending_opeid==4179200| ///sending_opeid==4179500| ///sending_opeid==4179600| ///sending_opeid==4179700| ///sending_opeid==4179800| ///sending_opeid==4179900| ///sending_opeid==4180000| ///sending_opeid==4180200| ///sending_opeid==4180300| ///sending_opeid==4180600| ///sending_opeid==4181200| ///sending_opeid==4181400| ///sending_opeid==4182100| ///sending_opeid==4182200| ///sending_opeid==4182500| ///sending_opeid==4183000| ///sending_opeid==4183100| ///sending_opeid==4183300| ///sending_opeid==4183400| ///sending_opeid==4183600| ///sending_opeid==4183700| ///sending_opeid==4184000| ///sending_opeid==4184200| ///sending_opeid==4184400| ///sending_opeid==4184500| ///sending_opeid==4184700| ///sending_opeid==4184800| ///sending_opeid==4184900| ///sending_opeid==4185000| ///sending_opeid==4185100| ///sending_opeid==4185200| ///sending_opeid==4185400| ///sending_opeid==4185500| ///sending_opeid==4185600| ///sending_opeid==4185700| ///sending_opeid==4185900|sending_opeid==4186000|sending_opeid==4186300|sending_opeid==4186600| ///sending_opeid==4186900|sending_opeid==4187000|sending_opeid==4187200|sending_opeid==4187300| ///sending_opeid==4187700|sending_opeid==4187800|sending_opeid==4187900|sending_opeid==4188300| ///sending_opeid==4188400|sending_opeid==4188700|sending_opeid==4188800|sending_opeid==4188900| ///sending_opeid==4189000|sending_opeid==4189100|sending_opeid==4189200|sending_opeid==4189300| ///sending_opeid==4189400|sending_opeid==4189600|sending_opeid==4189700|sending_opeid==4189800| ///sending_opeid==4190000|sending_opeid==4190300|sending_opeid==4190500|sending_opeid==4190800| ///sending_opeid==4191100|sending_opeid==4191200|sending_opeid==4191300|sending_opeid==4191400| ///sending_opeid==4191900|sending_opeid==4192000|sending_opeid==4192100|sending_opeid==4192200| ///sending_opeid==4192400|sending_opeid==4192600|sending_opeid==4192700|sending_opeid==4192800| ///sending_opeid==4193000|sending_opeid==4193100|sending_opeid==4193200|sending_opeid==4193500| ///sending_opeid==4193700|sending_opeid==4193800|sending_opeid==4194300|sending_opeid==4194400| ///sending_opeid==4194500|sending_opeid==4194600|sending_opeid==4194900|sending_opeid==4195100| ///sending_opeid==4195200|sending_opeid==4195300|sending_opeid==4195400|sending_opeid==4195600| ///sending_opeid==4197500|sending_opeid==4197600|sending_opeid==4202600|sending_opeid==4202800| ///sending_opeid==4202900|sending_opeid==4203100|sending_opeid==4203200|sending_opeid==4203300| ///sending_opeid==4203400|sending_opeid==4203500|sending_opeid==4203800|sending_opeid==4204000)replace vsending_opeid=1 if firstime==5 & (sending_opeid==4204300| ///sending_opeid==4204500|sending_opeid==4204700| ///sending_opeid==4205200|sending_opeid==4205300|sending_opeid==4205500|sending_opeid==4205800| ///sending_opeid==4206100|sending_opeid==4206200|sending_opeid==4206300|sending_opeid==4206400| ///sending_opeid==4206500|sending_opeid==4206600|sending_opeid==4206800|sending_opeid==4207000| ///sending_opeid==4207200|sending_opeid==4207500|sending_opeid==4207600|sending_opeid==4207900| ///sending_opeid==4208000|sending_opeid==4208100|sending_opeid==4208400|sending_opeid==4208600| ///sending_opeid==4208700|sending_opeid==4208900|sending_opeid==4209300|sending_opeid==4209500| ///sending_opeid==4209600|sending_opeid==4209700|sending_opeid==4209800|sending_opeid==4210100| ///sending_opeid==4210200|sending_opeid==4210300|sending_opeid==4210600|sending_opeid==4210700| ///sending_opeid==4211000|sending_opeid==4211200|sending_opeid==4211500|sending_opeid==4211700| ///sending_opeid==4211800|sending_opeid==4211900|sending_opeid==4212000|sending_opeid==4212100| ///sending_opeid==4212500|sending_opeid==4213200|sending_opeid==4213300|sending_opeid==4213500| ///sending_opeid==4213800|sending_opeid==4214100|sending_opeid==4214500|sending_opeid==4215100| ///sending_opeid==4215300|sending_opeid==4215400|sending_opeid==4215900|sending_opeid==4216100| ///sending_opeid==4216300|sending_opeid==4216500|sending_opeid==4216800|sending_opeid==4217000| ///sending_opeid==4217500|sending_opeid==4217600|sending_opeid==4217800|sending_opeid==4218000| ///sending_opeid==4218200|sending_opeid==4218300|sending_opeid==4218400|sending_opeid==4218500| ///sending_opeid==4218900|sending_opeid==4219200|sending_opeid==4219700|sending_opeid==4220400| ///sending_opeid==4220600|sending_opeid==4220900|sending_opeid==4221200|sending_opeid==4221400| ///sending_opeid==4221800|sending_opeid==4222300|sending_opeid==4223100|sending_opeid==4223600| ///sending_opeid==4224100|sending_opeid==4224200|sending_opeid==4224500|sending_opeid==4224600| ///sending_opeid==4224900|sending_opeid==4226400|sending_opeid==4229500|sending_opeid==26009900| ///sending_opeid==26009901|sending_opeid==207000|sending_opeid==382500|sending_opeid==474100| ///sending_opeid==99998200)replace vsending_opeid=1 if firstime!=5 & sending_opeid==. /*non transfers do not have sending opeid*/replace vsending_opeid=4 if firstime!=5 & sending_opeid!=. /*non transfers have sending opeid and should not*/replace vsending_opeid=5 if firstime==5 & sending_opeid==. /*tranfers are missing sending opeid*/tab vsending_opeid, missingreplace vsending_opeid=6 if sending_opeid==fice /*test that sending opeid is different from opeid*/tab vsending_opeid, missingtab fice if vsending_opeid==6replace vsending_opeid=3 if firstime==5 & (sending_opeid==26001100| /// *non-collegiate sources*sending_opeid==26001200|sending_opeid==26001300|sending_opeid==26001900|sending_opeid==26002100| ///sending_opeid==26003100|sending_opeid==26005100|sending_opeid==26005200|sending_opeid==26005300| ///sending_opeid==26006100|sending_opeid==26007100|sending_opeid==26008100| ///sending_opeid==26008200|sending_opeid==26009100)tab vsending_opeid, missingmvencode vsending_opeid, mv(9) /*code for insitutions not in standard federal list of 7000+ institutions*/tab fice vsending_opeid if vsending_opeid!=1tab fice firstime if vsending_opeid!=1table fice vsending_opeid*this file includes logic checks across data elements**********************************************************************************reconcil tattend to credits*/*The classification level of student's term attendance by the institution as full-time or part-time based on total semester hour load.*//*full-time >=12 credits for ugrad & part-time <=11 credits for ugrad*//*cannot evaluate graduates, no federal credit policy*/ /*first separate population into ugrad and grad*/gen ugradgrad=.replace ugradgrad=1 if degree==10|degree==20|degree==30|degree==40 /*ugrad*/replace ugradgrad=2 if degree>=50 & degree!=. /*grad*/replace ugradgrad=3 if degree==47|degree==0 /*nondegree and dual*/tab ugradgradgen wtattend=.replace wtattend=1 if tattend==1 & tcrhra>=12 & ugradgrad==1/*good*/replace wtattend=2 if tattend==2 & tcrhra<12 & ugradgrad==1 /*good*/replace wtattend=3 if tattend==1 & tcrhra<12 & ugradgrad==1/*wrong*/replace wtattend=4 if tattend==2 & tcrhra>=12 & ugradgrad==1/*wrong*/replace wtattend=5 if ugradgrad==2|ugradgrad==3 /*out of scope*/tab wtattend, missingtab fice wtattend if wtattend==3|wtattend==4*********************************************************************************do all ugrad have correct tlevel and first-time status**only first time of 1, 2 and 5 should present with ugradgrad=1**only term level of 1, 2, 3, 4 and 7 should present with ugradgrad=1*table firstime tlevel if ugradgrad==1*do all grad have correct tlevel and first-time status**only first time of 3 and 4 should present with ugradgrad=2**only term level of 5, 6 and 8 should present with ugradgrad=1*table firstime tlevel if ugradgrad==2*reconcil if ugrad then term levels 1, 2, 3, 4, 7 or grad then term levels 5, 6, 8*gen vtlal=.replace vtlal=1 if ugradgrad==1 &(tlevel==1|tlevel==2|tlevel==3|tlevel==4|tlevel==7)/*ugrads are ugrads*/replace vtlal=2 if ugradgrad==2 &(tlevel==5|tlevel==6|tlevel==8)/*grads are grads*/replace vtlal=3 if ugradgrad==2 &(tlevel==1|tlevel==2|tlevel==3|tlevel==4|tlevel==7)/*grad with ugrad code*/replace vtlal=4 if ugradgrad==1 &(tlevel==5|tlevel==6|tlevel==8)/*ugrad with grad code8*/replace vtlal=5 if ugradgrad==3 /*high school*/label define vtlal 1 "ugrad-ugrad" 2 "grad-grad" 3 "grad-ugrad" 4 "ugrad-grad" 5 "outofscope"label values vtlal vtlaltab ugradgrad vtlaltab fice ugradgrad if vtlal==3tab fice ugradgrad if vtlal==4*****************************************************************************************************************************************************************************fall and spring only************************************************for spring and fall to find students with no fsfrez flag*tab fice if fsfrez==.*fall and spring only**determine if any first-time full-time undergraduate students are missing the fsfrez flag*tab fice if (fsfrez==.& tattend==1 & ugradgrad==1 & firstime==1)*determine number of students from Fall carried into Spring**determine number of students from Spring carried into Fall**look for low rates that may suggest IDN is not being carried from term to term*merge 1:1 fice idn using "M:\AnnKellogg\Data Validation Analysis_Ann Kellogg\Core Collections\EIS Data Files\Cross Semester Validations\Fall 18 toSpring 19\EIS Fall 18 for merge.dta"*determine if Fall firstime=1 & firstime=5 carry to Spring as firstime=2**determine if Spring firstime=1 & firstime=5 carry to Fall as firstime=2*append using "M:\AnnKellogg\Data Validation Analysis_Ann Kellogg\Core Collections\EIS Data Files\Cross Semester Validations\Fall 18 to Spring 19\EIS Fall 18 for merge.dta"tab firstime coltm*for fall carrying into spring*drop if firstime==4&coltm==1drop if firstime==3&coltm==1drop if firstime==3& coltm==3drop if firstime==4&coltm==3drop if firstime==0&coltm==1drop if firstime==0&coltm==3drop if firstime==2&coltm==1drop if firstime==1&coltm==3drop if firstime==5&coltm==3tab firstime coltmsort fice idn colyregen num_unique=tag(fice idn)drop if num_unique==1&coltm==3bysort fice idn: generate chft = firstime - firstime[_n-1]tab chft*all values of chft should be -3 or 1 -- *firstime=1 changes to 2= +1 *firstime=5 changes to 2 = -3*any other value than +1 or -3 is incorrect changer*egen change = sum(firstime), by(fice idn)tab change if num_unique==0*all num_unique=0 should be 3 (1+2) or 7 (5+2) any other value is incorrect changer******************************************************************************************************************************************************************this file reviews frequency distributions for comparison to prior year files*********************************************************************************table fice firstimetable firstime table sex table admfl table exempt table milstat table fsfrez table mathra table englratable readra table decrse table deloc table tlevel table tattend table tstatus table citizen table mdres*********************************************************************************record for multi race*gen rmulti=.replace rmulti=1 if (rwhite==1 & rblack==2 & rasian==3 & raian==4 & rnhpi==5 & hislat!=2)replace rmulti=1 if (rwhite==1 & rblack==2 & hislat!=2) replace rmulti=1 if (rwhite==1 & rasian==3 & hislat!=2) replace rmulti=1 if (rwhite==1 & raian==4 & hislat!=2) replace rmulti=1 if (rwhite==1 & rnhpi==5 & hislat!=2)replace rmulti=1 if (rblack==2 & rasian==3 & hislat!=2) replace rmulti=1 if (rblack==2 & raian==4 & hislat!=2) replace rmulti=1 if (rblack==2 & rnhpi==5 & hislat!=2)replace rmulti=1 if (rasian==3 & raian==4 & hislat!=2) replace rmulti=1 if (rasian==3 & rnhpi==5 & hislat!=2)replace rmulti=1 if (raian==4 & rnhpi==5 & hislat!=2)tab rmulti*recode for unknown race*gen runknown=.replace runknown=2 if rwhite==. & rblack==. & rasian==. & raian==. & rnhpi==. & hislat!=2tab runknown**distribution of population by race**tab rwhite if hislat!=2 & rmulti!=1tab rblack if hislat!=2 & rmulti!=1tab hispanic tab hislattab rasian if hislat!=2 & rmulti!=1tab raian if hislat!=2 & rmulti!=1tab rnhpi if hislat!=2 & rmulti!=1tab rmultitab runknown********************************************************************************tab degreetab degree if degree==47tab degree firstime if (firstime==1|firstime==2|firstime==5) & degree==47tab degree firstime if firstime==0 & degree==47********************************************************************************table georg if georg==001table georg if georg==100tabstat georg if georg>100 & georg <200, statistics( count )table georg if georg==200tabstat georg if georg>200 & georg <225, statistics( count )table georg if georg==000********************************************************************************tab fice if apzipcd==00000tab fice if apzipcd==99999tab fice if curzipcd==00000tab fice if curzipcd==99999*********************************************************************************test distribution of NON_SSN by FICE*table idttable fice if idt==2table fice idt if citizen==1table fice idt if mdres==1tab fice idt if idt!=1tab fice if idt==2 & citizen==1tab fice if idt==2 & mdres==1 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download