cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sks521
‎02-21-2020
  • 172 Posts
  • 23 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-03-2019 07:29 AM
‎09-03-2019 07:29 AM
And when I print date variables, It comes up with missing values for all observations. ... View more

Re: Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-03-2019 07:26 AM
‎09-03-2019 07:26 AM
Thanks I thought it's the maximum field length defined in source data set.   Now when I run this syntax;   *I HAVE REMOVED UNNECESSARY VARIABLES FROM THE SOURCE DATA SET; data Sheffield_apc; infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dsd truncover lrecl=32767 FIRSTOBS=2; length patient_id $32 procodet $3 sex $1 ethnos $2 admimeth $2 admidate 4 admiageprov $3 admiage 5 dismeth 3 disdate 4 epiorder 3 /* insert other variables here */ diag_01-diag_20 $6 cause $6 opertn_01-opertn_24 $4 sitetret 5 pgpprac 4 imd15decile_overall 3 ; informat admidate disdate yymmdd10. ; input patient_id procodet sex ethnos admimeth admidate admiageprov admiage dismeth disdate epiorder diag_01-diag_20 cause opertn_01-opertn_24 sitetret pgpprac imd15decile_overall ; run;     I am getting warning messages and don't know what is wrong or should I just ignore them?; The infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' is: Filename=I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV, RECFM=V,LRECL=32767,File Size (bytes)=46069736, Last Modified=03 September 2019 11:40:29, Create Time=23 August 2019 10:54:56 NOTE: Invalid data for admidate in line 2 45-54. NOTE: Invalid data for disdate in line 2 62-71. NOTE: Invalid data for sitetret in line 2 153-184. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 2 2904df91bd28acad65a8bef6e668c1a6,RR8,2,A,28,23/12/2015,3,3,1,24/12/2015,1,K766,Q442,I859 89 ,K317,,,,,,,,,,,,,,,,,,J114,Y532,X894,,,,,,,,,,,,,,,,,,,,,RR801,edc4d88faa58498dcacff954 177 8012e173, 185 patient_id=2904df91bd28acad65a8bef6e668c1a6 procodet=RR8 sex=2 ethnos=A admimeth=28 admidate=. admiageprov=3 admiage=3 dismeth=1 disdate=. epiorder=1 diag_01=K766 diag_02=Q442 diag_03=I859 diag_04=K317 diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=J114 opertn_02=Y532 opertn_03=X894 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RR80 sitetret=. pgpprac=. imd15decile_overall=. _ERROR_=1 _N_=1 NOTE: Invalid data for admidate in line 3 45-54. NOTE: Invalid data for disdate in line 3 62-71. NOTE: Invalid data for sitetret in line 3 141-172. 3 2904df91bd28acad65a8bef6e668c1a6,RR8,2,A,28,13/05/2016,3,3,1,14/05/2016,1,K766,Z538,Q442 89 ,I859,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RR801,edc4d88faa58498dcacff9548012e173, 173 patient_id=2904df91bd28acad65a8bef6e668c1a6 procodet=RR8 sex=2 ethnos=A admimeth=28 admidate=. admiageprov=3 admiage=3 dismeth=1 disdate=. epiorder=1 diag_01=K766 diag_02=Z538 diag_03=Q442 diag_04=I859 diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RR80 sitetret=. pgpprac=. imd15decile_overall=. _ERROR_=1 _N_=2 NOTE: Invalid data for admidate in line 4 45-54. NOTE: Invalid data for disdate in line 4 62-71. NOTE: Invalid data for sitetret in line 4 157-188. 4 2904df91bd28acad65a8bef6e668c1a6,RR8,2,A,28,15/06/2016,3,3,1,29/06/2016,1,Q442,K766,R061 89 ,I859,Z871,,,,,,,,,,,,,,,,,J011,X831,E851,,,,,,,,,,,,,,,,,,,,,RR801,edc4d88faa58498dcacf 177 f9548012e173, 189 patient_id=2904df91bd28acad65a8bef6e668c1a6 procodet=RR8 sex=2 ethnos=A admimeth=28 admidate=. admiageprov=3 admiage=3 dismeth=1 disdate=. epiorder=1 diag_01=Q442 diag_02=K766 diag_03=R061 diag_04=I859 diag_05=Z871 diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=J011 opertn_02=X831 opertn_03=E851 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RR80 sitetret=. pgpprac=. imd15decile_overall=. _ERROR_=1 _N_=3 NOTE: Invalid data for admidate in line 5 46-55. NOTE: Invalid data for disdate in line 5 63-72. NOTE: Invalid data for sitetret in line 5 151-182. 5 d17bc2bab2e2e1b9e41a14dda7873494,RAE,1,99,28,13/03/2017,7,7,1,13/03/2017,1,S6261,W239,,, 89 ,,,,,,,,,,,,,,,,W239,S662,Z503,Z942,,,,,,,,,,,,,,,,,,,,,RAE01,5cb4c77e12d85d2fcc3bd7773b 177 d8ce25,4 184 patient_id=d17bc2bab2e2e1b9e41a14dda7873494 procodet=RAE sex=1 ethnos=99 admimeth=28 admidate=. admiageprov=7 admiage=7 dismeth=1 disdate=. epiorder=1 diag_01=S6261 diag_02=W239 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=W239 opertn_01=S662 opertn_02=Z503 opertn_03=Z942 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RAE0 sitetret=. pgpprac=4 imd15decile_overall=. _ERROR_=1 _N_=4 NOTE: Invalid data for admidate in line 6 45-54. NOTE: Invalid data for disdate in line 6 62-71. NOTE: Invalid data for sitetret in line 6 133-164. 6 95194732efc2c8387c4687d2c31127a1,RWA,1,D,21,01/10/2014,3,3,1,01/10/2014,1,N390,Q531,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RWA01,6fd6f7e2a56ea053ca036b9b39863487,2 166 patient_id=95194732efc2c8387c4687d2c31127a1 procodet=RWA sex=1 ethnos=D admimeth=21 admidate=. admiageprov=3 admiage=3 dismeth=1 disdate=. epiorder=1 diag_01=N390 diag_02=Q531 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RWA0 sitetret=. pgpprac=2 imd15decile_overall=. _ERROR_=1 _N_=5 NOTE: Invalid data for admidate in line 7 46-55. NOTE: Invalid data for disdate in line 7 65-74. NOTE: Invalid data for sitetret in line 7 132-163. 7 8bbb5490dbe6fa882d75024183913053,RWA,1,99,22,17/06/2016,10,10,1,18/06/2016,1,R101,,,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RWA01,6fd6f7e2a56ea053ca036b9b39863487,6 165 patient_id=8bbb5490dbe6fa882d75024183913053 procodet=RWA sex=1 ethnos=99 admimeth=22 admidate=. admiageprov=10 admiage=10 dismeth=1 disdate=. epiorder=1 diag_01=R101 diag_02= diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RWA0 sitetret=. pgpprac=6 imd15decile_overall=. _ERROR_=1 _N_=6 NOTE: Invalid data for admidate in line 8 45-54. NOTE: Invalid data for disdate in line 8 62-71. NOTE: Invalid data for sitetret in line 8 133-164. 8 8341965fbbbeeb516fc17f34853d3703,RP5,1,A,21,29/08/2014,4,4,1,29/08/2014,1,R55X,J459,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RP5BA,34436a9501951924ab4f4f3a0c214422,2 166 patient_id=8341965fbbbeeb516fc17f34853d3703 procodet=RP5 sex=1 ethnos=A admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=R55X diag_02=J459 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RP5B sitetret=. pgpprac=2 imd15decile_overall=. _ERROR_=1 _N_=7 NOTE: Invalid data for admidate in line 9 45-54. NOTE: Invalid data for disdate in line 9 62-71. NOTE: Invalid data for sitetret in line 9 129-160. 9 30cad34a0f3461828c9bee670b5eb1eb,RCF,1,G,22,19/11/2015,5,5,1,19/11/2015,1,J22X,,,,,,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCF22,57fd2c84d84fe0f403b823e21fba4261,9 162 patient_id=30cad34a0f3461828c9bee670b5eb1eb procodet=RCF sex=1 ethnos=G admimeth=22 admidate=. admiageprov=5 admiage=5 dismeth=1 disdate=. epiorder=1 diag_01=J22X diag_02= diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RCF2 sitetret=. pgpprac=9 imd15decile_overall=. _ERROR_=1 _N_=8 NOTE: Invalid data for admidate in line 10 45-54. NOTE: Invalid data for disdate in line 10 62-71. NOTE: Invalid data for sitetret in line 10 137-168. 10 4ba8175c40d983211df2079897e29c1a,RXF,2,L,21,29/12/2016,6,6,1,29/12/2016,1,K590,J459,L309 RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RXF05,24ffcb31ce5b6c97a5be035a4e8106f6,2 170 patient_id=4ba8175c40d983211df2079897e29c1a procodet=RXF sex=2 ethnos=L admimeth=21 admidate=. admiageprov=6 admiage=6 dismeth=1 disdate=. epiorder=1 diag_01=K590 diag_02=J459 diag_03=L309 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RXF0 sitetret=. pgpprac=2 imd15decile_overall=. _ERROR_=1 _N_=9 NOTE: Invalid data for admidate in line 11 45-54. NOTE: Invalid data for disdate in line 11 62-71. NOTE: Invalid data for sitetret in line 11 150-181. 11 3f37e45ddaebb5da393d5356041d0378,RCB,2,Z,24,21/07/2012,6,6,1,21/07/2012,1,S0250,W222,,,, 89 ,,,,,,,,,,,,,,,W222,V151,F635,Z941,,,,,,,,,,,,,,,,,,,,,RCB55,afc31d2449ccd9ff6bc13aa6b31 177 ef5bb,9 183 patient_id=3f37e45ddaebb5da393d5356041d0378 procodet=RCB sex=2 ethnos=Z admimeth=24 admidate=. admiageprov=6 admiage=6 dismeth=1 disdate=. epiorder=1 diag_01=S0250 diag_02=W222 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=W222 opertn_01=V151 opertn_02=F635 opertn_03=Z941 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RCB5 sitetret=. pgpprac=9 imd15decile_overall=. _ERROR_=1 _N_=10 NOTE: Invalid data for admidate in line 12 45-54. NOTE: Invalid data for disdate in line 12 62-71. NOTE: Invalid data for sitetret in line 12 153-184. 12 05c9e6967a3d04cdcb1ff95b27287028,RCU,2,F,22,10/09/2012,7,7,1,10/09/2012,1,R55X,G809,Q250 89 ,J984,K219,F840,Z931,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCUEF,4091a1cfa465e632e9ae31f3 177 de84e588,1 186 patient_id=05c9e6967a3d04cdcb1ff95b27287028 procodet=RCU sex=2 ethnos=F admimeth=22 admidate=. admiageprov=7 admiage=7 dismeth=1 disdate=. epiorder=1 diag_01=R55X diag_02=G809 diag_03=Q250 diag_04=J984 diag_05=K219 diag_06=F840 diag_07=Z931 diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RCUE sitetret=. pgpprac=1 imd15decile_overall=. _ERROR_=1 _N_=11 NOTE: Invalid data for admidate in line 13 45-54. NOTE: Invalid data for disdate in line 13 62-71. NOTE: Invalid data for sitetret in line 13 153-184. 13 05c9e6967a3d04cdcb1ff95b27287028,RCU,2,F,22,25/12/2012,7,7,1,25/12/2012,1,J069,G809,Q250 89 ,J984,K219,F840,Z931,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCUEF,4091a1cfa465e632e9ae31f3 177 de84e588,1 186 patient_id=05c9e6967a3d04cdcb1ff95b27287028 procodet=RCU sex=2 ethnos=F admimeth=22 admidate=. admiageprov=7 admiage=7 dismeth=1 disdate=. epiorder=1 diag_01=J069 diag_02=G809 diag_03=Q250 diag_04=J984 diag_05=K219 diag_06=F840 diag_07=Z931 diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RCUE sitetret=. pgpprac=1 imd15decile_overall=. _ERROR_=1 _N_=12 NOTE: Invalid data for admidate in line 14 45-54. NOTE: Invalid data for disdate in line 14 62-71. NOTE: Invalid data for sitetret in line 14 129-160. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 14 0fbb33e68de0cec26b177b44f0057684,RXF,2,A,21,17/08/2012,4,4,1,17/08/2012,1,A084,,,,,,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RXF05,d8febc1b8d18e84e87b5a5d515492b50,1 162 patient_id=0fbb33e68de0cec26b177b44f0057684 procodet=RXF sex=2 ethnos=A admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=A084 diag_02= diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RXF0 sitetret=. pgpprac=1 imd15decile_overall=. _ERROR_=1 _N_=13 NOTE: Invalid data for admidate in line 15 44-53. NOTE: Invalid data for disdate in line 15 61-70. NOTE: Invalid data for sitetret in line 15 132-163. 15 660f8646475c88b2d058c3e7aedef9c3,RFF,1,,21,26/12/2015,4,4,1,26/12/2015,1,L509,J22X,,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RFFAA,989c2c0533f7b1ee7ca4e029d394a27b,2 165 patient_id=660f8646475c88b2d058c3e7aedef9c3 procodet=RFF sex=1 ethnos= admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=L509 diag_02=J22X diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RFFA sitetret=. pgpprac=2 imd15decile_overall=. _ERROR_=1 _N_=14 NOTE: Invalid data for admidate in line 16 45-54. NOTE: Invalid data for disdate in line 16 62-71. NOTE: Invalid data for sitetret in line 16 154-185. 16 a42f2b8d44fe8c7e410f14633ab786aa,RP5,2,A,21,08/04/2016,4,4,1,09/04/2016,1,S8210,W090,J45 89 9,,,,,,,,,,,,,,,,,,W090,X481,Z909,Z943,,,,,,,,,,,,,,,,,,,,,RP5BA,77df50b937f111f32f7c3bd 177 249f9e4e5,9 187 patient_id=a42f2b8d44fe8c7e410f14633ab786aa procodet=RP5 sex=2 ethnos=A admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=S8210 diag_02=W090 diag_03=J459 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=W090 opertn_01=X481 opertn_02=Z909 opertn_03=Z943 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RP5B sitetret=. pgpprac=9 imd15decile_overall=. _ERROR_=1 _N_=15 NOTE: Invalid data for admidate in line 17 45-54. NOTE: Invalid data for disdate in line 17 62-71. NOTE: Invalid data for sitetret in line 17 129-160. 17 a42f2b8d44fe8c7e410f14633ab786aa,RP5,2,A,21,18/06/2016,4,4,1,21/06/2016,1,J459,,,,,,,,,, 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RP5BA,77df50b937f111f32f7c3bd249f9e4e5,9 162 patient_id=a42f2b8d44fe8c7e410f14633ab786aa procodet=RP5 sex=2 ethnos=A admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=J459 diag_02= diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RP5B sitetret=. pgpprac=9 imd15decile_overall=. _ERROR_=1 _N_=16 NOTE: Invalid data for admidate in line 18 45-54. NOTE: Invalid data for disdate in line 18 62-71. NOTE: Invalid data for sitetret in line 18 129-160. 18 811e4ce1e956a9defa61b51ffa56f566,RCD,1,A,22,21/06/2013,6,6,1,22/06/2013,1,R104,,,,,,,,,, RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 89 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCD01,07c123a28f5a5dfb633db7007b1446ee,9 162 patient_id=811e4ce1e956a9defa61b51ffa56f566 procodet=RCD sex=1 ethnos=A admimeth=22 admidate=. admiageprov=6 admiage=6 dismeth=1 disdate=. epiorder=1 diag_01=R104 diag_02= diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RCD0 sitetret=. pgpprac=9 imd15decile_overall=. _ERROR_=1 _N_=17 NOTE: Invalid data for admidate in line 19 45-54. NOTE: Invalid data for disdate in line 19 62-71. NOTE: Invalid data for sitetret in line 19 137-168. 19 2966f67ce4f64ca7808922065edba764,RXF,2,A,21,30/07/2016,3,3,1,30/07/2016,1,T383,X440,,,,, 89 ,,,,,,,,,,,,,,X440,,,,,,,,,,,,,,,,,,,,,,,,RXF05,cd648d490164851580360e67462d558c,10 171 patient_id=2966f67ce4f64ca7808922065edba764 procodet=RXF sex=2 ethnos=A admimeth=21 admidate=. admiageprov=3 admiage=3 dismeth=1 disdate=. epiorder=1 diag_01=T383 diag_02=X440 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=X440 opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RXF0 sitetret=. pgpprac=10 imd15decile_overall=. _ERROR_=1 _N_=18 NOTE: Invalid data for admidate in line 20 45-54. NOTE: Invalid data for disdate in line 20 62-71. NOTE: Invalid data for sitetret in line 20 145-176. 20 e1337bc789045e92211b693cf757b414,RXF,2,A,21,19/09/2012,4,4,1,20/09/2012,1,S099,W192,,,,, 89 ,,,,,,,,,,,,,,W192,U051,Y981,,,,,,,,,,,,,,,,,,,,,,RXF05,5ad6c94ac5530ba978469dab798a2cbd 177 ,8 178 patient_id=e1337bc789045e92211b693cf757b414 procodet=RXF sex=2 ethnos=A admimeth=21 admidate=. admiageprov=4 admiage=4 dismeth=1 disdate=. epiorder=1 diag_01=S099 diag_02=W192 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=W192 opertn_01=U051 opertn_02=Y981 opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RXF0 sitetret=. pgpprac=8 imd15decile_overall=. _ERROR_=1 _N_=19 NOTE: Invalid data for admidate in line 21 45-54. NOTE: Invalid data for disdate in line 21 62-71. NOTE: Invalid data for sitetret in line 21 154-185. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 31fe068e5f05305aa57e7f0bc139e26b,RR8,1,A,21,09/12/2016,2,2,1,13/12/2016,1,S7230,W080,,,, 89 ,,,,,,,,,,,,,,,W080,W264,Z764,Z943,Y535,,,,,,,,,,,,,,,,,,,,RR801,c21b51719ff488a88bf91c8 177 700b1501a,1 187 patient_id=31fe068e5f05305aa57e7f0bc139e26b procodet=RR8 sex=1 ethnos=A admimeth=21 admidate=. admiageprov=2 admiage=2 dismeth=1 disdate=. epiorder=1 diag_01=S7230 diag_02=W080 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause=W080 opertn_01=W264 opertn_02=Z764 opertn_03=Z943 opertn_04=Y535 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_10= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24=RR80 sitetret=. pgpprac=1 imd15decile_overall=. _ERROR_=1 _N_=20 NOTE: 263868 records were read from the infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV'. The minimum record length was 129. The maximum record length was 345. NOTE: The data set WORK.SHEFFIELD_APC has 263868 observations and 59 variables. NOTE: DATA statement used (Total process time): real time 2.89 seconds cpu time 1.25 seconds ... View more

