Was importing a comma-delimited csv file with 12,426 records and got the following log message. Could anyone help me understand the following messages in the log? 1. NOTE: Invalid data for ZIP in line 44 93-100. How can SAS detect it is an invalid data for ZIP variable? 2. I can see this temp data, MYDATA, in my WORK library. However, I can not proc print or see the contents of this data. Is it because the following error message below in my Question 3? 3. ERROR: Import unsuccessful. See SAS Log for details. I am not certain I understand this error message well. What caused the unsuccessful importing? (Log file begins) 1 2 PROC IMPORT DATAFILE = "D:\data\T_FIRM_176_20130121.csv" 3 OUT = MYDATA DBMS = CSV REPLACE; 4 DELIMITER = ','; 5 GETNAMES = YES; 6 RUN; 7 /********************************************************************** 8 * PRODUCT: SAS 9 * VERSION: 9.4 10 * CREATOR: External File Interface 11 * DATE: 29APR16 12 * DESC: Generated SAS Datastep Code 13 * TEMPLATE SOURCE: (None Specified.) 14 ***********************************************************************/ 15 data WORK.MYDATA ; 16 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 17 infile D:\data\T_FIRM_176_20130121.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; 18 informat FIRM_ID best32. ; 19 informat FIRM_NAME $44. ; 20 informat CAPITAL_MGT best32. ; 21 informat SEEK $2. ; 22 informat INVEST_TYPE $4. ; 23 informat FOUNDED mmddyy10. ; 24 informat FOUND_YEAR best32. ; 25 informat COUNTY $16. ; 26 informat STREET1 $27. ; 27 informat STREET2 $30. ; 28 informat CITY $13. ; 29 informat STATE $2. ; 30 informat ZIP best32. ; 31 informat NATION $2. ; 32 informat AREA_CODE best32. ; 33 informat PHONE $13. ; 34 informat FAX $13. ; 35 informat E_MAIL $21. ; 36 informat WEBSITE $20. ; 37 informat METRO_REGION_CODE best32. ; 38 informat REGION_CODE $2. ; 39 informat WORLD_REGION_CODE1 $2. ; 40 informat WORLD_REGION_CODE2 $2. ; 41 informat FILE_COUNTRY $2. ; 42 informat FILE_TYPE $2. ; 43 format FIRM_ID best12. ; 44 format FIRM_NAME $44. ; 45 format CAPITAL_MGT best12. ; 46 format SEEK $2. ; 47 format INVEST_TYPE $4. ; 48 format FOUNDED mmddyy10. ; 49 format FOUND_YEAR best12. ; 50 format COUNTY $16. ; 51 format STREET1 $27. ; 52 format STREET2 $30. ; 53 format CITY $13. ; 54 format STATE $2. ; 55 format ZIP best12. ; 56 format NATION $2. ; 57 format AREA_CODE best12. ; 58 format PHONE $13. ; 59 format FAX $13. ; 60 format E_MAIL $21. ; 61 format WEBSITE $20. ; 62 format METRO_REGION_CODE best12. ; 63 format REGION_CODE $2. ; 64 format WORLD_REGION_CODE1 $2. ; 65 format WORLD_REGION_CODE2 $2. ; 66 format FILE_COUNTRY $2. ; 67 format FILE_TYPE $2. ; 68 input 69 FIRM_ID 70 FIRM_NAME $ 71 CAPITAL_MGT 72 SEEK $ 73 INVEST_TYPE $ 74 FOUNDED 75 FOUND_YEAR 76 COUNTY $ 77 STREET1 $ 78 STREET2 $ 79 CITY $ 80 STATE $ 81 ZIP 82 NATION $ 83 AREA_CODE 84 PHONE $ 85 FAX $ 86 E_MAIL $ 87 WEBSITE $ 88 METRO_REGION_CODE 89 REGION_CODE $ 90 WORLD_REGION_CODE1 $ 91 WORLD_REGION_CODE2 $ 92 FILE_COUNTRY $ 93 FILE_TYPE $ 94 ; 95 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 96 run; NOTE: The infile 'M:\VC_Project\Gladiator\QA\Data\Source_Data\VC DATA\Thomson Venture Expert - Purchased\T_FIRM_176_20130121.csv' is: Filename=M:\VC_Project\Gladiator\QA\Data\Source_Data\VC DATA\Thomson Venture Expert - Purchased\T_FIRM_176_20130121.csv, RECFM=V,LRECL=32767,File Size (bytes)=2143969, Last Modified=26Oct2015:10:29:23, Create Time=21Apr2016:14:53:17 NOTE: Invalid data for ZIP in line 28 76-82. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-- 28 75614,Apex Ventures BV,8.4,AS,VC,1/1/2000,2000,,Liessentstraat 9A,,Uden,ZF,5405 AH,NT,, 88 31413243480,31413255738,ventures@apex.nl,,9999,ZF,EU,EW,US,VC 148 FIRM_ID=75614 FIRM_NAME=Apex Ventures BV CAPITAL_MGT=8.4 SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/2000 FOUND_YEAR=2000 COUNTY= STREET1=Liessentstraat 9A STREET2= CITY=Uden STATE=ZF ZIP=. NATION=NT AREA_CODE=. PHONE=31413243480 FAX=31413255738 E_MAIL=ventures@apex.nl WEBSITE= METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=27 NOTE: Invalid data for ZIP in line 44 93-100. 44 20203,Bankers Trust International,,IN,VC,1/1/1982,1982,,1 Appold Street,Broadgate,Londo 88 n,ZF,EC2A 2HE,UK,,44-20-7982-3728,44-20-7982-3318,,,9999,ZF,EU,EW,US,VC 158 FIRM_ID=20203 FIRM_NAME=Bankers Trust International CAPITAL_MGT=. SEEK=IN INVEST_TYPE=VC FOUNDED=01/01/1982 FOUND_YEAR=1982 COUNTY= STREET1=1 Appold Street STREET2=Broadgate CITY=London STATE=ZF ZIP=. NATION=UK AREA_CODE=. PHONE=44-20-7982-37 FAX=44-20-7982-33 E_MAIL= WEBSITE= METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=43 NOTE: Invalid data for ZIP in line 68 81-88. 68 98182,Seki Technotron Corp,,AS,VC,1/1/1948,1948,,5-6-30 Kiba` Koto-Ku,,Tokyo,ZF,135-004 88 2,JP,,813-3820-1711,813-3820-1735,,www.sekitech.com,9999,ZF,AS,SE,US,VC 158 FIRM_ID=98182 FIRM_NAME=Seki Technotron Corp CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/1948 FOUND_YEAR=1948 COUNTY= STREET1=5-6-30 Kiba` Koto-Ku STREET2= CITY=Tokyo STATE=ZF ZIP=. NATION=JP AREA_CODE=. PHONE=813-3820-1711 FAX=813-3820-1735 E_MAIL= WEBSITE=www.sekitech.com METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=67 NOTE: Invalid data for ZIP in line 72 72-78. 72 97249,DSM Venturing BV,,AS,VC,1/1/1902,1902,,Mauritslaan 49,,Urmond,ZF,6129 EL,NT,,3146 88 4763684,31455719753,info.venturing@dsm.com,www.dsm-venturing.com,9999,ZF,EU,EW,US,VC 171 FIRM_ID=97249 FIRM_NAME=DSM Venturing BV CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/1902 FOUND_YEAR=1902 COUNTY= STREET1=Mauritslaan 49 STREET2= CITY=Urmond STATE=ZF ZIP=. NATION=NT AREA_CODE=. PHONE=31464763684 FAX=31455719753 E_MAIL=info.venturing@dsm.co WEBSITE=www.dsm-venturing.co METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=71 NOTE: Invalid data for ZIP in line 74 94-100. 74 120668,Middlefield Ventures,,AS,VC,1/1/1984,1984,,First Canadian Place,58th Floor,Toron 88 to,ON,M5X 1A6,CA,416,4163620714,4163627925,invest@middlefield.com,www.middlefield.com,9 175 999,CN,AA,AA,US,VC 192 FIRM_ID=120668 FIRM_NAME=Middlefield Ventures CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/1984 FOUND_YEAR=1984 COUNTY= STREET1=First Canadian Place STREET2=58th Floor CITY=Toronto STATE=ON ZIP=. NATION=CA AREA_CODE=416 PHONE=4163620714 FAX=4163627925 E_MAIL=invest@middlefield.co WEBSITE=www.middlefield.com METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=73 NOTE: Invalid data for ZIP in line 88 83-90. 88 20719,Eiken Chemical` Ltd.,,IN,VC,2/20/1939,1939,,1-33-8 Hongo,Bonkyo-Ku,Tokyo,ZF,113-8 88 408,JP,,81-3-3813-5405,81-3-3813-2206,,www.eiken.co.jp,9999,ZF,AS,SE,US,VC 161 FIRM_ID=20719 FIRM_NAME=Eiken Chemical` Ltd. CAPITAL_MGT=. SEEK=IN INVEST_TYPE=VC FOUNDED=02/20/1939 FOUND_YEAR=1939 COUNTY= STREET1=1-33-8 Hongo STREET2=Bonkyo-Ku CITY=Tokyo STATE=ZF ZIP=. NATION=JP AREA_CODE=. PHONE=81-3-3813-540 FAX=81-3-3813-220 E_MAIL= WEBSITE=www.eiken.co.jp METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=87 NOTE: Invalid data for ZIP in line 94 85-92. 94 120861,UFJ Capital Co.` Ltd.,,IN,VC,1/1/1984,1984,,2-14-1 Kyobashi,Chuo-ku,Tokyo,ZF,104 88 -0031,JP,,,,,www.ufjcapital.co.jp,9999,ZF,AS,SE,US,VC 140 FIRM_ID=120861 FIRM_NAME=UFJ Capital Co.` Ltd. CAPITAL_MGT=. SEEK=IN INVEST_TYPE=VC FOUNDED=01/01/1984 FOUND_YEAR=1984 COUNTY= STREET1=2-14-1 Kyobashi STREET2=Chuo-ku CITY=Tokyo STATE=ZF ZIP=. NATION=JP AREA_CODE=. PHONE= FAX= E_MAIL= WEBSITE=www.ufjcapital.co.jp METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=93 NOTE: Invalid data for ZIP in line 106 106-111. 106 282226,EcomPark Inc.,,AS,VC,1/1/2009,2009,,BCE Place` 181 Bay Street,Suite 3100` P.O. B 88 ox 830,Toronto,ON,M5J2T3,CA,416,416-216-0822,416-216-0823,,,9999,CN,AA,AA,US,VC 166 FIRM_ID=282226 FIRM_NAME=EcomPark Inc. CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/2009 FOUND_YEAR=2009 COUNTY= STREET1=BCE Place` 181 Bay Street STREET2=Suite 3100` P.O. Box 830 CITY=Toronto STATE=ON ZIP=. NATION=CA AREA_CODE=416 PHONE=416-216-0822 FAX=416-216-0823 E_MAIL= WEBSITE= METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=105 NOTE: Invalid data for ZIP in line 110 80-86. 110 35381,NPM Capital NV,921.3,AS,PE,1/1/1948,1948,,Breitnerstraat 1,,Amsterdam,ZF,1077 BL, 88 NT,,31205705555,31204706454,mails@npm-capital.com,www.npm-capital.com,9999,ZF,EU,EW,US, 175 VC 176 FIRM_ID=35381 FIRM_NAME=NPM Capital NV CAPITAL_MGT=921.3 SEEK=AS INVEST_TYPE=PE FOUNDED=01/01/1948 FOUND_YEAR=1948 COUNTY= STREET1=Breitnerstraat 1 STREET2= CITY=Amsterdam STATE=ZF ZIP=. NATION=NT AREA_CODE=. PHONE=31205705555 FAX=31204706454 E_MAIL=mails@npm-capital.com WEBSITE=www.npm-capital.com METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=109 NOTE: Invalid data for ZIP in line 113 106-112. 113 94297,Serome Technology` Inc,,DE,VC,1/1/1993,1993,,666-14` Bae-gang B/D,Shinsa-dong` Ka 88 ngnam-gu,Seoul,ZF,135 120,SK,,822-2056-7800,822-517-4234,business@serome.co.kr,www.sero 175 me.co.kr,9999,ZF,AS,SE,US,VC 202 FIRM_ID=94297 FIRM_NAME=Serome Technology` Inc CAPITAL_MGT=. SEEK=DE INVEST_TYPE=VC FOUNDED=01/01/1993 FOUND_YEAR=1993 COUNTY= STREET1=666-14` Bae-gang B/D STREET2=Shinsa-dong` Kangnam-gu CITY=Seoul STATE=ZF ZIP=. NATION=SK AREA_CODE=. PHONE=822-2056-7800 FAX=822-517-4234 E_MAIL=business@serome.co.kr WEBSITE=www.serome.co.kr METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=112 NOTE: Invalid data for ZIP in line 124 84-90. 124 312322,Spinnaker Capital Group,,AS,VC,1/1/2010,2010,,6 Grosvenor Street,,London,ZF,W1K 88 4DJ,UK,,44-20-7903-2900,44-20-7903-2999,,www.spinnakercapital.com,9999,ZF,EU,EW,US,VC 172 FIRM_ID=312322 FIRM_NAME=Spinnaker Capital Group CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/2010 FOUND_YEAR=2010 COUNTY= STREET1=6 Grosvenor Street STREET2= CITY=London STATE=ZF ZIP=. NATION=UK AREA_CODE=. PHONE=44-20-7903-29 FAX=44-20-7903-29 E_MAIL= WEBSITE=www.spinnakercapital METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=123 NOTE: Invalid data for ZIP in line 126 103-108. 126 280800,Emerging ISV Capital Partners,,AS,VC,1/1/2009,2009,,179 Riverview Circle Southea 88 st,,Calgary,AB,T2C4J9,CA,403,4035605469,,info@emergingisv.com,www.emergingisv.com,9999, 175 CN,AA,AA,US,VC 188 FIRM_ID=280800 FIRM_NAME=Emerging ISV Capital Partners CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/2009 FOUND_YEAR=2009 COUNTY= STREET1=179 Riverview Circle Southe STREET2= CITY=Calgary STATE=AB ZIP=. NATION=CA AREA_CODE=403 PHONE=4035605469 FAX= E_MAIL=info@emergingisv.com WEBSITE=www.emergingisv.com METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=125 NOTE: Invalid data for ZIP in line 145 119-125. 145 65183,GVFL` Ltd.,34.6,AS,VC,7/2/1990,1990,,B/h Popular House` Ashram Road,1st Flr` Prem 88 chand House Annex,Ahmedabad,ZF,380 009,IN,,9.1794E+11,9.17927E+11,info@gvfl.com,www.gvf 175 l.com,9999,ZF,AS,SS,US,VC 199 FIRM_ID=65183 FIRM_NAME=GVFL` Ltd. CAPITAL_MGT=34.6 SEEK=AS INVEST_TYPE=VC FOUNDED=07/02/1990 FOUND_YEAR=1990 COUNTY= STREET1=B/h Popular House` Ashram R STREET2=1st Flr` Premchand House Annex CITY=Ahmedabad STATE=ZF ZIP=. NATION=IN AREA_CODE=. PHONE=9.1794E+11 FAX=9.17927E+11 E_MAIL=info@gvfl.com WEBSITE=www.gvfl.com METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SS FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=144 NOTE: Invalid data for ZIP in line 194 89-95. 194 59547,Beamscope Canada` Inc.,,DE,VC,1/1/1997,1997,,35 Ironside Crescent,,Scarborough,ON 88 ,M1X 1G5,CA,416,416-291-0000,,,,9999,CN,AA,AA,US,VC 138 FIRM_ID=59547 FIRM_NAME=Beamscope Canada` Inc. CAPITAL_MGT=. SEEK=DE INVEST_TYPE=VC FOUNDED=01/01/1997 FOUND_YEAR=1997 COUNTY= STREET1=35 Ironside Crescent STREET2= CITY=Scarborough STATE=ON ZIP=. NATION=CA AREA_CODE=416 PHONE=416-291-0000 FAX= E_MAIL= WEBSITE= METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=193 NOTE: Invalid data for ZIP in line 196 112-118. 196 92884,Nextlink` Ltd.,,AS,VC,2/1/1994,1994,,710 Techno Park #145,Yatap-dong` Bungdang-gu 88 ,Sungnam` Gyunggi-do,ZF,463-760,SK,,82-31-737-6060,82-31-737-6263,,www.nextlink.co.kr,9 175 999,ZF,AS,SE,US,VC 192 FIRM_ID=92884 FIRM_NAME=Nextlink` Ltd. CAPITAL_MGT=. SEEK=AS INVEST_TYPE=VC FOUNDED=02/01/1994 FOUND_YEAR=1994 COUNTY= STREET1=710 Techno Park #145 STREET2=Yatap-dong` Bungdang-gu CITY=Sungnam` Gyun STATE=ZF ZIP=. NATION=SK AREA_CODE=. PHONE=82-31-737-606 FAX=82-31-737-626 E_MAIL= WEBSITE=www.nextlink.co.kr METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=195 NOTE: Invalid data for ZIP in line 203 102-108. 203 243606,BC Advantage Funds` Ltd.,0.094,AS,VC,1/1/2004,2004,,221 West Esplanade,Suite 410 88 ,Vancouver,BC,V7M 3J3,CA,604,6046886877,6046886166,info@bcaf.ca,www.bcadvantagefunds.co 175 m,9999,CN,AA,AA,US,VC 195 FIRM_ID=243606 FIRM_NAME=BC Advantage Funds` Ltd. CAPITAL_MGT=0.094 SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/2004 FOUND_YEAR=2004 COUNTY= STREET1=221 West Esplanade STREET2=Suite 410 CITY=Vancouver STATE=BC ZIP=. NATION=CA AREA_CODE=604 PHONE=6046886877 FAX=6046886166 E_MAIL=info@bcaf.ca WEBSITE=www.bcadvantagefunds METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=202 NOTE: Invalid data for ZIP in line 206 104-111. 206 98709,August Equity LLP,487.3,AS,BO,10/1/2001,2001,,10 Slingsby Place,St. Martin's Cour 88 tyard,London,ZF,WC2E 9AB,UK,,4.42076E+11,4.42076E+11,info@augustequity.com,www.augusteq 175 uity.com,9999,ZF,EU,EW,US,VC 202 FIRM_ID=98709 FIRM_NAME=August Equity LLP CAPITAL_MGT=487.3 SEEK=AS INVEST_TYPE=BO FOUNDED=10/01/2001 FOUND_YEAR=2001 COUNTY= STREET1=10 Slingsby Place STREET2=St. Martin's Courtyard CITY=London STATE=ZF ZIP=. NATION=UK AREA_CODE=. PHONE=4.42076E+11 FAX=4.42076E+11 E_MAIL=info@augustequity.com WEBSITE=www.augustequity.com METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EW FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=205 NOTE: Invalid data for ZIP in line 237 83-90. 237 22008,Sharp Corporation,,IN,VC,1/1/1985,1985,,22-22 Nagaike-cho,Abeno-ku,Osaka,ZF,545-8 88 522,JP,,81-6-6621-1221,,,sharp-world.com,9999,ZF,AS,SE,US,VC 147 FIRM_ID=22008 FIRM_NAME=Sharp Corporation CAPITAL_MGT=. SEEK=IN INVEST_TYPE=VC FOUNDED=01/01/1985 FOUND_YEAR=1985 COUNTY= STREET1=22-22 Nagaike-cho STREET2=Abeno-ku CITY=Osaka STATE=ZF ZIP=. NATION=JP AREA_CODE=. PHONE=81-6-6621-122 FAX= E_MAIL= WEBSITE=sharp-world.com METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=AS WORLD_REGION_CODE2=SE FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=236 NOTE: Invalid data for ZIP in line 238 94-99. 238 77477,Odlander` Fredrikson & Co. AB,1121.8,AS,VC,1/1/1996,1996,,Strandvagen 5B,,Stockho 88 lm,ZF,114 51,SW,,4684425850,4684425879,,www.healthcap.se,9999,ZF,EU,EN,US,VC 163 FIRM_ID=77477 FIRM_NAME=Odlander` Fredrikson & Co. AB CAPITAL_MGT=1121.8 SEEK=AS INVEST_TYPE=VC FOUNDED=01/01/1996 FOUND_YEAR=1996 COUNTY= STREET1=Strandvagen 5B STREET2= CITY=Stockholm STATE=ZF ZIP=. NATION=SW AREA_CODE=. PHONE=4684425850 FAX=4684425879 E_MAIL= WEBSITE=www.healthcap.se METRO_REGION_CODE=9999 REGION_CODE=ZF WORLD_REGION_CODE1=EU WORLD_REGION_CODE2=EN FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=237 NOTE: Invalid data for ZIP in line 279 77-83. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 279 33782,Gestion BioCapital Inc.,,IN,VC,1/1/1995,1995,,,Bureau 910,Montreal,ON,H7T 2S3,CA, 88 514,514-847-5750,514-687-9283,,,9999,CN,AA,AA,US,VC 138 FIRM_ID=33782 FIRM_NAME=Gestion BioCapital Inc. CAPITAL_MGT=. SEEK=IN INVEST_TYPE=VC FOUNDED=01/01/1995 FOUND_YEAR=1995 COUNTY= STREET1= STREET2=Bureau 910 CITY=Montreal STATE=ON ZIP=. NATION=CA AREA_CODE=514 PHONE=514-847-5750 FAX=514-687-9283 E_MAIL= WEBSITE= METRO_REGION_CODE=9999 REGION_CODE=CN WORLD_REGION_CODE1=AA WORLD_REGION_CODE2=AA FILE_COUNTRY=US FILE_TYPE=VC _ERROR_=1 _N_=278 NOTE: 12425 records were read from the infile 'MD:\data\T_FIRM_176_20130121.csv'. The minimum record length was 64. The maximum record length was 271. NOTE: The data set WORK.MYDATA has 12425 observations and 25 variables. NOTE: DATA statement used (Total process time): real time 0.27 seconds cpu time 0.12 seconds Errors detected in submitted DATA step. Examine log. 12425 rows created in WORK.MYDATA from D:\data\T_FIRM_176_20130121.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 0.59 seconds cpu time 0.23 seconds (Log file ends)
... View more