Hi folks, I am importing a data file using proc import. Although the log says the new data set has been created successfully, it also give a long message on the log window as follows; 1 proc import datafile = 'I:\cYorkshire Project\Supported self-care 1 ! intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv' 2 out = demo 3 dbms = csv; 4 run; 5 /********************************************************************** 6 * PRODUCT: SAS 7 * VERSION: 9.4 8 * CREATOR: External File Interface 9 * DATE: 26JUN19 10 * DESC: Generated SAS Datastep Code 11 * TEMPLATE SOURCE: (None Specified.) 12 ***********************************************************************/ 13 data WORK.DEMO ; 14 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 15 infile 'I:\cYorkshire Project\Supported self-care 15 ! intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv' delimiter = ',' MISSOVER DSD 15 ! lrecl=32767 firstobs=2 ; 16 informat pkid best32. ; 17 informat Practice $24. ; 18 informat Age best32. ; 19 informat Status $8. ; 20 informat Ethnicity $62. ; 21 informat Marital_status $29. ; 22 informat Religion $22. ; 23 informat Sex $6. ; 24 informat PartPcode $4. ; 25 informat IMDScore best32. ; 26 informat FirstEFICalc best32. ; 27 informat LastEFICalc best32. ; 28 informat TotalDeficitsAtStart best32. ; 29 informat TotalDeficitsAtEnd best32. ; 30 informat FirstEfiScore $3. ; 31 informat LastEfiScore $8. ; 32 format pkid best12. ; 33 format Practice $24. ; 34 format Age best12. ; 35 format Status $8. ; 36 format Ethnicity $62. ; 37 format Marital_status $29. ; 38 format Religion $22. ; 39 format Sex $6. ; 40 format PartPcode $4. ; 41 format IMDScore best12. ; 42 format FirstEFICalc best12. ; 43 format LastEFICalc best12. ; 44 format TotalDeficitsAtStart best12. ; 45 format TotalDeficitsAtEnd best12. ; 46 format FirstEfiScore $3. ; 47 format LastEfiScore $8. ; 48 input 49 pkid 50 Practice $ 51 Age 52 Status $ 53 Ethnicity $ 54 Marital_status $ 55 Religion $ 56 Sex $ 57 PartPcode $ 58 IMDScore 59 FirstEFICalc 60 LastEFICalc 61 TotalDeficitsAtStart 62 TotalDeficitsAtEnd 63 FirstEfiScore $ 64 LastEfiScore $ 65 ; 66 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 67 run; NOTE: The infile 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv' is: Filename=I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv, RECFM=V,LRECL=32767,File Size (bytes)=67644, Last Modified=17 June 2019 11:49:29, Create Time=17 June 2019 11:49:30 NOTE: 409 records were read from the infile 'I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv'. The minimum record length was 92. The maximum record length was 219. NOTE: The data set WORK.DEMO has 409 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.06 seconds 409 rows created in WORK.DEMO from I:\cYorkshire Project\Supported self-care intervention\Sarwat\Data\SarwatSCP18052019\Demographics.csv. NOTE: WORK.DEMO data set was successfully created. NOTE: The data set WORK.DEMO has 409 observations and 16 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.82 seconds cpu time 0.14 seconds I am not sure if there is something wrong my import procedure or is this something I can ignore please? Appreciate your help and contribution towards this forum. S
... View more