BookmarkSubscribeRSS Feed
Son_Of_Krypton
Fluorite | Level 6

hi i have below programm

 

 
 

 

data Address;
input Address $30.;
cards;
Huston 4350
4390
Queens 7890
1245
;
run; 

 

Need Output like as follows

 

No           Address              New_Address
1Huston 4350  PO BOX Huston 4350 
24390            PO BOX 4390 
3Queens 7890PO BOX Queens 7890 
41245           PO BOX 1245
2 REPLIES 2
Kurt_Bremser
Super User
length new_address $37; * length of address + length of "PO BOX ";
new_address = 'PO BOX ' !! address;

Just a simple concatenation.

 


@Son_Of_Krypton wrote:

hi i have below programm

 

 
 

 

data Address;
input Address $30.;
cards;
Huston 4350
4390
Queens 7890
1245
;
run; 

 

Need Output like as follows

 

No           Address              New_Address
1 Huston 4350   PO BOX Huston 4350  
2 4390             PO BOX 4390  
3 Queens 7890 PO BOX Queens 7890  
4 1245            PO BOX 1245

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26
data address;
  length new_addres $200;
  input address $30.;
  new_address=catx(" ","PO BOX",address);
cards;
Huston 4350
4390
Queens 7890
1245
;
run;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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.

SAS Training: Just a Click Away

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

Browse our catalog!

Discussion stats
  • 2 replies
  • 1033 views
  • 0 likes
  • 3 in conversation