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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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