read the address and write it in different column

[shru]

Hi,

the data is,

shri

bengal

india

shety

Ka

India

and i want o/p as

name   state   country

shri     bengal   india

shety  Ka        india

How can i achieve this?

[Haikuo · Accepted solution]

If your data always lays like this, and there is no missing rows, switching rows etc, you can try this array approach:

data have;

input var $20.;

cards;

shri

bengal

india

shety

Ka

India

;

data want (drop=var);

array v $ name state country;

do _n_=1 to 3;

set have;

v(_n_)=var;

end;

run;

proc print;run;

Regards,

Haikuo

[Astounding]

Or simply:

data want;

length name country state $ 20;

input name & country & state &;

cards;

shri

bengal

india

shety

Ka

India

;

The &s just allow an embedded blank to be part of the variable.  They are not necessary when you have no embedded blanks.

Good luck.

[ballardw]

Or

data want;

length name country state $ 20;

infile <your input filename or ref>;

input #1 name #2 country #3 state;

input; /* to skip blank line  assuming the pattern is consistent*/

run;

[shru]

Thanks

It workrd fine