Coding Question

[deleted_user]

Hi All!!

I'm presently taking a listing of ID(account) numbers , then appending emails to this listing via db links etc.

The return I get back lists out each email individually, hence many lines with the same account #

ie: my list was originally say 2,600 records.

Now its 34,000

Is there a way I can then code to collapse the accounts to a single line and just list out the numerous emails on the same line.

Output will be a csv.


Many Thanks!

[Cynthia_sas]

Hi:
Basically, if you have data like this:
[pre]
ID Email
110 [email protected]
110 [email protected]
120 [email protected]
120 [email protected]
120 [email protected]
120 [email protected]
120 [email protected]
130 [email protected]
130 [email protected]
130 [email protected]
140 [email protected]
140 [email protected]
140 [email protected]
140 [email protected]
150 [email protected]
150 [email protected]
150 [email protected]
150 [email protected]
160 [email protected]
[/pre]

and you want to turn it into something like this:
[pre]
ID em1 em2 em3 em4 em5
110 [email protected] [email protected]
120 [email protected] [email protected] [email protected] [email protected] [email protected]
130 [email protected] [email protected] [email protected]
140 [email protected] [email protected] [email protected] [email protected]
150 [email protected] [email protected] [email protected] [email protected]
160 [email protected]

[/pre]

You will want to restructure or transpose your data. Under the Tasks by Category, I believe the name of the task in EG is just TRANSPOSE. Using the above data as an example, ID would be the Group By variable and email would be the variable to transpose. On the Options pane, EM would be the value for the prefix (in order to get EM1-EM5 as the column names).

cynthia

[deleted_user]

Hi Cynthia!!

Thank you sooooo much, worked like a charm!!

Regards!