The SAS Output Delivery System and reporting techniques

read the address and write it in different column

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

read the address and write it in different column

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?


Accepted Solutions
Solution
‎03-14-2012 08:16 AM
Respected Advisor
Posts: 3,156

read the address and write it in different column

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

View solution in original post


All Replies
Solution
‎03-14-2012 08:16 AM
Respected Advisor
Posts: 3,156

read the address and write it in different column

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

Super User
Posts: 5,497

read the address and write it in different column

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.

Super User
Posts: 11,343

read the address and write it in different column

Posted in reply to Astounding

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;

Contributor
Posts: 32

Re: read the address and write it in different column

Thanks

It workrd fine

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 423 views
  • 3 likes
  • 4 in conversation