topic read the address and write it in different column in ODS and Base Reporting

read the address and write it in different column

shru — Wed, 14 Mar 2012 03:43:23 GMT

Hi,

the data is,

shri

bengal

india

shety

India

and i want o/p as

name state country

shri bengal india

shety Ka india

How can i achieve this?

read the address and write it in different column

Haikuo — Wed, 14 Mar 2012 12:16:15 GMT

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

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

read the address and write it in different column

Astounding — Wed, 14 Mar 2012 12:26:31 GMT

Or simply:

data want;

length name country state $ 20;

input name & country & state &;

cards;

shri

bengal

india

shety

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.

read the address and write it in different column

ballardw — Wed, 14 Mar 2012 15:16:06 GMT

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;

Re: read the address and write it in different column

shru — Thu, 15 Mar 2012 16:46:36 GMT

Thanks

It workrd fine