BookmarkSubscribeRSS Feed
sks521
Quartz | Level 8

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


14 REPLIES 14
PeterClemmensen
Tourmaline | Level 20

Seems like you have invalid data for quite some variables. For example, what data values do you have for your sex variable? You define it as a numeric variable.

sks521
Quartz | Level 8

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

sks521
Quartz | Level 8

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.

Tom
Super User Tom
Super User

Don't use formatted style input when reading delimited data.  Make sure to use list style input.

That means don't have something like:

admidate DDMMYY10.

in your input statement. Because that says to read to next 10 characters, whether they include the delimiter or not.

 

You can add the colon modifier before the informat specification to keep using list mode.

You can also add the ?? modifier to prevent values of "null" from generating an ERROR in the log. Instead the date will just be set to missing.  But use that carefully because it will suppress all of the error messages for the date values.

 

You seem to have a lot of date variables so it might be easier to instead use the INFORMAT statement to tell SAS what informat to use when reading the text from the data lines.

input ... opdate_01 - opdate_24 ... ;
informat opdate_01 - opdate_24 ddmmyy10.;

Or use () to setup lists of variables and lists of informats to use for them.

input .... (opdate_01 - opdate_24) (:??ddmmyy10.) ... ;

 

 

 

Kurt_Bremser
Super User

You are reading all character values with just the dollar sign as definition. SAS will define the variable with the default length of 8, leading to truncation of values or waste of space when values are always shorter than that.

It is better to set lengths and other required attributes (informats!) for variables beforehand, to have an input statement that is free of all the clutter.

So your statements should rather be

data Sheffield_apc;
infile 'I:\CHCSheffield\20190401ACE-original\ACE_APC_20190401_rev.CSV' dlm=',' dsd truncover lrecl=32767 firstobs=2;
length
  patient_id
  link_method
    $32
  procodet $5
  postcode_flag $3
  /* insert other variables here */
  diag_01-diag_20 $10
  opertn_01-opertn_24 $10
  opdate_01-opdate_24 4
;
informat
  admidate
  disdate
  opdate_01-opdate_24
    yymmdd10.
;
input
  patient_id
  link_method
  procodet
  postcode_flag
  sex 
  ethnos
  classpat
  admimeth
  admidate
  admiageprov
  admiage
  dismeth
  disdate 
  epiorder
  spelend
  diag_01-diag_20
  cause
  opertn_01-opertn_24
  opdate_01-opdate_24
  sitetret
  pgpprac
  imd15decile_overall
;

Note how I made use of variable lists (ranges) to make the code shorter.

Are you sure you only have 20 diagnoses, but 24 operation data groups?

And then count the columns in your infile and compare them to your input statement.

"sex" is defined as a numeric variable, but you read it on fifth position, which is the string "VALID" in your infile. Carefully study the documentation you got with the file, so that the columns match.

sks521
Quartz | Level 8

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;

Kurt_Bremser
Super User

4 bytes are enough to store the count of days since 1960-01-01 (that's what a SAS date is) in a binary format. For numeric variables, the length statement defines the number of bytes used for the binary real number storage format, not the decimal digits.

The 8-byte default (and maximum) length of binary number storage in SAS provides the possibility to store very large and very small numbers (because of the exponent contained) with a precision of maximally 16 decimal digits.

Using a length of 4 for dates reduces storage consumption (dates in databases are also stored in 4 bytes) without the danger of losing the necessary precision. This can be done safely because dates are operating with integers only. As soon as you have fractions, always use the default length of 8.

 

See

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000695157.htm

for in-depth information.

sks521
Quartz | Level 8

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
sks521
Quartz | Level 8

And when I print date variables, It comes up with missing values for all observations.

sks521
Quartz | Level 8

hat I understand from log is tht these lines/observations have missing values for admidate, disdate and sitetre but when I look up source data, there are valid values. Don't know what's gone wrong?

sks521
Quartz | Level 8

Thanks @Kurt_Bremser , you have a very strange but fun way of criticizing.

 

It was me messing up with the code.

 

Best wishes

S

Kurt_Bremser
Super User

You suffer from magically changing data.

In your first post, the dates came in the format YYYY-MM-DD, now they suddenly come as DD/MM/YYYY.

With such unreliable and inconsistent data, there's not much you can do, except return to sender with a nastygram questioning what they want from you.

 

If that inconsistency is not the case, please post (copy/paste) a REAL example of the input data into a window opened with the {i} button (EXTREMELY IMPORTANT!!!). Only such a subwindow will keep text data as is.

And post the description of the columns, so that code matching the file structure (reliably) can be written.

Tom
Super User Tom
Super User

You didn't read the post carefully enough.

Notice how you kept this comment.  

/* insert other variables here */

Did you actually define all of the variables in your LENGTH statement?

 

Why did you define ANY of the numeric variables with a length less than 8? It takes 8 bytes to store the 64 bit floating point values SAS uses for numbers.  You can use a smaller value, but know that you might lose data converting those lower order bytes to all zeros.  There is a nice table in the documentation that lists the maximum integer than can be stored precisely with fewer bytes.

 

Why did you change the informat for the date fields from DDMMYY to YYMMDD?

 

ballardw
Super User

How many characters do you expect your Patient_id and Link_method variables to hold? Using a generic $ without a specified width they only hold 8 characters. It appears that you should be specifying at least 32 characters to hold those. And I think similar for the Pgpprac variable.

 

I think that perhaps you are missing a variable between procodet and postcode_flag. You get errors reading sex is attempting to read "VALID" when your postcode_flag show values like RR8. The "valid" seems much more likely as a value for a variable named "postalcode_flag". If my supposition is correct then all of the following variables would be reading the wrong column with likely variable type mismatches.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 14 replies
  • 1387 views
  • 0 likes
  • 5 in conversation