Re: importing some variables from a data set using infile statement

by Quartz | Level 8 in SAS Programming
‎09-03-2019 07:11 AM
‎09-03-2019 07:11 AM
Thanks but I don't understand what, 1 and 3 mean in the below syntax; Name = scan(_infile_, 1, ","); Age = input(scan(_infile_, 3, ","), best.);  and how would it change if we have more thank 2 variables to read in?   Thanks S ... View more

Re: importing some variables from a data set using infile statement

by Quartz | Level 8 in SAS Programming
‎09-03-2019 06:58 AM
‎09-03-2019 06:58 AM
Thanks, I tried using 'KEEP' but I assume SAS reads all data before importing in so it is giving me errors when it reads 'dirty variables' which I was trying to avoid so the whole procedure fails. ... View more

Re: Capturing data

by Quartz | Level 8 in SAS Programming
‎09-03-2019 06:54 AM
‎09-03-2019 06:54 AM
Thanks but can I check in if this step will get rid of all observations with any diagnoses other than the ones specified (asthma and gastroenteritis) here please?   Thanks S ... View more

Re: Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-03-2019 06:46 AM
‎09-03-2019 06:46 AM
Thanks for the comprehensive reply. Can I ask why you've defined length for date variable as 4;   opdate_01<span class="token operator">-</span>opdate_24 <span class="token number">4</span>   I am asking because when I run the following code it gives me errors i 20 data Sheffield_apc; 21 infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dsd truncover 21 ! lrecl=32767 FIRSTOBS=2; 22 length patient_id $32 procodet $3 sex $1 ethnos $2 admimeth $2 admidate 10 admiageprov 22 ! $3 22 length patient_id $32 procodet $3 sex $1 ethnos $2 admimeth $2 admidate 10 admiageprov -- 352 22 ! $3 ERROR 352-185: The length of numeric variables is 3-8. 23 admiage 5 dismeth 1 disdate 10 epiorder 3 - -- 352 352 ERROR 352-185: The length of numeric variables is 3-8. 24 /* insert other variables here */ 25 diag_01-diag_20 $6 cause $6 opertn_01-opertn_24 $4 sitetret 5 pgpprac 32 25 ! imd15decile_overall 2 25 diag_01-diag_20 $6 cause $6 opertn_01-opertn_24 $4 sitetret 5 pgpprac 32 -- 352 25 ! imd15decile_overall 2 ERROR 352-185: The length of numeric variables is 3-8. 25 diag_01-diag_20 $6 cause $6 opertn_01-opertn_24 $4 sitetret 5 pgpprac 32 25 ! imd15decile_overall 2 - 352 ERROR 352-185: The length of numeric variables is 3-8. 26 ; 27 informat 28 admidate 29 disdate 30 yymmdd10. 31 ; 32 input 33 patient_id procodet sex ethnos admimeth admidate admiageprov admiage 33 ! dismeth 34 disdate epiorder diag_01-diag_20 cause opertn_01-opertn_24 sitetret pgpprac 34 ! imd15decile_overall 35 ; 36 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SHEFFIELD_APC may be incomplete. When this step was stopped there were 0 observations and 59 variables. WARNING: Data set WORK.SHEFFIELD_APC was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds n multiple places;   data Sheffield_apc; infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dsd truncover lrecl=32767 FIRSTOBS=2; length patient_id $32 procodet $3 sex $1 ethnos $2 admimeth $2 admidate 10 admiageprov $3 admiage 5 dismeth 1 disdate 10 epiorder 3 /* insert other variables here */ diag_01-diag_20 $6 cause $6 opertn_01-opertn_24 $4 sitetret 5 pgpprac 32 imd15decile_overall 2 ; informat admidate disdate yymmdd10. ; input patient_id procodet sex ethnos admimeth admidate admiageprov admiage dismeth disdate epiorder diag_01-diag_20 cause opertn_01-opertn_24 sitetret pgpprac imd15decile_overall ; run; ... View more

