Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Infile and showing data in correct columns

Status
Not open for further replies.

sap1958

Technical User
Oct 22, 2009
138
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top