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.
data have;
infile '/folders/myfolders/BigCompanies.txt' truncover expandtabs;
input rank company & $40. country & $40.
(_sales _profits _assets _market) (: $40.) ;
sales =input(compress(_sales,'B'),dollar32.);
profits =input(compress(_profits ,'B'),dollar32.);
assets =input(compress(_assets ,'B'),dollar32.);
market =input(compress(_market ,'B'),dollar32.);
drop _:;
run;
data have;
infile '/folders/myfolders/BigCompanies.txt' truncover expandtabs;
input rank company & $40. country & $40.
(_sales _profits _assets _market) (: $40.) ;
sales =input(compress(_sales,'B'),dollar32.);
profits =input(compress(_profits ,'B'),dollar32.);
assets =input(compress(_assets ,'B'),dollar32.);
market =input(compress(_market ,'B'),dollar32.);
drop _:;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.