Re: importing some variables from a data set using infile statement

by Quartz | Level 8 in SAS Programming
‎09-03-2019 05:55 AM
‎09-03-2019 05:55 AM
The data is in CSV format and I want to bring in a selected set of variables into SAS using infile statement. How do I do that please? ... View more

Re: importing some variables from a data set using infile statement

by Quartz | Level 8 in SAS Programming
‎09-03-2019 05:54 AM
‎09-03-2019 05:54 AM
Hi, How do I find that out? It's a CSV file which I need to import the data from but I don't want to import all variables into SAS, but only a selection of these variables. ... View more

Re: Capturing data

by Quartz | Level 8 in SAS Programming
‎09-03-2019 04:56 AM
‎09-03-2019 04:56 AM
I have run this array but getting an error message as follows; (these are all character variables listed as treat_01 to treat_12) 285 data CONTROL1 (drop = _:) ; 286 set VISITS ; 287 array dd TREAT: ; ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. 288 do over dd ; 289 if prxmatch ("m/J21|J0|J38|J37/oi", dd) then do ; 290 * if find (dd, "J21") or find (dd, "J0") or find (dd, "J38") or find (dd, "J37") then do ; 291 _exclude = 1 ; 292 leave ; 293 end ; 294 end ; 295 if not _exclude ; 296 run ; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 289:41 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.CONTROL1 may be incomplete. When this step was stopped there were 0 observations and 30 variables. WARNING: Data set WORK.CONTROL1 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds ... View more

