Hi tried to import attached csv file i'm able to import data but its not comping in proper way attached input csv and output csv file log 1 data WORK.CUSTOMER ; 2 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 3 infile 'C:\Users\Training5\Desktop\New folder\Customers.csv' delimiter = ',' MISSOVER DSD 3 ! lrecl=32767 firstobs=2 ; 4 informat CustomerID $4.; 5 informat CompanyName $28. ; 6 informat ContactName $28. ; 7 informat City $16. ; 8 informat Country $12. ; 9 informat DivisionID best32. ; 10 informat Address $50. ; 11 informat Fax $18. ; 12 informat Phone $18. ; 13 informat PostalCode $10. ; 14 informat StateProvince $2. ; 15 format CustomerID $4. ; 16 format CompanyName $28. ; 17 format ContactName $28. ; 18 format City $16. ; 19 format Country $12. ; 20 format DivisionID best12. ; 21 format Address $50. ; 22 format Fax $18. ; 23 format Phone $18. ; 24 format PostalCode $10. ; 25 format StateProvince $2. ; 26 input 27 CustomerID $ 28 CompanyName $ 29 ContactName $ 30 City $ 31 Country $ 32 DivisionID 33 Address $@ 34 Fax $ - 22 ERROR 22-322: Expecting a name. 35 Phone $ 36 PostalCode $ 37 StateProvince $ 38 ; 39 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 40 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.CUSTOMER may be incomplete. When this step was stopped there were 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.19 seconds cpu time 0.01 seconds 41 data WORK.CUSTOMER ; 42 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 43 infile 'C:\Users\Training5\Desktop\New folder\Customers.csv' delimiter = ',' MISSOVER DSD 43 ! lrecl=32767 firstobs=2 ; 44 informat CustomerID $4.; 45 informat CompanyName $28. ; 46 informat ContactName $28. ; 47 informat City $16. ; 48 informat Country $12. ; 49 informat DivisionID best32. ; 50 informat Address $50. ; 51 informat Fax $18. ; 52 informat Phone $18. ; 53 informat PostalCode $10. ; 54 informat StateProvince $2. ; 55 format CustomerID $4. ; 56 format CompanyName $28. ; 57 format ContactName $28. ; 58 format City $16. ; 59 format Country $12. ; 60 format DivisionID best12. ; 61 format Address $50. ; 62 format Fax $18. ; 63 format Phone $18. ; 64 format PostalCode $10. ; 65 format StateProvince $2. ; 66 input 67 CustomerID $ 68 CompanyName $ 69 ContactName $ 70 City $ 71 Country $ 72 DivisionID 73 Address $ 74 Fax $ 75 Phone $ 76 PostalCode $ 77 StateProvince $ 78 ; 79 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 80 run; NOTE: The infile 'C:\Users\Training5\Desktop\New folder\Customers.csv' is: Filename=C:\Users\Training5\Desktop\New folder\Customers.csv, RECFM=V,LRECL=32767,File Size (bytes)=9630, Last Modified=07Mar2017:07:29:42, Create Time=07Mar2017:07:29:37 NOTE: 100 records were read from the infile 'C:\Users\Training5\Desktop\New folder\Customers.csv'. The minimum record length was 33. The maximum record length was 135. NOTE: The data set WORK.CUSTOMER has 100 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.10 seconds cpu time 0.04 seconds
... View more