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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.