Re: Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-02-2019 10:31 AM
‎09-02-2019 10:31 AM
When I look into source data to find out invalid data for date variables, I can't find anything wrong and the all observations have valid date format. ... View more

importing some variables from a data set using infile statement

by Quartz | Level 8 in SAS Programming
‎09-02-2019 10:21 AM
‎09-02-2019 10:21 AM
Hi,   How can I bring a few variables into SAS using infile statement please?   Thanks S ... View more

Re: Character Date with Missing Values to SAS Date

by Quartz | Level 8 in SAS Programming
‎09-02-2019 10:11 AM
‎09-02-2019 10:11 AM
Can I ask how you would write the syntax if there are multiple date variables please?   Thanks S ... View more

Re: Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-02-2019 07:37 AM
‎09-02-2019 07:37 AM
I think that could be an easy fix if I define it as character but I am going to struggle with date variables mostly because the data dictionary I have received from the data person says it's coded as    either for example a valid date in ddmmyy10. format or can be 'null' or for invalid date, it can have 1801-01-01 value.   I don't want to code it as character variables because I am going to use it to derive another variable in future.   Thanks S ... View more

Bringing data into SAS

by Quartz | Level 8 in SAS Programming
‎09-02-2019 07:28 AM
‎09-02-2019 07:28 AM
Hi folks,   I am using following infile statement to bring in csv into SAS;   data Sheffield_apc; infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dsd truncover lrecl=32767 FIRSTOBS=2; INPUT patient_id $ link_method $ procodet $ postcode_flag $ sex ethnos $ classpat admimeth$ admidate DDMMYY10. admiageprov admiage dismeth disdate DDMMYY10. epiorder spelend diag_01 $ diag_02 $ diag_03 $ diag_04 $ diag_05 $ diag_06 $ diag_07 $ diag_08 $ diag_09 $ diag_10 $ diag_11 $ diag_12 $ diag_13 $ diag_14 $ diag_15 $ diag_16 $ diag_17 $ diag_18 $ diag_19 $ diag_20 $ cause $ opertn_01 $ opertn_02 $ opertn_03 $ opertn_04 $ opertn_05 $ opertn_06 $ opertn_07 $ opertn_08 $ opertn_09 $ opertn_11 $ opertn_12 $ opertn_13 $ opertn_14 $ opertn_15 $ opertn_16 $ opertn_17 $ opertn_18 $ opertn_19 $ opertn_20 $ opertn_21 $ opertn_22 $ opertn_23 $ opertn_24 $ opdate_01 ddmmyy10. opdate_02 ddmmyy10. opdate_03 ddmmyy10. opdate_04 ddmmyy10. opdate_05 ddmmyy10. opdate_06 ddmmyy10. opdate_07 ddmmyy10. opdate_08 ddmmyy10. opdate_09 ddmmyy10. opdate_10 ddmmyy10. opdate_11 ddmmyy10. opdate_12 ddmmyy10. opdate_13 ddmmyy10. opdate_14 ddmmyy10. opdate_14 ddmmyy10. opdate_15 ddmmyy10. opdate_16 ddmmyy10. opdate_17 ddmmyy10. opdate_18 ddmmyy10. opdate_19 ddmmyy10. opdate_20 ddmmyy10. opdate_21 ddmmyy10. opdate_22 ddmmyy10. opdate_23 ddmmyy10. opdate_24 ddmmyy10. sitetret $ pgpprac $ imd15decile_overall; RUN;   but it is giving me errors (see in the window) at multiple lines especially with date variables.   Can someone enlighten me as to what's happening with it and how can I correct it please?   thanks S data Sheffield_apc; 293 infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dsd truncover 293! lrecl=32767 FIRSTOBS=2; 294 INPUT patient_id $ link_method $ procodet $ postcode_flag $ sex ethnos $ classpat 294! admimeth$ admidate DDMMYY10. admiageprov admiage dismeth disdate DDMMYY10. 295 epiorder spelend diag_01 $ diag_02 $ diag_03 $ diag_04 $ diag_05 $ diag_06 $ diag_07 $ 295! diag_08 $ diag_09 $ diag_10 $ diag_11 $ diag_12 $ diag_13 $ 296 diag_14 $ diag_15 $ diag_16 $ diag_17 $ diag_18 $ diag_19 $ diag_20 $ cause $ 296! opertn_01 $ opertn_02 $ opertn_03 $ opertn_04 $ opertn_05 $ opertn_06 $ 297 opertn_07 $ opertn_08 $ opertn_09 $ opertn_11 $ opertn_12 $ opertn_13 $ 297! opertn_14 $ opertn_15 $ opertn_16 $ opertn_17 $ opertn_18 $ opertn_19 $ 298 opertn_20 $ opertn_21 $ opertn_22 $ opertn_23 $ opertn_24 $ opdate_01 ddmmyy10. 298! opdate_02 ddmmyy10. opdate_03 ddmmyy10. opdate_04 ddmmyy10. opdate_05 ddmmyy10. 299 opdate_06 ddmmyy10. opdate_07 ddmmyy10. opdate_08 ddmmyy10. opdate_09 ddmmyy10. opdate_10 299! ddmmyy10. opdate_11 ddmmyy10. opdate_12 ddmmyy10. opdate_13 ddmmyy10. 300 opdate_14 ddmmyy10. opdate_14 ddmmyy10. opdate_15 ddmmyy10. opdate_16 ddmmyy10. opdate_17 300! ddmmyy10. opdate_18 ddmmyy10. opdate_19 ddmmyy10. opdate_20 ddmmyy10. 301 opdate_21 ddmmyy10. opdate_22 ddmmyy10. opdate_23 ddmmyy10. opdate_24 ddmmyy10. sitetret 301! $ pgpprac $ imd15decile_overall; 302 RUN; NOTE: The infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' is: Filename=I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV, RECFM=V,LRECL=32767,File Size (bytes)=67776070, Last Modified=23 August 2019 10:55:26, Create Time=23 August 2019 10:54:56 NOTE: Invalid data for sex in line 2 77-81. NOTE: Invalid data for classpat in line 2 85-85. NOTE: Invalid data for admidate in line 2 89-98. NOTE: Invalid data for disdate in line 2 109-118. NOTE: Invalid data for opdate_01 in line 2 198-207. NOTE: Invalid data for opdate_02 in line 2 208-217. NOTE: Invalid data for opdate_03 in line 2 218-227. NOTE: Invalid data for opdate_04 in line 2 228-237. NOTE: Invalid data for opdate_05 in line 2 238-247. NOTE: Invalid data for opdate_06 in line 2 248-257. NOTE: Invalid data for opdate_07 in line 2 258-267. NOTE: Invalid data for opdate_08 in line 2 268-277. NOTE: Invalid data for opdate_09 in line 2 278-287. NOTE: Invalid data for opdate_10 in line 2 288-290. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 2 3b57324a525d1c572008049cb140e13f,2904df91bd28acad65a8bef6e668c1a6,NHSNO,RR8,VALID,2,A,1, 89 28,2015-12-23,003,3,1,2015-12-24,01,1,K766,Q442,I859,K317,,,,,,,,,,,,,,,,,,J114,Y532,X89 177 4,,,,,,,,,,,,,,,,,,,,,2015-12-23,2015-12-23,2015-12-23,,,,,,,,,,,,,,,,,,,,,RR801,edc4d88 265 faa58498dcacff9548012e173, 290 patient_id=3b57324a link_method=2904df91 procodet=NHSNO postcode_flag=RR8 sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-23 admiage=3 dismeth=3 disdate=. epiorder=24 spelend=1 diag_01=1 diag_02=K766 diag_03=Q442 diag_04=I859 diag_05=K317 diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02=J114 opertn_03=Y532 opertn_04=X894 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=1 NOTE: Invalid data for sex in line 3 77-81. NOTE: Invalid data for classpat in line 3 85-85. NOTE: Invalid data for admidate in line 3 89-98. NOTE: Invalid data for disdate in line 3 109-118. NOTE: Invalid data for opdate_01 in line 3 186-195. NOTE: Invalid data for opdate_02 in line 3 196-205. NOTE: Invalid data for opdate_03 in line 3 206-215. NOTE: Invalid data for opdate_04 in line 3 216-225. NOTE: Invalid data for opdate_05 in line 3 226-235. NOTE: Invalid data for opdate_06 in line 3 236-245. NOTE: Invalid data for opdate_07 in line 3 246-248. 3 c739958265deb1ba8b328cb041e87dda,2904df91bd28acad65a8bef6e668c1a6,NHSNO,RR8,VALID,2,A,1, 89 28,2016-05-13,003,3,1,2016-05-14,01,1,K766,Z538,Q442,I859,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RR801,edc4d88faa58498dcacff9548012e173, 248 patient_id=c7399582 link_method=2904df91 procodet=NHSNO postcode_flag=RR8 sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-13 admiage=3 dismeth=3 disdate=. epiorder=14 spelend=1 diag_01=1 diag_02=K766 diag_03=Z538 diag_04=Q442 diag_05=I859 diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=2 NOTE: Invalid data for sex in line 4 77-81. NOTE: Invalid data for classpat in line 4 85-85. NOTE: Invalid data for admidate in line 4 89-98. NOTE: Invalid data for disdate in line 4 109-118. NOTE: Invalid data for opdate_01 in line 4 202-211. NOTE: Invalid data for opdate_02 in line 4 212-221. NOTE: Invalid data for opdate_03 in line 4 222-231. NOTE: Invalid data for opdate_04 in line 4 232-241. NOTE: Invalid data for opdate_05 in line 4 242-251. NOTE: Invalid data for opdate_06 in line 4 252-261. NOTE: Invalid data for opdate_07 in line 4 262-271. NOTE: Invalid data for opdate_08 in line 4 272-281. NOTE: Invalid data for opdate_09 in line 4 282-291. NOTE: Invalid data for opdate_10 in line 4 292-294. 4 27eb9b58467c1004b6dcd676e5026f0c,2904df91bd28acad65a8bef6e668c1a6,NHSNO,RR8,VALID,2,A,1, 89 28,2016-06-15,003,3,1,2016-06-29,01,1,Q442,K766,R061,I859,Z871,,,,,,,,,,,,,,,,,J011,X831 177 ,E851,,,,,,,,,,,,,,,,,,,,,2016-06-15,2016-06-15,2016-06-15,,,,,,,,,,,,,,,,,,,,,RR801,edc 265 4d88faa58498dcacff9548012e173, 294 patient_id=27eb9b58 link_method=2904df91 procodet=NHSNO postcode_flag=RR8 sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-15 admiage=3 dismeth=3 disdate=. epiorder=29 spelend=1 diag_01=1 diag_02=Q442 diag_03=K766 diag_04=R061 diag_05=I859 diag_06=Z871 diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02=J011 opertn_03=X831 opertn_04=E851 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=3 NOTE: Invalid data for sex in line 5 77-81. NOTE: Invalid data for admidate in line 5 90-99. NOTE: Invalid data for disdate in line 5 110-119. NOTE: Invalid data for opdate_01 in line 5 196-205. NOTE: Invalid data for opdate_02 in line 5 206-215. NOTE: Invalid data for opdate_03 in line 5 216-225. NOTE: Invalid data for opdate_04 in line 5 226-235. NOTE: Invalid data for opdate_05 in line 5 236-245. NOTE: Invalid data for opdate_06 in line 5 246-255. NOTE: Invalid data for opdate_07 in line 5 256-265. NOTE: Invalid data for opdate_08 in line 5 266-275. NOTE: Invalid data for opdate_09 in line 5 276-285. NOTE: Invalid data for opdate_10 in line 5 286-289. 5 95b82700b7943d175d88f068f33e6ce6,d17bc2bab2e2e1b9e41a14dda7873494,NHSNO,RAE,VALID,1,99,1 89 ,28,2017-03-13,007,7,1,2017-03-13,01,1,S6261,W239,,,,,,,,,,,,,,,,,,,W239,S662,Z503,Z942, 177 ,,,,,,,,,,,,,,,,,,,,2017-03-15,2017-03-15,2017-03-15,,,,,,,,,,,,,,,,,,,,,RAE01,5cb4c77e1 265 2d85d2fcc3bd7773bd8ce25,4 289 patient_id=95b82700 link_method=d17bc2ba procodet=NHSNO postcode_flag=RAE sex=. ethnos=1 classpat=99 admimeth=1 admidate=. admiageprov=-13 admiage=7 dismeth=7 disdate=. epiorder=13 spelend=1 diag_01=1 diag_02=S6261 diag_03=W239 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=W239 opertn_02=S662 opertn_03=Z503 opertn_04=Z942 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=4 NOTE: Invalid data for sex in line 6 77-81. NOTE: Invalid data for classpat in line 6 85-85. NOTE: Invalid data for admidate in line 6 89-98. NOTE: Invalid data for disdate in line 6 109-118. NOTE: Invalid data for opdate_01 in line 6 178-187. NOTE: Invalid data for opdate_02 in line 6 188-197. NOTE: Invalid data for opdate_03 in line 6 198-207. NOTE: Invalid data for opdate_04 in line 6 208-217. NOTE: Invalid data for opdate_05 in line 6 218-227. NOTE: Invalid data for opdate_06 in line 6 228-237. NOTE: Invalid data for opdate_07 in line 6 238-241. 6 7c0e1df243577d34ee8f7a7fcaf9a2e4,95194732efc2c8387c4687d2c31127a1,NHSNO,RWA,VALID,1,D,1, 89 21,2014-10-01,003,3,1,2014-10-01,01,1,N390,Q531,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,RWA01,6fd6f7e2a56ea053ca036b9b39863487,2 241 patient_id=7c0e1df2 link_method=95194732 procodet=NHSNO postcode_flag=RWA sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-1 admiage=3 dismeth=3 disdate=. epiorder=1 spelend=1 diag_01=1 diag_02=N390 diag_03=Q531 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=5 NOTE: Invalid data for sex in line 7 77-81. NOTE: Invalid data for admidate in line 7 90-99. NOTE: Invalid data for disdate in line 7 111-120. NOTE: Invalid data for opdate_01 in line 7 176-185. NOTE: Invalid data for opdate_02 in line 7 186-195. NOTE: Invalid data for opdate_03 in line 7 196-205. NOTE: Invalid data for opdate_04 in line 7 206-215. NOTE: Invalid data for opdate_05 in line 7 216-225. NOTE: Invalid data for opdate_06 in line 7 226-235. NOTE: Invalid data for opdate_07 in line 7 236-239. 7 c1ae9b4ee4121f3e1cdc46f00a2f3ad7,8bbb5490dbe6fa882d75024183913053,NHSNO,RWA,VALID,1,99,1 89 ,22,2016-06-17,010,10,1,2016-06-18,01,1,R101,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,RWA01,6fd6f7e2a56ea053ca036b9b39863487,6 239 patient_id=c1ae9b4e link_method=8bbb5490 procodet=NHSNO postcode_flag=RWA sex=. ethnos=1 classpat=99 admimeth=1 admidate=. admiageprov=-17 admiage=10 dismeth=10 disdate=. epiorder=18 spelend=1 diag_01=1 diag_02=R101 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=6 NOTE: Invalid data for sex in line 8 77-81. NOTE: Invalid data for classpat in line 8 85-85. NOTE: Invalid data for admidate in line 8 89-98. NOTE: Invalid data for disdate in line 8 109-118. NOTE: Invalid data for opdate_01 in line 8 178-187. NOTE: Invalid data for opdate_02 in line 8 188-197. NOTE: Invalid data for opdate_03 in line 8 198-207. NOTE: Invalid data for opdate_04 in line 8 208-217. NOTE: Invalid data for opdate_05 in line 8 218-227. NOTE: Invalid data for opdate_06 in line 8 228-237. NOTE: Invalid data for opdate_07 in line 8 238-241. 8 c349dd69cf53654679c8ec0dc730a6aa,8341965fbbbeeb516fc17f34853d3703,NHSNO,RP5,VALID,1,A,1, 89 21,2014-08-29,004,4,1,2014-08-29,01,1,R55X,J459,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,RP5BA,34436a9501951924ab4f4f3a0c214422,2 241 patient_id=c349dd69 link_method=8341965f procodet=NHSNO postcode_flag=RP5 sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-29 admiage=4 dismeth=4 disdate=. epiorder=29 spelend=1 diag_01=1 diag_02=R55X diag_03=J459 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=7 NOTE: Invalid data for sex in line 9 77-81. NOTE: Invalid data for classpat in line 9 85-85. NOTE: Invalid data for admidate in line 9 89-98. NOTE: Invalid data for disdate in line 9 109-118. NOTE: Invalid data for opdate_01 in line 9 174-183. NOTE: Invalid data for opdate_02 in line 9 184-193. NOTE: Invalid data for opdate_03 in line 9 194-203. NOTE: Invalid data for opdate_04 in line 9 204-213. NOTE: Invalid data for opdate_05 in line 9 214-223. NOTE: Invalid data for opdate_06 in line 9 224-233. NOTE: Invalid data for opdate_07 in line 9 234-237. 9 fda2c4d3c626b7e546da235e5cc8f430,30cad34a0f3461828c9bee670b5eb1eb,NHSNO,RCF,VALID,1,G,1, 89 22,2015-11-19,005,5,1,2015-11-19,01,1,J22X,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,RCF22,57fd2c84d84fe0f403b823e21fba4261,9 237 patient_id=fda2c4d3 link_method=30cad34a procodet=NHSNO postcode_flag=RCF sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-19 admiage=5 dismeth=5 disdate=. epiorder=19 spelend=1 diag_01=1 diag_02=J22X diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=8 NOTE: Invalid data for sex in line 10 77-81. NOTE: Invalid data for classpat in line 10 85-85. NOTE: Invalid data for admidate in line 10 89-98. NOTE: Invalid data for disdate in line 10 109-118. NOTE: Invalid data for opdate_01 in line 10 182-191. NOTE: Invalid data for opdate_02 in line 10 192-201. NOTE: Invalid data for opdate_03 in line 10 202-211. NOTE: Invalid data for opdate_04 in line 10 212-221. NOTE: Invalid data for opdate_05 in line 10 222-231. NOTE: Invalid data for opdate_06 in line 10 232-241. NOTE: Invalid data for opdate_07 in line 10 242-245. 10 b8dafa915d0a4afa34133396b4da13ca,4ba8175c40d983211df2079897e29c1a,NHSNO,RXF,VALID,2,L,1, 89 21,2016-12-29,006,6,1,2016-12-29,01,1,K590,J459,L309,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RXF05,24ffcb31ce5b6c97a5be035a4e8106f6,2 245 patient_id=b8dafa91 link_method=4ba8175c procodet=NHSNO postcode_flag=RXF sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-29 admiage=6 dismeth=6 disdate=. epiorder=29 spelend=1 diag_01=1 diag_02=K590 diag_03=J459 diag_04=L309 diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=9 NOTE: Invalid data for sex in line 11 77-81. NOTE: Invalid data for classpat in line 11 85-85. NOTE: Invalid data for admidate in line 11 88-97. NOTE: Invalid data for disdate in line 11 108-117. NOTE: Invalid data for opdate_01 in line 11 194-203. NOTE: Invalid data for opdate_02 in line 11 204-213. NOTE: Invalid data for opdate_03 in line 11 214-223. NOTE: Invalid data for opdate_04 in line 11 224-233. NOTE: Invalid data for opdate_05 in line 11 234-243. NOTE: Invalid data for opdate_06 in line 11 244-253. NOTE: Invalid data for opdate_07 in line 11 254-263. NOTE: Invalid data for opdate_08 in line 11 264-273. NOTE: Invalid data for opdate_09 in line 11 274-283. NOTE: Invalid data for opdate_10 in line 11 284-287. 11 a4b4e36c15a46ee56af374478438e08e,3f37e45ddaebb5da393d5356041d0378,NHSNO,RCB,VALID,2,Z,,2 89 4,2012-07-21,006,6,1,2012-07-21,01,1,S0250,W222,,,,,,,,,,,,,,,,,,,W222,V151,F635,Z941,,, 177 ,,,,,,,,,,,,,,,,,,2012-07-21,2012-07-21,2012-07-21,,,,,,,,,,,,,,,,,,,,,RCB55,afc31d2449c 265 cd9ff6bc13aa6b31ef5bb,9 287 patient_id=a4b4e36c link_method=3f37e45d procodet=NHSNO postcode_flag=RCB sex=. ethnos=2 classpat=. admimeth= admidate=. admiageprov=-21 admiage=6 dismeth=6 disdate=. epiorder=21 spelend=1 diag_01=1 diag_02=S0250 diag_03=W222 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=W222 opertn_02=V151 opertn_03=F635 opertn_04=Z941 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=10 NOTE: Invalid data for sex in line 12 77-81. NOTE: Invalid data for classpat in line 12 85-85. NOTE: Invalid data for admidate in line 12 89-98. NOTE: Invalid data for disdate in line 12 109-118. NOTE: Invalid data for opdate_01 in line 12 198-207. NOTE: Invalid data for opdate_02 in line 12 208-217. NOTE: Invalid data for opdate_03 in line 12 218-227. NOTE: Invalid data for opdate_04 in line 12 228-237. NOTE: Invalid data for opdate_05 in line 12 238-247. NOTE: Invalid data for opdate_06 in line 12 248-257. NOTE: Invalid data for opdate_07 in line 12 258-261. 12 d882afe95aa56e6787585ed3d7dbd5a1,05c9e6967a3d04cdcb1ff95b27287028,NHSNO,RCU,VALID,2,F,1, 89 22,2012-09-10,007,7,1,2012-09-10,01,1,R55X,G809,Q250,J984,K219,F840,Z931,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCUEF,4091a1cfa465e632e9ae31f3de84e588,1 261 patient_id=d882afe9 link_method=05c9e696 procodet=NHSNO postcode_flag=RCU sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-10 admiage=7 dismeth=7 disdate=. epiorder=10 spelend=1 diag_01=1 diag_02=R55X diag_03=G809 diag_04=Q250 diag_05=J984 diag_06=K219 diag_07=F840 diag_08=Z931 diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=11 NOTE: Invalid data for sex in line 13 77-81. NOTE: Invalid data for classpat in line 13 85-85. NOTE: Invalid data for admidate in line 13 89-98. NOTE: Invalid data for disdate in line 13 109-118. NOTE: Invalid data for opdate_01 in line 13 198-207. NOTE: Invalid data for opdate_02 in line 13 208-217. NOTE: Invalid data for opdate_03 in line 13 218-227. NOTE: Invalid data for opdate_04 in line 13 228-237. NOTE: Invalid data for opdate_05 in line 13 238-247. NOTE: Invalid data for opdate_06 in line 13 248-257. NOTE: Invalid data for opdate_07 in line 13 258-261. 13 b8b8eafb53dbe3bbba0f63c99783ca97,05c9e6967a3d04cdcb1ff95b27287028,NHSNO,RCU,VALID,2,F,1, 89 22,2012-12-25,007,7,1,2012-12-25,01,1,J069,G809,Q250,J984,K219,F840,Z931,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RCUEF,4091a1cfa465e632e9ae31f3de84e588,1 261 patient_id=b8b8eafb link_method=05c9e696 procodet=NHSNO postcode_flag=RCU sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-25 admiage=7 dismeth=7 disdate=. epiorder=25 spelend=1 diag_01=1 diag_02=J069 diag_03=G809 diag_04=Q250 diag_05=J984 diag_06=K219 diag_07=F840 diag_08=Z931 diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=12 NOTE: Invalid data for sex in line 14 77-81. NOTE: Invalid data for classpat in line 14 85-85. NOTE: Invalid data for admidate in line 14 89-98. NOTE: Invalid data for disdate in line 14 109-118. NOTE: Invalid data for opdate_01 in line 14 174-183. NOTE: Invalid data for opdate_02 in line 14 184-193. NOTE: Invalid data for opdate_03 in line 14 194-203. NOTE: Invalid data for opdate_04 in line 14 204-213. NOTE: Invalid data for opdate_05 in line 14 214-223. NOTE: Invalid data for opdate_06 in line 14 224-233. NOTE: Invalid data for opdate_07 in line 14 234-237. 14 1001ddf6711883cf122d1854740a4771,0fbb33e68de0cec26b177b44f0057684,NHSNO,RXF,VALID,2,A,1, 89 21,2012-08-17,004,4,1,2012-08-17,01,1,A084,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,RXF05,d8febc1b8d18e84e87b5a5d515492b50,1 237 patient_id=1001ddf6 link_method=0fbb33e6 procodet=NHSNO postcode_flag=RXF sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-17 admiage=4 dismeth=4 disdate=. epiorder=17 spelend=1 diag_01=1 diag_02=A084 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=13 NOTE: Invalid data for sex in line 15 77-81. NOTE: Invalid data for admidate in line 15 88-97. NOTE: Invalid data for disdate in line 15 108-117. NOTE: Invalid data for opdate_01 in line 15 177-186. NOTE: Invalid data for opdate_02 in line 15 187-196. NOTE: Invalid data for opdate_03 in line 15 197-206. NOTE: Invalid data for opdate_04 in line 15 207-216. NOTE: Invalid data for opdate_05 in line 15 217-226. NOTE: Invalid data for opdate_06 in line 15 227-236. NOTE: Invalid data for opdate_07 in line 15 237-240. 15 b0b61d0003a137325ef4a24fd8bd69f6,660f8646475c88b2d058c3e7aedef9c3,NHSNO,RFF,VALID,1,,1,2 89 1,2015-12-26,004,4,1,2015-12-26,01,1,L509,J22X,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,RFFAA,989c2c0533f7b1ee7ca4e029d394a27b,2 240 patient_id=b0b61d00 link_method=660f8646 procodet=NHSNO postcode_flag=RFF sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-26 admiage=4 dismeth=4 disdate=. epiorder=26 spelend=1 diag_01=1 diag_02=L509 diag_03=J22X diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=14 NOTE: Invalid data for sex in line 16 77-81. NOTE: Invalid data for classpat in line 16 85-85. NOTE: Invalid data for admidate in line 16 89-98. NOTE: Invalid data for disdate in line 16 109-118. NOTE: Invalid data for opdate_01 in line 16 199-208. NOTE: Invalid data for opdate_02 in line 16 209-218. NOTE: Invalid data for opdate_03 in line 16 219-228. NOTE: Invalid data for opdate_04 in line 16 229-238. NOTE: Invalid data for opdate_05 in line 16 239-248. NOTE: Invalid data for opdate_06 in line 16 249-258. NOTE: Invalid data for opdate_07 in line 16 259-268. NOTE: Invalid data for opdate_08 in line 16 269-278. NOTE: Invalid data for opdate_09 in line 16 279-288. NOTE: Invalid data for opdate_10 in line 16 289-292. 16 4163ec6e4f9f764a7671407486e551f7,a42f2b8d44fe8c7e410f14633ab786aa,NHSNO,RP5,VALID,2,A,1, 89 21,2016-04-08,004,4,1,2016-04-09,01,1,S8210,W090,J459,,,,,,,,,,,,,,,,,,W090,X481,Z909,Z9 177 43,,,,,,,,,,,,,,,,,,,,,2016-04-08,2016-04-08,2016-04-08,,,,,,,,,,,,,,,,,,,,,RP5BA,77df50 265 b937f111f32f7c3bd249f9e4e5,9 292 patient_id=4163ec6e link_method=a42f2b8d procodet=NHSNO postcode_flag=RP5 sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-8 admiage=4 dismeth=4 disdate=. epiorder=9 spelend=1 diag_01=1 diag_02=S8210 diag_03=W090 diag_04=J459 diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=W090 opertn_02=X481 opertn_03=Z909 opertn_04=Z943 opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=15 NOTE: Invalid data for sex in line 17 77-81. NOTE: Invalid data for classpat in line 17 85-85. NOTE: Invalid data for admidate in line 17 89-98. NOTE: Invalid data for disdate in line 17 109-118. NOTE: Invalid data for opdate_01 in line 17 174-183. NOTE: Invalid data for opdate_02 in line 17 184-193. NOTE: Invalid data for opdate_03 in line 17 194-203. NOTE: Invalid data for opdate_04 in line 17 204-213. NOTE: Invalid data for opdate_05 in line 17 214-223. NOTE: Invalid data for opdate_06 in line 17 224-233. NOTE: Invalid data for opdate_07 in line 17 234-237. 17 c115cf9c580b1ae4c48dfdf81de4af41,a42f2b8d44fe8c7e410f14633ab786aa,NHSNO,RP5,VALID,2,A,1, 89 21,2016-06-18,004,4,1,2016-06-21,01,1,J459,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,RP5BA,77df50b937f111f32f7c3bd249f9e4e5,9 237 patient_id=c115cf9c link_method=a42f2b8d procodet=NHSNO postcode_flag=RP5 sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-18 admiage=4 dismeth=4 disdate=. epiorder=21 spelend=1 diag_01=1 diag_02=J459 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=16 NOTE: Invalid data for sex in line 18 77-81. NOTE: Invalid data for classpat in line 18 85-85. NOTE: Invalid data for admidate in line 18 89-98. NOTE: Invalid data for disdate in line 18 109-118. NOTE: Invalid data for opdate_01 in line 18 174-183. NOTE: Invalid data for opdate_02 in line 18 184-193. NOTE: Invalid data for opdate_03 in line 18 194-203. NOTE: Invalid data for opdate_04 in line 18 204-213. NOTE: Invalid data for opdate_05 in line 18 214-223. NOTE: Invalid data for opdate_06 in line 18 224-233. NOTE: Invalid data for opdate_07 in line 18 234-237. 18 c6fba06094368bad09b5b3a8888a2501,811e4ce1e956a9defa61b51ffa56f566,NHSNO,RCD,VALID,1,A,1, 89 22,2013-06-21,006,6,1,2013-06-22,01,1,R104,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,RCD01,07c123a28f5a5dfb633db7007b1446ee,9 237 patient_id=c6fba060 link_method=811e4ce1 procodet=NHSNO postcode_flag=RCD sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-21 admiage=6 dismeth=6 disdate=. epiorder=22 spelend=1 diag_01=1 diag_02=R104 diag_03= diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01= opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=17 NOTE: Invalid data for sex in line 19 77-81. NOTE: Invalid data for classpat in line 19 85-85. NOTE: Invalid data for admidate in line 19 89-98. NOTE: Invalid data for disdate in line 19 109-118. NOTE: Invalid data for opdate_01 in line 19 182-191. NOTE: Invalid data for opdate_02 in line 19 192-201. NOTE: Invalid data for opdate_03 in line 19 202-211. NOTE: Invalid data for opdate_04 in line 19 212-221. NOTE: Invalid data for opdate_05 in line 19 222-231. NOTE: Invalid data for opdate_06 in line 19 232-241. NOTE: Invalid data for opdate_07 in line 19 242-246. 19 3bf5751402429a927ee27cb9350600e0,2966f67ce4f64ca7808922065edba764,NHSNO,RXF,VALID,2,A,1, 89 21,2016-07-30,003,3,1,2016-07-30,01,1,T383,X440,,,,,,,,,,,,,,,,,,,X440,,,,,,,,,,,,,,,,,, 177 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RXF05,cd648d490164851580360e67462d558c,10 246 patient_id=3bf57514 link_method=2966f67c procodet=NHSNO postcode_flag=RXF sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-30 admiage=3 dismeth=3 disdate=. epiorder=30 spelend=1 diag_01=1 diag_02=T383 diag_03=X440 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=X440 opertn_02= opertn_03= opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=18 NOTE: Invalid data for sex in line 20 77-81. NOTE: Invalid data for classpat in line 20 85-85. NOTE: Invalid data for admidate in line 20 89-98. NOTE: Invalid data for disdate in line 20 109-118. NOTE: Invalid data for opdate_01 in line 20 190-199. NOTE: Invalid data for opdate_02 in line 20 200-209. NOTE: Invalid data for opdate_03 in line 20 210-219. NOTE: Invalid data for opdate_04 in line 20 220-229. NOTE: Invalid data for opdate_05 in line 20 230-239. NOTE: Invalid data for opdate_06 in line 20 240-249. NOTE: Invalid data for opdate_07 in line 20 250-259. NOTE: Invalid data for opdate_08 in line 20 260-269. NOTE: Invalid data for opdate_09 in line 20 270-273. 20 634702d1d08a11deeb207026cc038f73,e1337bc789045e92211b693cf757b414,NHSNO,RXF,VALID,2,A,1, 89 21,2012-09-19,004,4,1,2012-09-20,01,1,S099,W192,,,,,,,,,,,,,,,,,,,W192,U051,Y981,,,,,,,, 177 ,,,,,,,,,,,,,,2012-09-19,2012-09-19,,,,,,,,,,,,,,,,,,,,,,RXF05,5ad6c94ac5530ba978469dab7 265 98a2cbd,8 273 patient_id=634702d1 link_method=e1337bc7 procodet=NHSNO postcode_flag=RXF sex=. ethnos=2 classpat=. admimeth=1 admidate=. admiageprov=-19 admiage=4 dismeth=4 disdate=. epiorder=20 spelend=1 diag_01=1 diag_02=S099 diag_03=W192 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=W192 opertn_02=U051 opertn_03=Y981 opertn_04= opertn_05= opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=19 NOTE: Invalid data for sex in line 21 77-81. NOTE: Invalid data for classpat in line 21 85-85. NOTE: Invalid data for admidate in line 21 89-98. NOTE: Invalid data for disdate in line 21 109-118. NOTE: Invalid data for opdate_01 in line 21 199-208. NOTE: Invalid data for opdate_02 in line 21 209-218. NOTE: Invalid data for opdate_03 in line 21 219-228. NOTE: Invalid data for opdate_04 in line 21 229-238. NOTE: Invalid data for opdate_05 in line 21 239-248. NOTE: Invalid data for opdate_06 in line 21 249-258. NOTE: Invalid data for opdate_07 in line 21 259-268. NOTE: Invalid data for opdate_08 in line 21 269-278. NOTE: Invalid data for opdate_09 in line 21 279-288. NOTE: Invalid data for opdate_10 in line 21 289-298. NOTE: Invalid data for opdate_11 in line 21 299-302. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 9a29c0e19f52664f1602d0531d726075,31fe068e5f05305aa57e7f0bc139e26b,NHSNO,RR8,VALID,1,A,1, RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 89 21,2016-12-09,002,2,1,2016-12-13,01,1,S7230,W080,,,,,,,,,,,,,,,,,,,W080,W264,Z764,Z943,Y 177 535,,,,,,,,,,,,,,,,,,,,2016-12-09,2016-12-09,2016-12-09,2016-12-09,,,,,,,,,,,,,,,,,,,,RR 265 801,c21b51719ff488a88bf91c8700b1501a,1 302 patient_id=9a29c0e1 link_method=31fe068e procodet=NHSNO postcode_flag=RR8 sex=. ethnos=1 classpat=. admimeth=1 admidate=. admiageprov=-9 admiage=2 dismeth=2 disdate=. epiorder=13 spelend=1 diag_01=1 diag_02=S7230 diag_03=W080 diag_04= diag_05= diag_06= diag_07= diag_08= diag_09= diag_10= diag_11= diag_12= diag_13= diag_14= diag_15= diag_16= diag_17= diag_18= diag_19= diag_20= cause= opertn_01=W080 opertn_02=W264 opertn_03=Z764 opertn_04=Z943 opertn_05=Y535 opertn_06= opertn_07= opertn_08= opertn_09= opertn_11= opertn_12= opertn_13= opertn_14= opertn_15= opertn_16= opertn_17= opertn_18= opertn_19= opertn_20= opertn_21= opertn_22= opertn_23= opertn_24= opdate_01=. opdate_02=. opdate_03=. opdate_04=. opdate_05=. opdate_06=. opdate_07=. opdate_08=. opdate_09=. opdate_10=. opdate_11=. opdate_12=. opdate_13=. opdate_14=. opdate_15=. opdate_16=. opdate_17=. opdate_18=. opdate_19=. opdate_20=. opdate_21=. opdate_22=. opdate_23=. opdate_24=. sitetret= pgpprac= imd15decile_overall=. _ERROR_=1 _N_=20 NOTE: 263868 records were read from the infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV'. The minimum record length was 204. The maximum record length was 649. NOTE: The data set WORK.SHEFFIELD_APC has 263868 observations and 86 variables. NOTE: DATA statement used (Total process time): real time 2.92 seconds cpu time 1.40 seconds ... View more

Re: Capturing data

by Quartz | Level 8 in SAS Programming
‎09-02-2019 06:04 AM
‎09-02-2019 06:04 AM
And also, how do we write this array if we wanted to drop observations with diagnoses codes (given in variables diag_01 to diag_09) including values like J21, J0, J38, J37 regardless of values/digits/characters before and after them.   Thanks S ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-21-2020 01:05 PM
Quick links