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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
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!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.