topic Re: How to append multiple columns into a column (with many rows) ? in SAS Enterprise Guide

How to append multiple columns into a column (with many rows) ?

cody_q — Fri, 15 Jun 2012 08:51:05 GMT

Hey all ,

I am working data set with a lot of columns more than 50 .
I would like to append all the content of the 50 columns into a column with many rows.

I have to use SAS EG to do it .

Anybody knows how to?

Thanks .

Cody

Re: How to append multiple columns into a column (with many rows) ?

Alpay — Fri, 15 Jun 2012 11:12:09 GMT

Can you provide some example data and the way you want to append the data?

Example:

Have:

Want:

Re: How to append multiple columns into a column (with many rows) ?

ChrisHemedinger — Fri, 15 Jun 2012 13:37:04 GMT

EG offers Data->Transpose (general) and Data->Stack Columns (specific for your case), but it's still a bit tricky to manage without a "recipe". I find Rick Wicklin's blog posts on transposing to be very helpful. Here's one about converting from wide to long.

Chris

Re: How to append multiple columns into a column (with many rows) ?

cody_q — Sat, 16 Jun 2012 15:18:53 GMT

Hi all ,

Thank you for your replies. Here's the "recipe". I hope it makes sense to you all.

F1 to F10 are the columns.

F1	F2	F3	F4	F5	F6	F7	F8	F9	F10
There	are	40	students	in	the	class	.	They	are
all	studying	for	Math	and	Science	.	They	have	learnt
valuable	lessons	from	the	Classes.	The	teachers	are	proud	of
them	.

Become to F1 as the only column with many rows.

There

are

students

the

class

They

are

all

studying

for

Math

and

Science.

They

have

learnt

valuable

lessons

from

the

classes.

The

teachers

are

proud

them

Thank you.

Re: How to append multiple columns into a column (with many rows) ?

Linlin — Sat, 16 Jun 2012 18:08:11 GMT

how about:

data have;

input (a1-a5) ($);

cards;

a b c d e f

g h i j k l

;

data want;

set have;

array _a(*) $ a1-a5;

do _n_=1 to dim(_a);

f1=_a(_n_);

output;

end;

keep f1;

proc print;run;

Linlin

Re: How to append multiple columns into a column (with many rows) ?

QLi — Tue, 19 Jun 2012 15:21:09 GMT

Try to use proc transpose and maybe work it out.

data have;

input Name $ Sex $ Age height weight;

cards;

alfred m 14 69 112.5

alice f 13 56.5 84

barbara f 13 65.3 98

;

run;

proc sort data=have out=have2; by name; run;

proc transpose data=have2 out=have_t;

by name;

var height weight age ; run;