data news;
length Company $20;
infile 'v:\topNews.txt';
input rank Company $ City $ Circulation;
run;
present output example;
1. USA Today (Arlington, Va.) 2,528,437
2. Wall Street Journal (New York, N.Y.) 2,058,342
desired output example;
rank Company City Circulation
1. USA Today Arlington VA 2,528,437
2. Wall Street Journal New York N Y 2,058,342
Major issues include getting all of company to show and to show the City without "( )"
How can I rewrite the program?
length Company $20;
infile 'v:\topNews.txt';
input rank Company $ City $ Circulation;
run;
present output example;
1. USA Today (Arlington, Va.) 2,528,437
2. Wall Street Journal (New York, N.Y.) 2,058,342
desired output example;
rank Company City Circulation
1. USA Today Arlington VA 2,528,437
2. Wall Street Journal New York N Y 2,058,342
Major issues include getting all of company to show and to show the City without "( )"
How can I rewrite the program?