Foolowing is the original csv file which I could open it in "R". fdate mgrname Country mgrno typecode rdate prdate 19990930 UNITED STATES TRUST CO OF NY UNITED STATES 89310 1 19990930 19990630 19990930 WEISS, PECK & GREER, L.L.C. UNITED STATES 91780 5 19990930 19990630 19990930 WORLD ASSET MANAGEMENT UNITED STATES 93830 5 19990930 19990630 19990930 BARCLAYS BANK PLC UNITED KINGDOM 7900 4 19990930 19990630 19990930 JMG CAPITAL PTNR LP UNITED STATES 48100 4 19990930 19990331 19990930 LEGG MASON WOOD WALKER, INC. UNITED STATES 50180 5 19990930 19990630 19990930 SSI INVESTMENT MANAGEMENT INC. UNITED STATES 81650 5 19990930 19990630 19990930 STROME SUSSKIND INV MGMT, L.P. UNITED STATES 82090 5 19990930 19990630 19990930 AMERICAN GENERAL CORPORATION UNITED STATES 2340 2 19990930 19990630 19990930 ARTISAN PTNR L.P. UNITED STATES 4719 5 19990930 19990630 19990930 BANK ONE CORPORATION UNITED STATES 5955 1 19990930 19990630 As you can see prdate is formated the same way as rdate. But, sas output is different.
... View more