Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. in sas, how do i extract the city, state, and zipc

In SAS, how do I extract the city, state, and zipcode into separate columns from a...

60.1K

Verified Solution

Question

Statistics

In SAS, how do I extract the city, state, and zipcode intoseparate columns from a single variable with all three?

Example-

Bremen, KS, 66412

Little River, KS, 67457

Bird City, KS, 67731

The above is stored in one variable each. But I want to makethree separate variables with it. Some cities also have two wordsin it.

Answer & Explanation Solved by verified expert
4.0 Ratings (856 Votes)
SolutionProgramm In SASRead the data and store in one datasetsdata testinfile cards dlminput    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

QUESTION 3The XYZ partnership has been operating for several years. All ofits assets were...QUESTION...

Chemistry
1.2K views

1 a. A buffer solution is prepared by placing 5.86 grams of sodium nitrite and 32.6...

Physics
1.2K views

Two wires made of different materials have the same uniform current density They carry the...

Algebra
1.2K views

Consider the following poly f x x 2 x 3 Step 2 of 3 Find...

Algebra
1.2K views

Express tan O as a fraction in simplest terms M 12 13 O

Algebra
1.2K views

Find the x and y intercepts of the following and graph 5x 4y 20

Accounting
1.2K views

CPI sells computer peripherals. At December 31, year 1, CPI's Inventory amounted to $690,000. Durling...

Accounting
1.2K views

Which of the following transactions would increase the equity of a company? a)...

Accounting
1.2K views

Tamar Company manufactures a single product in two departments: Forming and Assembly. Information for the...

Accounting
1.2K views

What is the federal treatment of exempt interest dividends reported on form 1099 DIV dividends...

Finance
1.2K views

A project has an initial cost of $52,450, expected net cash inflows of $14,000 per...

Finance
1.2K views

HMK Enterprises would like to raise $10.0 million to invest in capital expenditures. The company...