BookmarkSubscribeRSS Feed
UPRETIGOPI
Obsidian | Level 7

Hi there

 

I have separate adrress fields like Address, City, State and Zipcode but I would like to create a single address fields by combining all these four fields into one field like : 1345 Quail Creek Ln, Alexandria, VA 22039

 

Address                              City                           State               Zipcode

1345 Quail Creek Ln           Alexandria                VA                  22039

4569 Foxhole Drive            Chantilly                    VA                  22033

 

Single address field I want to create is: 1345 Quail Creek Ln, Alexandria, VA 22039

                                                               4569 Foxhole Drive, Chantilly, VA 22033

 

I tried using CATX function like this

New_address = catx(',',Address,City,State,Zipcode); but it resolves into: 1345 Quail Creek LN,Alexandria,VA,22039

How do I insert space between two elements of the address separated by comma and just the space between state and ziocode as I have shown above ? Please help me. Thanks

 

3 REPLIES 3
Reeza
Super User

Put a space in the first parameter.

 

this_works = catx(", ", "first", "second");
put this_works;
UPRETIGOPI
Obsidian | Level 7

Thank you Ballardw. That wroks.

ballardw
Super User

Try:

New_address = catx(',',Address,City,catx(' ',State,Zipcode));

so the State and Zipcode are combined first with a space and thus treated as a single string by the outer CATX. For a somewhat older appearance you could use multiple spaces such as

catx('   ',State,Zipcode)

to have the zipcode a bit further from the state

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2256 views
  • 0 likes
  • 3 in conversation