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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 808 views
  • 0 likes
  • 3 in conversation