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: Invalid data error

by Quartz | Level 8 in SAS Programming
‎08-12-2019 10:57 AM
‎08-12-2019 10:57 AM
Thanks but how do I incorporate the rest of input fields in this syntax. DATA AandE; INFILE 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv' firstobs=2 DSD truncover length=len column=cc ; FILE 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401_fixed.csv' dsd; length string $500 ; do until(cc > len); input string @ aekey $ patient_id $ link_method $ procodet $ postcode_flag $ sex $ ethnos $ activage $ arrivalage pgpprac $ sitetret $ aearrivalmode $ aeattenddisp $ aerefsource $ aedepttype $ aearrivaldate :DDMMYY10. aearrivaltime diag_scheme diag_01 $ diag_02 $ diag_03 $ diag_04 $ diag_05 $ diag_06 $ diag_07 $ diag_08 $ diag_09 $ diag_10 $ diag_11 $ diag_12 $ invest_01 $ invest_02 $ invest_03 $ invest_04 $ invest_05 $ invest_06 $ invest_07 $ invest_08 $ invest_09 $ invest_10 $ invest_11 $ invest_12 $ treat_01 $ treat_02 $ treat_03 $ treat_04 $ treat_05 $ treat_06 $ treat_07 $ treat_08 $ treat_09 $ treat_10 $ treat_11 $ treat_12 $ imd15decile_overall $; if arrivalage in (0.001, 0.011, 0.049, 0.164, 0.375, 0.625, 0.874, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16); if aearrivaldate not in (''); if string = 'NA' then string=' '; put string @; end; put; run; ... View more

Re: Invalid data error

by Quartz | Level 8 in SAS Programming
‎08-12-2019 10:07 AM
‎08-12-2019 10:07 AM
Wish I could! Data is extracted from the National Health Services routine data and observations with NA in these fields are needed in further analysis. ... View more

Re: Invalid data error

