I'm trying to read a raw data file with abbreviated currency values like: 1 Exxon Mobil United States $433.5B $41.1B $331.1B $407.4B 2 JPMorgan Chase United States $110.8B $19B $2,265.8B $170.1B Attached is actual raw data file. I cannot get the data in correctly...the following code is about as close to success as I have gotten: data BigCompanies; infile 'c:\projectdata\BigCompanies.dat'; input rank 3. company $ 6-31 country $ 35-49 @'$' sales dollar5.1 @'$' profits dollar5.1 @'$' assets dollar5.1 @'$' market dollar5.1; run; Struggling...thinking I must be making this harder than it needs to be and would appreciate any assistance.
... View more