How to Separate Address Values (SAS)

So you’re working with a data set, and one of the variable columns contains an address value structured such as:

303 SAS LANE, Cleveland, OH 1111

How would you format such data so that each part of the address has its own variable column? The following program will take care of it for you.

data DataSetB; /* New data set name */
set DataSetA; /* Old data set name */
Street=scan(Address,1 ,’,'); /* Creates a variable column for the street value */
City = scan(Address, -3); /* Creates a variable column for the city variable */
Zip=scan(Address,-1,' ‘); /* Creates a variable column for the zip variable */
State = scan(Address, -2); /* Creates a variable column for the state variable */
RUN;

The above program achieves its purpose through the utilization of the SCAN function. Below is a link that provides more information as to how the function can be successfully utilized.

SAS University Manual Topic: SCAN Function