topic Re: Base SAS Scenario in SAS Programming

Base SAS Scenario

Son_Of_Krypton — Mon, 20 Aug 2018 11:02:14 GMT

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

Huston 4350

PO BOX Huston 4350

4390

PO BOX 4390

Queens 7890

PO BOX Queens 7890

1245

PO BOX 1245

Re: Base SAS Scenario

Kurt_Bremser — Mon, 20 Aug 2018 11:06:18 GMT

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

Re: Base SAS Scenario

RW9 — Mon, 20 Aug 2018 11:07:29 GMT

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