hi i have below programm
data Address;
input Address $30.;
cards;
Huston 4350
4390
Queens 7890
1245
;
run;
Need Output like as follows
1 | Huston 4350 | PO BOX Huston 4350 |
2 | 4390 | PO BOX 4390 |
3 | Queens 7890 | PO BOX Queens 7890 |
4 | 1245 | PO BOX 1245 |
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
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.