by Quartz | Level 8 in SAS Programming
‎08-12-2019 06:31 AM
‎08-12-2019 06:31 AM
Thanks,    So I have now tried writing up 'Infile' statement to get my data into SAS as follows;   { DATA AandE; INFILE 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv' firstobs=2 DSD MISSOVER; input aekey $ patient_id $ link_method $ procodet $ postcode_flag $ sex $ ethnos $ activage $ arrivalage pgpprac $ sitetret $ aearrivalmode $ aeattenddisp $ aerefsource $ aedepttype $ aearrivaldate DDMMYY10. aearrivaltime diag_scheme diag_01 $ diag_02 $ diag_03 $ diag_04 $ diag_05 $ diag_06 $ diag_07 $ diag_08 $ diag_09 $ diag_10 $ diag_11 $ diag_12 $ invest_01 $ invest_02 $ invest_03 $ invest_04 $ invest_05 $ invest_06 $ invest_07 $ invest_08 $ invest_09 $ invest_10 $ invest_11 $ invest_12 $ treat_01 $ treat_02 $ treat_03 $ treat_04 $ treat_05 $ treat_06 $ treat_07 $ treat_08 $ treat_09 $ treat_10 $ treat_11 $ treat_12 $ imd15decile_overall; if arrivalage in (0.001, 0.011, 0.049, 0.164, 0.375, 0.625, 0.874, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16); if aearrivaldate not in (''); run; }   SAS log is; 19 DATA AandE; 20 INFILE 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv' firstobs=2 DSD MISSOVER; 21 input aekey $ patient_id $ link_method $ procodet $ postcode_flag $ 21 ! sex $ ethnos $ activage $ arrivalage 22 pgpprac $ sitetret $ aearrivalmode $ aeattenddisp $ aerefsource $ aedepttype $ 22 ! aearrivaldate DDMMYY10. aearrivaltime diag_scheme 23 diag_01 $ diag_02 $ diag_03 $ diag_04 $ diag_05 $ diag_06 $ diag_07 $ 23 ! diag_08 $ diag_09 $ diag_10 $ diag_11 $ 24 diag_12 $ invest_01 $ invest_02 $ invest_03 $ invest_04 $ invest_05 $ invest_06 $ 24 ! invest_07 $ invest_08 $ invest_09 $ 25 invest_10 $ invest_11 $ invest_12 $ treat_01 $ treat_02 $ treat_03 $ 25 ! treat_04 $ treat_05 $ treat_06 $ 26 treat_07 $ treat_08 $ treat_09 $ treat_10 $ treat_11 $ treat_12 $ 26 ! imd15decile_overall; 27 if arrivalage in (0.001, 0.011, 0.049, 0.164, 0.375, 0.625, 0.874, 1, 2, 3, 4, 5, 6, 7, 27 ! 8, 9, 10, 11, 12, 13, 14, 15, 16); 28 * if aearrivaldate not in ('1801-01-01'); 29 /* output will only include children 0-16 years */ 30 *if procodet not in ("RCF" , "RFF" , "RAE", "RWY", "RP5", "RCD", "RWA", "RR8", "RXF" , 30 ! "RJL" , "RCU" , "RHQ" , "RFR" , "RCB") then delete; 31 /*this will get data on Yorkshire and humber NHS Trusts only */ 32 *List of NHS Trusts in Yorkshire & Hmber include Airdale NHS Foundation Trust coded as 32 ! RCF, Barnsley as RFF, Bradford as RAE, Calderdale as RWY, Doncaster and Bassetlaw as RP5, 33 Harrogate and district as RCD, Hull university teaching hospital in the provider code 33 ! list but in the data dictionary it's Hull and East Yorkshire hospitals coded as RWA, 34 Leeds teaching hospital as RR8, Mid Yorkshire hospitals as RXF, Northern Lincolnshire 34 ! and coole as RJL, Sheffield Children's NHS foundation trust RCU, 35 Sheffield teaching hospital as RHQ, rotheram as RFR and York teaching hospital as RCB; 36 RUN; NOTE: The infile 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv' is: Filename=I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv, RECFM=V,LRECL=32767, File Size (bytes)=420517409, Last Modified=01 April 2019 18:58:31, Create Time=29 July 2019 16:34:07 NOTE: Invalid data for aearrivaldate in line 2 141-150. NOTE: Invalid data for imd15decile_overall in line 2 265-266. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-- 2 e81e201e78d19d8c3f5122ce7d96c25a,97e023526b0dc2b5e9e08eed37775ab8,NHSNO,RXF,VALID,1,A,0 88 02,73,da4863e90b0b5a360e63d7df2e28815c,NA,2,03,01,01,2013-06-09,1014,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,34,41,NA,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,3 268 aekey=e81e201e patient_id=97e02352 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=002 arrivalage=73 pgpprac=da4863e9 sitetret=NA aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1014 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=34 treat_03=41 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=1 NOTE: Invalid data for aearrivaldate in line 3 141-150. NOTE: Invalid data for imd15decile_overall in line 3 267-268. 3 5221b6afed59cee127663fe106688fd0,b76acf7d6e16213737184da41a1794a1,NHSNO,RXF,VALID,2,J,0 88 06,82,37d3d7784bee79f316d64b46e9c6dc78,NA,2,03,01,01,2013-06-28,1359,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,01,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,221,222,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,3 270 aekey=5221b6af patient_id=b76acf7d link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=J activage=006 arrivalage=82 pgpprac=37d3d778 sitetret=NA aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1359 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=221 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=2 NOTE: Invalid data for aearrivaldate in line 4 143-152. NOTE: Invalid data for imd15decile_overall in line 4 269-270. 4 c5f9d619392b7317bff4355d7e0c3829,8e19bf9b06f32ea3538b417a69254e3f,NHSNO,RCB,VALID,1,A,N 88 A,16,b6a4f27069e741c4c88b4c9975cd46bd,RCB55,2,03,01,01,2012-06-21,1602,01,NA,NA,NA,NA,N 175 A,NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,221,011,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,3 272 aekey=c5f9d619 patient_id=8e19bf9b link_method=NHSNO procodet=RCB postcode_flag=VALID sex=1 ethnos=A activage=NA arrivalage=16 pgpprac=b6a4f270 sitetret=RCB55 aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1602 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=221 treat_03=011 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=3 NOTE: Invalid data for aearrivaldate in line 5 144-153. NOTE: Invalid data for imd15decile_overall in line 5 273-274. 5 42bdbdc79100370c0f7b92e8219c950f,2a44ce4db8a93eb5a111d0900a818351,NHSNO,RWY,VALID,2,A,0 88 16,16,6868ed2cc119330c86104685a1100ecb,RWY01,2,03,01,01,2012-04-21,0231,01,05 15L,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,NA,01,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,511,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,NA,9 276 aekey=42bdbdc7 patient_id=2a44ce4d link_method=NHSNO procodet=RWY postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=6868ed2c sitetret=RWY01 aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=231 diag_01=01 diag_02=05 15L diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=01 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=511 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=4 NOTE: Invalid data for aearrivaldate in line 6 141-150. NOTE: Invalid data for imd15decile_overall in line 6 266-267. 6 b43c9c6090a4a0eb69b5bd88f8b76e8f,1e46f877744f9cceec87405da4716053,NHSNO,RXF,VALID,2,A,0 88 15,21,b9e9dcb35b94dc784ba3a480d40ed041,NA,2,01,01,01,2013-06-17,1423,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,511,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,4 269 aekey=b43c9c60 patient_id=1e46f877 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=015 arrivalage=21 pgpprac=b9e9dcb3 sitetret=NA aearrivalmode=2 aeattenddisp=01 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1423 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=511 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=5 NOTE: Invalid data for aearrivaldate in line 7 144-153. NOTE: Invalid data for imd15decile_overall in line 7 273-274. 7 dd8c32086cfd590049fdeb9817083967,f21138c84b7ea596bb1aeb4a7cbb1e32,NHSNO,RWA,VALID,1,A,0 88 16,16,f6b0b1b3a917196df5ac8dedbf282b03,RWA00,2,02,01,01,2012-02-28,1123,01,03 25L,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,NA,03,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,291,43,21,12,NA,NA,NA,N 262 A,NA,NA,NA,NA,3 276 aekey=dd8c3208 patient_id=f21138c8 link_method=NHSNO procodet=RWA postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=f6b0b1b3 sitetret=RWA00 aearrivalmode=2 aeattenddisp=02 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1123 diag_01=01 diag_02=03 25L diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=03 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=291 treat_03=43 treat_04=21 treat_05=12 treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=6 NOTE: Invalid data for aearrivaldate in line 8 131-140. NOTE: Invalid data for imd15decile_overall in line 8 258-259. 8 c810915d6201106c5e9caec870183a21,23f76559afb9135cb92fbcf9072d9957,FULL ID NHSNO LINK,RJ 88 L,VALID,1,A,016,16,V81999,RJL32,2,03,01,01,2012-01-21,1601,01,NA,NA,NA,NA,NA,NA,NA,NA,N 175 A,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,21,236,042,NA,NA,NA,NA,NA,NA,NA,NA,8 261 aekey=c810915d patient_id=23f76559 link_method=FULL ID procodet=RJL postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=V81999 sitetret=RJL32 aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1601 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=222 treat_03=21 treat_04=236 treat_05=042 treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=7 NOTE: Invalid data for aearrivaldate in line 9 144-153. NOTE: Invalid data for imd15decile_overall in line 9 268-269. 9 4c8808798cb8278f03540122edb7f1b1,1152df925fcc5d927f5e811485338fc0,NHSNO,RP5,VALID,2,A,0 88 16,16,8e29e8d20b7b2d694d4251505166202c,RP5DR,2,02,08,01,2012-04-11,2115,01,38,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,99,NA,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,NA,5 271 aekey=4c880879 patient_id=1152df92 link_method=NHSNO procodet=RP5 postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=8e29e8d2 sitetret=RP5DR aearrivalmode=2 aeattenddisp=02 aerefsource=08 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=2115 diag_01=01 diag_02=38 diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=99 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=8 NOTE: Invalid data for aearrivaldate in line 10 144-153. NOTE: Invalid data for imd15decile_overall in line 10 269-270. 10 4ee99a96e5cdee139f6c7b4a3ec31734,1152df925fcc5d927f5e811485338fc0,NHSNO,RP5,VALID,2,A,0 88 16,16,8e29e8d20b7b2d694d4251505166202c,RP5DR,2,05,01,01,2012-08-16,2029,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,51,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,5 272 aekey=4ee99a96 patient_id=1152df92 link_method=NHSNO procodet=RP5 postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=8e29e8d2 sitetret=RP5DR aearrivalmode=2 aeattenddisp=05 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=2029 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=222 treat_03=51 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=9 NOTE: Invalid data for aearrivaldate in line 11 144-153. NOTE: Invalid data for imd15decile_overall in line 11 269-270. 11 ab1c30f4ae71acebfc5dc9cff812ae53,3ab4b9ec7420ffa8988cfa496116359c,NHSNO,RCD,VALID,2,A,0 88 16,16,eade35a693a9b16e87df763977afb438,RCD00,9,03,08,01,2012-04-07,1933,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,5 272 aekey=ab1c30f4 patient_id=3ab4b9ec link_method=NHSNO procodet=RCD postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=eade35a6 sitetret=RCD00 aearrivalmode=9 aeattenddisp=03 aerefsource=08 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1933 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=10 NOTE: Invalid data for aearrivaldate in line 12 141-150. NOTE: Invalid data for imd15decile_overall in line 12 265-266. 12 002c5a7a483c7f9a281393e9d5886edd,36c1b661c6472d7c520013558fab9993,NHSNO,RXF,VALID,1,A,0 88 12,41,e7c400b0c9b7de3d6465d4525908c955,NA,2,12,01,04,2013-06-03,0952,01,38,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,27,NA,NA,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,2 268 aekey=002c5a7a patient_id=36c1b661 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=012 arrivalage=41 pgpprac=e7c400b0 sitetret=NA aearrivalmode=2 aeattenddisp=12 aerefsource=01 aedepttype=04 aearrivaldate=. aearrivaltime=. diag_scheme=952 diag_01=01 diag_02=38 diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=27 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=11 NOTE: Invalid data for aearrivaldate in line 13 141-150. NOTE: Invalid data for imd15decile_overall in line 13 266-267. 13 dcc81124ce35647223c9d78c59bfa4c9,0bb5d959bd1e72c06a523e9179f2325a,NHSNO,RXF,VALID,2,A,0 88 07,20,51c5f674fc8d4674054fc56574548648,NA,2,02,00,01,2013-06-12,1126,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,10,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,2 269 aekey=dcc81124 patient_id=0bb5d959 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=007 arrivalage=20 pgpprac=51c5f674 sitetret=NA aearrivalmode=2 aeattenddisp=02 aerefsource=00 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1126 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=10 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=12 NOTE: Invalid data for aearrivaldate in line 14 141-150. NOTE: Invalid data for imd15decile_overall in line 14 266-267. 14 7fe0f97fad130b4cb0f2582fad3a3fd2,64679614526ef9ac7bf460b5b09495ca,NHSNO,RXF,VALID,2,A,0 88 08,88,8d1cfce8fc671545bfb10503dbfcabaa,NA,1,01,03,01,2013-06-27,1755,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,10 270 aekey=7fe0f97f patient_id=64679614 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=008 arrivalage=88 pgpprac=8d1cfce8 sitetret=NA aearrivalmode=1 aeattenddisp=01 aerefsource=03 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1755 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=13 NOTE: Invalid data for aearrivaldate in line 15 141-150. NOTE: Invalid data for imd15decile_overall in line 15 266-267. 15 9c346f3bf96e86c5c11e4c97c8db930d,6cc798e3ad901302d5df814f3fe7334a,NHSNO,RXF,VALID,1,R,0 88 02,73,1e3bcd6cf64f82d0f570a8962437f633,NA,1,01,00,01,2013-06-14,1238,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,3 269 aekey=9c346f3b patient_id=6cc798e3 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=R activage=002 arrivalage=73 pgpprac=1e3bcd6c sitetret=NA aearrivalmode=1 aeattenddisp=01 aerefsource=00 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1238 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=14 NOTE: Invalid data for aearrivaldate in line 16 141-150. NOTE: Invalid data for imd15decile_overall in line 16 266-267. 16 d1787cf846fb617e63153dbc7c901e87,12b080b9cc4ba31655ebfdd5c0ee3c27,NHSNO,RXF,VALID,2,J,0 88 11,67,2a39f9120297aeaaca766b1483bcbba8,NA,2,04,00,01,2013-06-04,1449,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,8 269 aekey=d1787cf8 patient_id=12b080b9 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=J activage=011 arrivalage=67 pgpprac=2a39f912 sitetret=NA aearrivalmode=2 aeattenddisp=04 aerefsource=00 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1449 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=15 NOTE: Invalid data for aearrivaldate in line 17 141-150. NOTE: Invalid data for imd15decile_overall in line 17 266-267. 17 4f0e6017b9c6da5650d3972a61681599,12b080b9cc4ba31655ebfdd5c0ee3c27,NHSNO,RXF,VALID,2,L,0 88 13,67,2a39f9120297aeaaca766b1483bcbba8,NA,2,03,07,01,2013-06-07,1133,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,8 269 aekey=4f0e6017 patient_id=12b080b9 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=L activage=013 arrivalage=67 pgpprac=2a39f912 sitetret=NA aearrivalmode=2 aeattenddisp=03 aerefsource=07 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1133 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=16 NOTE: Invalid data for aearrivaldate in line 18 144-153. NOTE: Invalid data for imd15decile_overall in line 18 268-269. 18 de5e1b9898373a106a4a16ad01cb25c3,50d356d07b3e92e1258e0b35e0cfcc09,NHSNO,RP5,VALID,2,A,0 88 16,16,50a35e60f27ff4668292dccdfa3e8828,RP5DR,1,02,01,01,2012-07-14,1352,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,01,02,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,25,12,NA,NA,NA,NA,NA,NA,NA, RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-- 262 NA,NA,NA,2 271 aekey=de5e1b98 patient_id=50d356d0 link_method=NHSNO procodet=RP5 postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=50a35e60 sitetret=RP5DR aearrivalmode=1 aeattenddisp=02 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1352 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=01 invest_03=02 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=25 treat_03=12 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=17 NOTE: Invalid data for aearrivaldate in line 19 144-153. NOTE: Invalid data for imd15decile_overall in line 19 268-269. 19 3f4118a4e4c224a7478e4b33bb3e6105,50d356d07b3e92e1258e0b35e0cfcc09,NHSNO,RP5,VALID,2,A,0 88 16,16,50a35e60f27ff4668292dccdfa3e8828,RP5DR,1,02,08,01,2012-08-15,1110,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,02,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,99,NA,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,NA,2 271 aekey=3f4118a4 patient_id=50d356d0 link_method=NHSNO procodet=RP5 postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=50a35e60 sitetret=RP5DR aearrivalmode=1 aeattenddisp=02 aerefsource=08 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1110 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=02 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=99 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=18 NOTE: Invalid data for aearrivaldate in line 20 141-150. NOTE: Invalid data for imd15decile_overall in line 20 266-267. 20 cdea90793c93c0f14a37e72146351a22,52712651674edb68a015eedfeaa65f48,NHSNO,RXF,VALID,2,A,0 88 04,29,332b1c9a7755133784452aa2e73495cd,NA,2,03,01,01,2013-06-30,0710,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,21,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,9 269 aekey=cdea9079 patient_id=52712651 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=004 arrivalage=29 pgpprac=332b1c9a sitetret=NA aearrivalmode=2 aeattenddisp=03 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=710 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=24 invest_03=24 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=21 treat_03=222 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=19 NOTE: Invalid data for aearrivaldate in line 21 141-150. NOTE: Invalid data for imd15decile_overall in line 21 266-267. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 96a372e7c7f98c481da3fb70a6f22ce1,78240b57dcf604ff84263a80e7e15a2b,NHSNO,RXF,VALID,2,A,0 88 09,27,5a1d8e249b4fbd67ad17e4654a4ec7ca,NA,2,06,01,01,2013-06-24,1306,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,03,03,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,8 269 aekey=96a372e7 patient_id=78240b57 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=009 arrivalage=27 pgpprac=5a1d8e24 sitetret=NA aearrivalmode=2 aeattenddisp=06 aerefsource=01 aedepttype=01 aearrivaldate=. aearrivaltime=. diag_scheme=1306 diag_01=01 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=NA invest_02=03 invest_03=03 invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=NA treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=20 NOTE: 1536914 records were read from the infile 'I:\CHCSheffield\20190401ACE\ACE_AE_20190401.csv'. The minimum record length was 237. The maximum record length was 322. NOTE: The data set WORK.AANDE has 1533841 observations and 55 variables. NOTE: DATA statement used (Total process time): real time 11.76 seconds cpu time 7.12 seconds }     And I am getting 'aearrivaldate' as missing for all observations.   Any help will be much appreciated.   Thanks     ... View more

Invalid data error

by Quartz | Level 8 in SAS Programming
‎07-30-2019 05:30 AM
‎07-30-2019 05:30 AM
  Hi folks,   I am importing a data set using proc import as below; { proc import datafile = 'I:\cYorkshire Project\Care pathway for asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv' out = AandE dbms = csv; run; }   However get errors in multiple places, Please can someone see the log and tell me where has it gone wrong;   { 5 proc import datafile = 'I:\cYorkshire Project\Care pathway for 5 ! asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv' 6 out = AandE 7 dbms = csv; 8 run; 9 /********************************************************************** 10 * PRODUCT: SAS 11 * VERSION: 9.4 12 * CREATOR: External File Interface 13 * DATE: 29JUL19 14 * DESC: Generated SAS Datastep Code 15 * TEMPLATE SOURCE: (None Specified.) 16 ***********************************************************************/ 17 data WORK.AANDE ; 18 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 19 infile 'I:\cYorkshire Project\Care pathway for 19 ! asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv' delimiter = ',' MISSOVER DSD 19 ! lrecl=32767 firstobs=2 ; 20 informat aekey $32. ; 21 informat patient_id $32. ; 22 informat link_method $18. ; 23 informat procodet $3. ; 24 informat postcode_flag $5. ; 25 informat sex best32. ; 26 informat ethnos $1. ; 27 informat activage $3. ; 28 informat arrivalage best32. ; 29 informat pgpprac $32. ; 30 informat sitetret $5. ; 31 informat aearrivalmode best32. ; 32 informat aeattenddisp best32. ; 33 informat aerefsource best32. ; 34 informat aedepttype best32. ; 35 informat aearrivaldate yymmdd10. ; 36 informat aearrivaltime best32. ; 37 informat diag_scheme best32. ; 38 informat diag_01 $6. ; 39 informat diag_02 $2. ; 40 informat diag_03 $2. ; 41 informat diag_04 $2. ; 42 informat diag_05 $2. ; 43 informat diag_06 $2. ; 44 informat diag_07 $2. ; 45 informat diag_08 $2. ; 46 informat diag_09 $2. ; 47 informat diag_10 $2. ; 48 informat diag_11 $2. ; 49 informat diag_12 $2. ; 50 informat invest_01 best32. ; 51 informat invest_02 $2. ; 52 informat invest_03 $2. ; 53 informat invest_04 $2. ; 54 informat invest_05 $2. ; 55 informat invest_06 $2. ; 56 informat invest_07 $2. ; 57 informat invest_08 $2. ; 58 informat invest_09 $2. ; 59 informat invest_10 $2. ; 60 informat invest_11 $2. ; 61 informat invest_12 $2. ; 62 informat treat_01 best32. ; 63 informat treat_02 $3. ; 64 informat treat_03 $3. ; 65 informat treat_04 $3. ; 66 informat treat_05 $2. ; 67 informat treat_06 $2. ; 68 informat treat_07 $2. ; 69 informat treat_08 $2. ; 70 informat treat_09 $2. ; 71 informat treat_10 $2. ; 72 informat treat_11 $2. ; 73 informat treat_12 $2. ; 74 informat imd15decile_overall best32. ; 75 format aekey $32. ; 76 format patient_id $32. ; 77 format link_method $18. ; 78 format procodet $3. ; 79 format postcode_flag $5. ; 80 format sex best12. ; 81 format ethnos $1. ; 82 format activage $3. ; 83 format arrivalage best12. ; 84 format pgpprac $32. ; 85 format sitetret $5. ; 86 format aearrivalmode best12. ; 87 format aeattenddisp best12. ; 88 format aerefsource best12. ; 89 format aedepttype best12. ; 90 format aearrivaldate yymmdd10. ; 91 format aearrivaltime best12. ; 92 format diag_scheme best12. ; 93 format diag_01 $6. ; 94 format diag_02 $2. ; 95 format diag_03 $2. ; 96 format diag_04 $2. ; 97 format diag_05 $2. ; 98 format diag_06 $2. ; 99 format diag_07 $2. ; 100 format diag_08 $2. ; 101 format diag_09 $2. ; 102 format diag_10 $2. ; 103 format diag_11 $2. ; 104 format diag_12 $2. ; 105 format invest_01 best12. ; 106 format invest_02 $2. ; 107 format invest_03 $2. ; 108 format invest_04 $2. ; 109 format invest_05 $2. ; 110 format invest_06 $2. ; 111 format invest_07 $2. ; 112 format invest_08 $2. ; 113 format invest_09 $2. ; 114 format invest_10 $2. ; 115 format invest_11 $2. ; 116 format invest_12 $2. ; 117 format treat_01 best12. ; 118 format treat_02 $3. ; 119 format treat_03 $3. ; 120 format treat_04 $3. ; 121 format treat_05 $2. ; 122 format treat_06 $2. ; 123 format treat_07 $2. ; 124 format treat_08 $2. ; 125 format treat_09 $2. ; 126 format treat_10 $2. ; 127 format treat_11 $2. ; 128 format treat_12 $2. ; 129 format imd15decile_overall best12. ; 130 input 131 aekey $ 132 patient_id $ 133 link_method $ 134 procodet $ 135 postcode_flag $ 136 sex 137 ethnos $ 138 activage $ 139 arrivalage 140 pgpprac $ 141 sitetret $ 142 aearrivalmode 143 aeattenddisp 144 aerefsource 145 aedepttype 146 aearrivaldate 147 aearrivaltime 148 diag_scheme 149 diag_01 $ 150 diag_02 $ 151 diag_03 $ 152 diag_04 $ 153 diag_05 $ 154 diag_06 $ 155 diag_07 $ 156 diag_08 $ 157 diag_09 $ 158 diag_10 $ 159 diag_11 $ 160 diag_12 $ 161 invest_01 162 invest_02 $ 163 invest_03 $ 164 invest_04 $ 165 invest_05 $ 166 invest_06 $ 167 invest_07 $ 168 invest_08 $ 169 invest_09 $ 170 invest_10 $ 171 invest_11 $ 172 invest_12 $ 173 treat_01 174 treat_02 $ 175 treat_03 $ 176 treat_04 $ 177 treat_05 $ 178 treat_06 $ 179 treat_07 $ 180 treat_08 $ 181 treat_09 $ 182 treat_10 $ 183 treat_11 $ 184 treat_12 $ 185 imd15decile_overall 186 ; 187 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 188 run; NOTE: The infile 'I:\cYorkshire Project\Care pathway for asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv' is: Filename=I:\cYorkshire Project\Care pathway for asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv, RECFM=V,LRECL=32767, File Size (bytes)=420517409, Last Modified=01 April 2019 18:58:31, Create Time=01 April 2019 18:37:33 NOTE: Invalid data for aerefsource in line 38 135-136. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-- 38 f537f23f13d4316a5085f35ea469c8b2,699666344ed513a15dc745eabf1deb3b,NHSNO,RXF,VALID,2,A,0 88 05,72,2a39f9120297aeaaca766b1483bcbba8,NA,2,02,NA,01,2013-06-26,1204,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,221,222,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,2 270 aekey=f537f23f13d4316a5085f35ea469c8b2 patient_id=699666344ed513a15dc745eabf1deb3b link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=005 arrivalage=72 pgpprac=2a39f9120297aeaaca766b1483bcbba8 sitetret=NA aearrivalmode=2 aeattenddisp=2 aerefsource=. aedepttype=1 aearrivaldate=2013-06-26 aearrivaltime=1204 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=221 treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=2 _ERROR_=1 _N_=37 NOTE: Invalid data for aerefsource in line 100 135-136. 100 83a15549b5951c8770e10bdbeea128df,ab340d8e605d3b38bedf2da2bfdbf35c,NHSNO,RXF,VALID,1,A,0 88 08,52,3d32f458f031f4fe258f2b492b3f803c,NA,2,02,NA,01,2013-06-26,0944,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,1 269 aekey=83a15549b5951c8770e10bdbeea128df patient_id=ab340d8e605d3b38bedf2da2bfdbf35c link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=008 arrivalage=52 pgpprac=3d32f458f031f4fe258f2b492b3f803c sitetret=NA aearrivalmode=2 aeattenddisp=2 aerefsource=. aedepttype=1 aearrivaldate=2013-06-26 aearrivaltime=944 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=1 _ERROR_=1 _N_=99 NOTE: Invalid data for aerefsource in line 149 135-136. 149 6194f1a398d6b7c068f84b3add799438,7d678f09ca422e57586a83f621453ff8,NHSNO,RXF,VALID,2,A,0 88 03,47,a9658493c4ad50ca809e1bcda4570971,NA,2,03,NA,01,2013-06-25,1040,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,3 269 aekey=6194f1a398d6b7c068f84b3add799438 patient_id=7d678f09ca422e57586a83f621453ff8 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=003 arrivalage=47 pgpprac=a9658493c4ad50ca809e1bcda4570971 sitetret=NA aearrivalmode=2 aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2013-06-25 aearrivaltime=1040 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=3 _ERROR_=1 _N_=148 NOTE: Invalid data for aerefsource in line 162 135-136. 162 3371615f5da68e1514e3446eeb5b5102,619e54142e4b370ef353850bc15a3ef7,NHSNO,RXF,VALID,1,J,0 88 12,50,e8f660dbeddf6aa38c09ffc952b8a022,NA,2,03,NA,01,2013-06-24,1125,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,2 269 aekey=3371615f5da68e1514e3446eeb5b5102 patient_id=619e54142e4b370ef353850bc15a3ef7 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=J activage=012 arrivalage=50 pgpprac=e8f660dbeddf6aa38c09ffc952b8a022 sitetret=NA aearrivalmode=2 aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2013-06-24 aearrivaltime=1125 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=2 _ERROR_=1 _N_=161 NOTE: Invalid data for aerefsource in line 173 135-136. 173 4fa6c462785090999ee53dda8e790f96,6705911a99c93a09ef5e605e8d9ced3b,NHSNO,RXF,VALID,1,A,0 88 10,50,6cd8a882376104fa1a7db8a66185bdda,NA,2,03,NA,01,2013-06-10,1020,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,7 269 aekey=4fa6c462785090999ee53dda8e790f96 patient_id=6705911a99c93a09ef5e605e8d9ced3b link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=010 arrivalage=50 pgpprac=6cd8a882376104fa1a7db8a66185bdda sitetret=NA aearrivalmode=2 aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2013-06-10 aearrivaltime=1020 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=172 NOTE: Invalid data for aerefsource in line 193 135-136. 193 dce87811af7410d8da414f4ac6e526cc,c6f1650922f49dadaeafa32b1aa44ec8,NHSNO,RXF,VALID,1,A,0 88 06,51,e7c400b0c9b7de3d6465d4525908c955,NA,2,02,NA,01,2013-06-03,1043,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,06,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,7 269 aekey=dce87811af7410d8da414f4ac6e526cc patient_id=c6f1650922f49dadaeafa32b1aa44ec8 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=006 arrivalage=51 pgpprac=e7c400b0c9b7de3d6465d4525908c955 sitetret=NA aearrivalmode=2 aeattenddisp=2 aerefsource=. aedepttype=1 aearrivaldate=2013-06-03 aearrivaltime=1043 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=6 treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=192 NOTE: Invalid data for aerefsource in line 217 135-136. 217 9259308a816651f1653decb5c8356120,c2ccb86eb8388c2e2ba60493c7644f45,NHSNO,RXF,VALID,2,J,0 88 12,51,51c5f674fc8d4674054fc56574548648,NA,2,02,NA,01,2013-06-07,0916,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,7 269 aekey=9259308a816651f1653decb5c8356120 patient_id=c2ccb86eb8388c2e2ba60493c7644f45 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=J activage=012 arrivalage=51 pgpprac=51c5f674fc8d4674054fc56574548648 sitetret=NA aearrivalmode=2 aeattenddisp=2 aerefsource=. aedepttype=1 aearrivaldate=2013-06-07 aearrivaltime=916 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=216 NOTE: Invalid data for aerefsource in line 246 135-136. 246 a4cb4e4db32fd7185ea8e1ff02fa9e1f,5d05514d5b99ae9e48613898e27bfff0,NHSNO,RXF,VALID,1,A,0 88 14,54,9154441d92dae912d6da058c3c248436,NA,2,03,NA,01,2013-06-11,1006,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,10,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,10 270 aekey=a4cb4e4db32fd7185ea8e1ff02fa9e1f patient_id=5d05514d5b99ae9e48613898e27bfff0 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=014 arrivalage=54 pgpprac=9154441d92dae912d6da058c3c248436 sitetret=NA aearrivalmode=2 aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2013-06-11 aearrivaltime=1006 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=10 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=10 _ERROR_=1 _N_=245 NOTE: Invalid data for aerefsource in line 275 135-136. 275 d4ef30652024954e940430e6c8168173,b61526b89a27cb586976500c94cf3838,NHSNO,RXF,VALID,2,A,0 88 16,48,a9658493c4ad50ca809e1bcda4570971,NA,2,02,NA,01,2013-06-07,0904,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,01,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,06,222,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,1 269 aekey=d4ef30652024954e940430e6c8168173 patient_id=b61526b89a27cb586976500c94cf3838 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=48 pgpprac=a9658493c4ad50ca809e1bcda4570971 sitetret=NA aearrivalmode=2 aeattenddisp=2 aerefsource=. aedepttype=1 aearrivaldate=2013-06-07 aearrivaltime=904 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=1 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=6 treat_02=222 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=1 _ERROR_=1 _N_=274 NOTE: Invalid data for invest_01 in line 292 196-197. NOTE: Invalid data for treat_01 in line 292 232-233. 292 5b29a19dc3bce9ad01c65fa6b725cf98,9deb2b941fbcf8b3cb425188b39ba5c2,NHSNO,RXF,VALID,1,A,0 88 16,16,d8febc1b8d18e84e87b5a5d515492b50,NA,2,12,07,01,2012-05-21,2032,01,NA,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,5 268 aekey=5b29a19dc3bce9ad01c65fa6b725cf98 patient_id=9deb2b941fbcf8b3cb425188b39ba5c2 link_method=NHSNO procodet=RXF postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=d8febc1b8d18e84e87b5a5d515492b50 sitetret=NA aearrivalmode=2 aeattenddisp=12 aerefsource=7 aedepttype=1 aearrivaldate=2012-05-21 aearrivaltime=2032 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=. invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=. treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=5 _ERROR_=1 _N_=291 NOTE: Invalid data for invest_01 in line 294 207-208. 294 8ea3531e28cd15997630c87db8359a21,3bd48a3d471d3154e11c5852d86397df,NHSNO,RFF,VALID,1,A,0 88 16,16,6fab353bff374f8a7f7dc7090941fe0a,RFFAA,2,03,08,01,2012-06-14,1509,02,S602,S509,S3 175 01,S009,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,30,222,511,NA,NA,NA 262 ,NA,NA,NA,NA,NA,NA,1 281 aekey=8ea3531e28cd15997630c87db8359a21 patient_id=3bd48a3d471d3154e11c5852d86397df link_method=NHSNO procodet=RFF postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=6fab353bff374f8a7f7dc7090941fe0a sitetret=RFFAA aearrivalmode=2 aeattenddisp=3 aerefsource=8 aedepttype=1 aearrivaldate=2012-06-14 aearrivaltime=1509 diag_scheme=2 diag_01=S602 diag_02=S5 diag_03=S3 diag_04=S0 diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=. invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=30 treat_02=222 treat_03=511 treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=1 _ERROR_=1 _N_=293 NOTE: Invalid data for aearrivalmode in line 307 133-134. 307 722d022f65999189432e699c299c27ea,619cff04338a21126ffe2f74a23129d8,NHSNO,RCD,VALID,1,A,0 88 16,16,12fab583c6f6be2a755ed9882e6a369f,RCD00,NA,03,03,01,2012-08-27,0852,01,NA,NA,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,8 273 aekey=722d022f65999189432e699c299c27ea patient_id=619cff04338a21126ffe2f74a23129d8 link_method=NHSNO procodet=RCD postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=12fab583c6f6be2a755ed9882e6a369f sitetret=RCD00 aearrivalmode=. aeattenddisp=3 aerefsource=3 aedepttype=1 aearrivaldate=2012-08-27 aearrivaltime=852 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=8 _ERROR_=1 _N_=306 NOTE: Invalid data for imd15decile_overall in line 329 271-272. 329 f7e0df9fb33b00d8911876e2edc57d73,e19d0e7c8ba2e2fd06958db169e212dd,NHSNO,RR8,VALID,2,A,0 88 16,16,411b928ccd78d70c4e9685533306c7b3,RR801,2,02,01,01,2012-03-18,1907,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,30,57,NA,NA,NA,NA,NA,NA,NA, 262 NA,NA,NA,NA 272 aekey=f7e0df9fb33b00d8911876e2edc57d73 patient_id=e19d0e7c8ba2e2fd06958db169e212dd link_method=NHSNO procodet=RR8 postcode_flag=VALID sex=2 ethnos=A activage=016 arrivalage=16 pgpprac=411b928ccd78d70c4e9685533306c7b3 sitetret=RR801 aearrivalmode=2 aeattenddisp=2 aerefsource=1 aedepttype=1 aearrivaldate=2012-03-18 aearrivaltime=1907 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=30 treat_02=57 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=. _ERROR_=1 _N_=328 NOTE: Invalid data for treat_01 in line 360 237-238. 360 01f56d7e49c37b5daca14fa4e99418f3,dab8d827b2b9d1bdd69758f40674c462,NHSNO,RAE,VALID,1,A,0 88 16,16,f9d800036dca88a9532e81c75335471d,RAE01,2,05,01,01,2012-01-11,1101,02,M799,NA,NA,N 175 A,NA,NA,NA,NA,NA,NA,NA,NA,01,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,5 273 aekey=01f56d7e49c37b5daca14fa4e99418f3 patient_id=dab8d827b2b9d1bdd69758f40674c462 link_method=NHSNO procodet=RAE postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=f9d800036dca88a9532e81c75335471d sitetret=RAE01 aearrivalmode=2 aeattenddisp=5 aerefsource=1 aedepttype=1 aearrivaldate=2012-01-11 aearrivaltime=1101 diag_scheme=2 diag_01=M799 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=1 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=. treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=5 _ERROR_=1 _N_=359 NOTE: Invalid data for treat_01 in line 362 237-238. 362 63b2a80c74f85fe5f4c3f28915f2d4c9,dab8d827b2b9d1bdd69758f40674c462,NHSNO,RAE,VALID,1,A,0 88 16,16,f9d800036dca88a9532e81c75335471d,RAE01,2,03,06,01,2012-10-13,2017,02,T143,NA,NA,N 175 A,NA,NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,1 273 aekey=63b2a80c74f85fe5f4c3f28915f2d4c9 patient_id=dab8d827b2b9d1bdd69758f40674c462 link_method=NHSNO procodet=RAE postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=f9d800036dca88a9532e81c75335471d sitetret=RAE01 aearrivalmode=2 aeattenddisp=3 aerefsource=6 aedepttype=1 aearrivaldate=2012-10-13 aearrivaltime=2017 diag_scheme=2 diag_01=T143 diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=1 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=. treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=1 _ERROR_=1 _N_=361 NOTE: Invalid data for treat_01 in line 374 239-240. 374 3a75e19d74ba98f5f6abf5ebb32aa0dc,4581b104a6647a12eca2bd8b022fcc2f,NHSNO,RAE,VALID,1,A,0 88 16,16,40d0a59e26967dbe78ef35e498be2827,RAE01,2,01,01,01,2016-03-04,0857,02,T141,L089,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,NA,03,05,14,04,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,NA,7 275 aekey=3a75e19d74ba98f5f6abf5ebb32aa0dc patient_id=4581b104a6647a12eca2bd8b022fcc2f link_method=NHSNO procodet=RAE postcode_flag=VALID sex=1 ethnos=A activage=016 arrivalage=16 pgpprac=40d0a59e26967dbe78ef35e498be2827 sitetret=RAE01 aearrivalmode=2 aeattenddisp=1 aerefsource=1 aedepttype=1 aearrivaldate=2016-03-04 aearrivaltime=857 diag_scheme=2 diag_01=T141 diag_02=L0 diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=3 invest_02=05 invest_03=14 invest_04=04 invest_05=01 invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=. treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=373 NOTE: Invalid data for aerefsource in line 400 139-140. 400 99a76aa7359fc351f6abb3b284821ad1,ede98159664225badf6f74d19546546c,NHSNO,RFR,VALID,1,99, 88 015,14,aebb64d34bef243560e5b04a8cc51656,RFRPA,2,03,NA,01,2012-07-12,1937,01,NA,NA,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,3 273 aekey=99a76aa7359fc351f6abb3b284821ad1 patient_id=ede98159664225badf6f74d19546546c link_method=NHSNO procodet=RFR postcode_flag=VALID sex=1 ethnos=9 activage=015 arrivalage=14 pgpprac=aebb64d34bef243560e5b04a8cc51656 sitetret=RFRPA aearrivalmode=2 aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2012-07-12 aearrivaltime=1937 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=1 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=3 _ERROR_=1 _N_=399 NOTE: Invalid data for aearrivalmode in line 403 133-134. 403 5b20cb5207efac16c346e0f238ac25f0,473935e03eb2861b9dcabbdd645e46c2,NHSNO,RCD,VALID,2,A,0 88 13,13,07c123a28f5a5dfb633db7007b1446ee,RCD00,NA,05,08,01,2012-11-23,0859,01,NA,NA,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,53,NA,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,7 272 aekey=5b20cb5207efac16c346e0f238ac25f0 patient_id=473935e03eb2861b9dcabbdd645e46c2 link_method=NHSNO procodet=RCD postcode_flag=VALID sex=2 ethnos=A activage=013 arrivalage=13 pgpprac=07c123a28f5a5dfb633db7007b1446ee sitetret=RCD00 aearrivalmode=. aeattenddisp=5 aerefsource=8 aedepttype=1 aearrivaldate=2012-11-23 aearrivaltime=859 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=53 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=402 NOTE: Invalid data for aearrivalmode in line 405 133-134. NOTE: Invalid data for aerefsource in line 405 139-140. 405 fc0532e8911629c0719ddbe61ca32cba,473935e03eb2861b9dcabbdd645e46c2,NHSNO,RCD,VALID,2,A,0 88 15,15,07c123a28f5a5dfb633db7007b1446ee,RCD00,NA,03,NA,01,2014-09-22,1727,01,NA,NA,NA,NA 175 ,NA,NA,NA,NA,NA,NA,NA,NA,01,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,222,NA,NA,NA,NA,NA,NA,NA,N 262 A,NA,NA,NA,7 273 aekey=fc0532e8911629c0719ddbe61ca32cba patient_id=473935e03eb2861b9dcabbdd645e46c2 link_method=NHSNO procodet=RCD postcode_flag=VALID sex=2 ethnos=A activage=015 arrivalage=15 pgpprac=07c123a28f5a5dfb633db7007b1446ee sitetret=RCD00 aearrivalmode=. aeattenddisp=3 aerefsource=. aedepttype=1 aearrivaldate=2014-09-22 aearrivaltime=1727 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=1 invest_02=NA invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=222 treat_02=NA treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=7 _ERROR_=1 _N_=404 NOTE: Invalid data for aeattenddisp in line 406 135-136. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 406 1cee00bf88465ac522fed6ac95772722,1794f12639335a737beafb1b90a757a5,NHSNO,RFR,VALID,1,A,0 88 13,13,e1b8ffb57ff16e542780088a4d840925,RFRPA,2,NA,01,01,2014-08-09,1502,01,NA,NA,NA,NA, 175 NA,NA,NA,NA,NA,NA,NA,NA,24,24,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,27,511,NA,NA,NA,NA,NA,NA,NA 262 ,NA,NA,NA,1 272 aekey=1cee00bf88465ac522fed6ac95772722 patient_id=1794f12639335a737beafb1b90a757a5 link_method=NHSNO procodet=RFR postcode_flag=VALID sex=1 ethnos=A activage=013 arrivalage=13 pgpprac=e1b8ffb57ff16e542780088a4d840925 sitetret=RFRPA aearrivalmode=2 aeattenddisp=. aerefsource=1 aedepttype=1 aearrivaldate=2014-08-09 aearrivaltime=1502 diag_scheme=1 diag_01=NA diag_02=NA diag_03=NA diag_04=NA diag_05=NA diag_06=NA diag_07=NA diag_08=NA diag_09=NA diag_10=NA diag_11=NA diag_12=NA invest_01=24 invest_02=24 invest_03=NA invest_04=NA invest_05=NA invest_06=NA invest_07=NA invest_08=NA invest_09=NA invest_10=NA invest_11=NA invest_12=NA treat_01=27 treat_02=511 treat_03=NA treat_04=NA treat_05=NA treat_06=NA treat_07=NA treat_08=NA treat_09=NA treat_10=NA treat_11=NA treat_12=NA imd15decile_overall=1 _ERROR_=1 _N_=405 NOTE: 1536914 records were read from the infile 'I:\cYorkshire Project\Care pathway for asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv'. The minimum record length was 237. The maximum record length was 322. NOTE: The data set WORK.AANDE has 1536914 observations and 55 variables. NOTE: DATA statement used (Total process time): real time 9.79 seconds cpu time 5.89 seconds Errors detected in submitted DATA step. Examine log. 1536914 rows created in WORK.AANDE from I:\cYorkshire Project\Care pathway for asthma\Sarwat\Data\Datasets\2019-04-01-ace\ACE_AE_20190401.csv.   ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 10.83 seconds cpu time 6.01 seconds }   Thanks ... View more

Re: difference-in-differences

by Quartz | Level 8 in Statistical Procedures
‎07-16-2019 11:57 AM
‎07-16-2019 11:57 AM
Actually I did that before posting the query on here.   It brings me to this forum where someone has posted a reply saying that either the model doesn't fit or the sample size is too small.   I am assuming my sample size is not too small (depending on what 'too small' means).   Not sure how to assess model fit?     So, I thought to post it on here.   Thanks. ... View more

Re: Summing data by ID

by Quartz | Level 8 in SAS Programming
‎07-16-2019 11:42 AM
‎07-16-2019 11:42 AM
Thanks Reza. ... View more

difference-in-differences

by Quartz | Level 8 in Statistical Procedures
‎07-16-2019 11:42 AM
‎07-16-2019 11:42 AM
Hi folks,   I am doing difference-in-differences analysis by using Proc Mixed as follow;   PROC MIXED DATA = diff1; CLASS POST EXPOSED; MODEL VISIT=POST|EXPOSED / SOLUTION ; LSMEANS POST|EXPOSED / DIFF; ESTIMATE 'D-I-D' EXPOSED*POST 1 -1 -1 1; REPEATED /SUBJECT=PKID TYPE=UN ; FORMAT EXPOSED STATUS. POST PERIOD.; TITLE2 "RANDOM INTERCEPT MODEL FOR PRE/POST GP Visits by EXPOSURE GROUP"; TITLE3 "UNADJUSTED: INCLUDING LEAST-SQUARES MEANS ESTIMATES"; RUN;   But I am getting the following log;   {334 PROC MIXED DATA = diff1; 335 CLASS POST EXPOSED; 336 MODEL VISIT=POST|EXPOSED / SOLUTION; 337 LSMEANS POST|EXPOSED / DIFF; 338 ESTIMATE 'D-I-D' EXPOSED*POST 1 -1 -1 1; 339 RANDOM INT/SUBJECT=PKID TYPE=UN ; 340 FORMAT EXPOSED STATUS. POST PERIOD.; 341 TITLE2 "RANDOM INTERCEPT MODEL FOR PRE/POST ADHERENCE by EXPOSURE GROUP"; 342 TITLE3 "UNADJUSTED: INCLUDING LEAST-SQUARES MEANS ESTIMATES"; 343 RUN; NOTE: Convergence criteria met but final Hessian is not positive definite. NOTE: PROCEDURE MIXED used (Total process time): real time 0.07 seconds cpu time 0.06 seconds }   And it's not giving any p-values in the output tables.   Can someone have a look and advise please?   Thanks ... View more

Re: CAN'T FIND OUT THE ERROR

by Quartz | Level 8 in SAS Programming
‎07-16-2019 07:32 AM
‎07-16-2019 07:32 AM
My csv has a long list of variables so I am pasting only the ones I am using in the analysis;   pkid         status                                Age            visit         Month4 1             InterventionGroup             73               1             -1 1             InterventionGroup             73               1             -1   When I run this; proc import datafile = 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv' out = DiffInDiff1 (where=(not (month4=0 or status='dropped out'))) dbms = csv; run;   Log is; { 1 proc import datafile = 'I:\cYorkshire Project\Supported self-care 1 ! intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv' 2 out = DiffInDiff1 (where=(not (month4=0 or status='dropped out'))) 3 dbms = csv; 4 run; 5 /********************************************************************** 6 * PRODUCT: SAS 7 * VERSION: 9.4 8 * CREATOR: External File Interface 9 * DATE: 16JUL19 10 * DESC: Generated SAS Datastep Code 11 * TEMPLATE SOURCE: (None Specified.) 12 ***********************************************************************/ 13 data WORK.DIFFINDIFF1 (where=(not (month4=0 or status='dropped out'))) ; 14 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 15 infile 'I:\cYorkshire Project\Supported self-care 15 ! intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv' delimiter = ',' 15 ! MISSOVER DSD lrecl=32767 firstobs=2 ; 16 informat Practice $25. ; 17 informat PKid best32. ; 18 informat Status $17. ; 19 informat Age best32. ; 20 informat ReadCodeID $5. ; 21 informat ReadCodeDesc $27. ; 22 informat EventDate yymmdd10. ; 23 informat EvTime $4. ; 24 informat ConsultationMethod $27. ; 25 informat EventStaffType $29. ; 26 informat ProfessionalContact $5. ; 27 informat GPVisitType $7. ; 28 informat Ethnicity $62. ; 29 informat Marital_status $15. ; 30 informat Religion $4. ; 31 informat Sex $6. ; 32 informat PartPcode $4. ; 33 informat IMDScore best32. ; 34 informat FirstEFICalc best32. ; 35 informat LastEFICalc best32. ; 36 informat TotalDeficitsAtStart best32. ; 37 informat TotalDeficitsAtEnd best32. ; 38 informat FirstEfiScore $3. ; 39 informat LastEfiScore $3. ; 40 informat visit best32. ; 41 informat preint best32. ; 42 informat intervention best32. ; 43 informat postint best32. ; 44 informat month4 best32. ; 45 informat month best32. ; 46 informat month2 best32. ; 47 informat preintervention1 best32. ; 48 informat preintervention best32. ; 49 informat preintervention2 best32. ; 50 informat preintervention3 best32. ; 51 informat intervene best32. ; 52 informat postintervention1 best32. ; 53 informat postintervention best32. ; 54 informat postintervention2 best32. ; 55 informat postintervention3 best32. ; 56 informat month3 best32. ; 57 format Practice $25. ; 58 format PKid best12. ; 59 format Status $17. ; 60 format Age best12. ; 61 format ReadCodeID $5. ; 62 format ReadCodeDesc $27. ; 63 format EventDate yymmdd10. ; 64 format EvTime $4. ; 65 format ConsultationMethod $27. ; 66 format EventStaffType $29. ; 67 format ProfessionalContact $5. ; 68 format GPVisitType $7. ; 69 format Ethnicity $62. ; 70 format Marital_status $15. ; 71 format Religion $4. ; 72 format Sex $6. ; 73 format PartPcode $4. ; 74 format IMDScore best12. ; 75 format FirstEFICalc best12. ; 76 format LastEFICalc best12. ; 77 format TotalDeficitsAtStart best12. ; 78 format TotalDeficitsAtEnd best12. ; 79 format FirstEfiScore $3. ; 80 format LastEfiScore $3. ; 81 format visit best12. ; 82 format preint best12. ; 83 format intervention best12. ; 84 format postint best12. ; 85 format month4 best12. ; 86 format month best12. ; 87 format month2 best12. ; 88 format preintervention1 best12. ; 89 format preintervention best12. ; 90 format preintervention2 best12. ; 91 format preintervention3 best12. ; 92 format intervene best12. ; 93 format postintervention1 best12. ; 94 format postintervention best12. ; 95 format postintervention2 best12. ; 96 format postintervention3 best12. ; 97 format month3 best12. ; 98 input 99 Practice $ 100 PKid 101 Status $ 102 Age 103 ReadCodeID $ 104 ReadCodeDesc $ 105 EventDate 106 EvTime $ 107 ConsultationMethod $ 108 EventStaffType $ 109 ProfessionalContact $ 110 GPVisitType $ 111 Ethnicity $ 112 Marital_status $ 113 Religion $ 114 Sex $ 115 PartPcode $ 116 IMDScore 117 FirstEFICalc 118 LastEFICalc 119 TotalDeficitsAtStart 120 TotalDeficitsAtEnd 121 FirstEfiScore $ 122 LastEfiScore $ 123 visit 124 preint 125 intervention 126 postint 127 month4 128 month 129 month2 130 preintervention1 131 preintervention 132 preintervention2 133 preintervention3 134 intervene 135 postintervention1 136 postintervention 137 postintervention2 138 postintervention3 139 month3 140 ; 141 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 142 run; NOTE: The infile 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv' is: Filename=I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv, RECFM=V,LRECL=32767,File Size (bytes)=1609336, Last Modified=05 July 2019 16:19:00, Create Time=05 July 2019 16:19:00 NOTE: 5638 records were read from the infile 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv'. The minimum record length was 229. The maximum record length was 328. NOTE: The data set WORK.DIFFINDIFF1 has 4488 observations and 41 variables. NOTE: DATA statement used (Total process time): real time 0.27 seconds cpu time 0.15 seconds 4488 rows created in WORK.DIFFINDIFF1 from I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv.   NOTE: WORK.DIFFINDIFF1 data set was successfully created. NOTE: The data set WORK.DIFFINDIFF1 has 4488 observations and 41 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.49 seconds cpu time 0.26 seconds }   Then I summed the 'visits' by 'pkid' as follows; proc means data=DiffInDiff1 noprint nway; class month4 status pkid / mlf; var visit; output out=SMPDiff sum(visit)=visit; run;   log; {143 proc means data=DiffInDiff1 noprint nway; 144 class month4 status pkid / mlf; 145 var visit; 146 output out=SMPDiff sum(visit)=visit; 147 run; NOTE: There were 4488 observations read from the data set WORK.DIFFINDIFF1. NOTE: The data set WORK.SMPDIFF has 443 observations and 6 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.02 seconds cpu time 0.01 seconds}   then I wanted to create new variables;   DATA DIFF1; SET SMPDIFF; IF MONTH4=1 THEN EXPOSED=1;*POST-INTERVENTION PERIOD; ELSE EXPOSED=0;*PRE-INTERVENTION PERIOD; IF STATUS="ELIGIBLE" THEN INTERVENTION=0; ELSE IF STATUS='INTERVENTIONGROUP' THEN INTERVENTION=1; RUN;   Log  { 148 DATA DIFF1; 149 SET SMPDIFF; 150 151 IF MONTH4=1 THEN EXPOSED=1;*POST-INTERVENTION PERIOD; 152 ELSE EXPOSED=0;*PRE-INTERVENTION PERIOD; 153 154 IF STATUS="ELIGIBLE" THEN INTERVENTION=0; 155 ELSE IF STATUS='INTERVENTIONGROUP' THEN INTERVENTION=1; 156 RUN; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 151:4 NOTE: There were 443 observations read from the data set WORK.SMPDIFF. NOTE: The data set WORK.DIFF1 has 443 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds }   but in the end ''INTERVENTION' has missing values for all observations.   Thanks ... View more

CAN'T FIND OUT THE ERROR

by Quartz | Level 8 in SAS Programming
‎07-16-2019 07:11 AM
‎07-16-2019 07:11 AM
Hi folks,   I am running the following programme;   To get rid of observations where 'status=dropped out' and month4=0, I write following in import proc;   proc import datafile = 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Control-groups\SMPcontrol.csv' out = DiffInDiff1 (where=(not (month4=0 or status='dropped out'))) dbms = csv; run;     Then to sum up observations per id by 'status' and 'month4' I do the following; proc means data=DiffInDiff1 noprint nway; class month4 status pkid / mlf; var visit; output out=SMPDiff sum(visit)=visit; run;   Then I want to create new variables from 'month4' and 'status'; DATA DIFF1; SET SMPDIFF; IF MONTH4=1 THEN EXPOSED=1;*POST-INTERVENTION PERIOD; ELSE EXPOSED=0;*PRE-INTERVENTION PERIOD; IF STATUS="ELIGIBLE" THEN INTERVENTION=0; ELSE IF STATUS='INTERVENTIONGROUP' THEN INTERVENTION=1; RUN;   But when I print this data set, 1) it still gives me 'dropped out' , 2) values for 'intervention' are all missing. can't figure out what the problem is!   Can someone help please?   Thanks S ... View more

Re: Summing data by ID

by Quartz | Level 8 in SAS Programming
‎07-16-2019 04:27 AM
‎07-16-2019 04:27 AM
Thanks Reza,   It worked perfectly fine! can I ask you another related question?   Where do I add other variables like age, sex etc. in this syntax to keep them in the data set as I will be using them in the adjusted models?   Appreciate your help!   ... View more

Summing data by ID

by Quartz | Level 8 in SAS Programming
‎07-15-2019 12:16 PM
‎07-15-2019 12:16 PM
Hi folks,   I have a data set as follows;   ID    Eventdate            practice           status  1      01/03/2016          SMP                Intervention 1      03/09/2016          SMP                Intervention 1      04/12/2016          SMP                Intervention 1      01/03/2017          SMP                Intervention 1      09/06/2017          SMP                Intervention 1      12/09/2017          SMP                Intervention 1      01/12/2017          SMP                Intervention 1      01/05/2018          SMP                Intervention 2      01/03/2016          BMP                Control 2      03/09/2016          BMP                Control 2      04/12/2016          BMP                Control 2      01/03/2017          BMP                Control 2      09/06/2017          BMP                Control 2      12/09/2017          BMP                Control   Where each EventDate represent a visit to health center.   I want to create a data set to perform difference-in-difference analysis using proc mixed for which I need total number of visits for each id by following three time periods; if EventDate<'01SEP2017'd then month4='-1';*pre-intervention; else if '01SEP2017'd <=EventDate<= '28FEB2018'd then month4='0';*intervention; else if EventDate >= '01MAR2018'd then month4='1';*post-intervention;     basically creating wide data set as follows; ID       Eventdate              practice          status           Total_visits_preintervention    Total_visits-Intervention  Total_Visits_postintervention   Can someone help how do I do that please?   Thanks S ... View more

Re: Means procedure

by Quartz | Level 8 in SAS Procedures
‎07-03-2019 11:25 AM
‎07-03-2019 11:25 AM
For each cell numerator is the number of visits and denominator is the number of discrete ids to be precise.   Thanks ... View more

Re: Means procedure

by Quartz | Level 8 in SAS Procedures
‎07-03-2019 11:23 AM
‎07-03-2019 11:23 AM
To elaborate;   Since month2 is coded from -3 to 3 (-3, -2,-1,0,1,2,3);   I would want total visits/discrete id for each time period by status like;                         -3             -2            -1                0               1         2          3 Eligible             2              1               0                0               0        0          0 Intervention      0             1              1               1.5             0         1          1      I have calculated each value (by hand) as follows;   Eligible             2/1=2      1/1=1       0                 0               0        0          0 Intervention      0             1/1=1       2/2=1         3/2=1.5     0       2/2=1    2/2=1    Don't know if there is an easy way of explaining it?   Thanks for your time  ... View more

Re: Means procedure

by Quartz | Level 8 in SAS Procedures
‎07-03-2019 11:07 AM
‎07-03-2019 11:07 AM
Ahhh now I understand;   here it is;   data sumSMP; input pkid visit month2 $ status $ 12.; datalines; 1           1        -3             eligible 1           1        -3             eligible 1           1        -2             eligible 1           1         0             eligible 2           1        -1            intervention 2           1         2            intervention 2           1         3            intervention 2           1         0            intervention 3           1         2            intervention 3           1        -1           intervention 3           1        -2           intervention 3           1         0           intervention 3           1         0           intervention 3           1         3           intervention 4           1         1           eligible 4            1        0           eligible ; run;   Hope I have understood correctly ... View more

Re: Means procedure

by Quartz | Level 8 in SAS Procedures
‎07-03-2019 10:43 AM
‎07-03-2019 10:43 AM
pkid      visit     month2    status 1           1        -3             eligible 1           1        -3             eligible 1           1        -2             eligible 1           1         0             eligible 2           1        -1            intervention 2           1         2            intervention 2           1         3            intervention 2           1         0            intervention 3           1         2            intervention 3           1        -1           intervention 3           1        -2           intervention 3           1         0           intervention 3           1         0           intervention 3           1         3           intervention   Month2 indicates my time periods which are 7 in total.   I ran sql which you'd suggested previously; proc sql; create table average as select pkid, avg(visitsum) as average from ( select pkid, month2, count(*) as visitsum from saltaire group by pkid, month2 ) group by pkid; quit;   it doesn't give me average number of visits per discrete id for each time period by 'status'.   Thanks for your help ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-21-2020 01:05 PM
Quick links