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 save with the early bird rate—just $795!
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.