Hi All,
I have a data set with variables id, a, b, c, d and looks like:
1 2 3 5 1
1 5 6 5 3
1 2 4 2 4
2 1 3 4 5
2 5 6 2 3
2 4 5 2 1
I would like to summarize data for each id and create a new variable
representing each code occuring in variables a, b and c.
Essentially the new data set should have variables id, v1 - v6.
v1 represents the number of times code 1 occurs in variables a, b and
in the original data set, and so on for v2 - v6.
The data set would like;
1 1 3 2 2 3 1
2 2 2 2 2 1 1
Your help is much appreciated.
Thanks very much,
Zai Sak
--
zaisak
-----------------------------------------------------------------------
zaisaki's Profile:
http://www.excelforum.com/member.php...fo&userid=1375
View this thread:
http://www.excelforum.com/showthread.php?threadid=48039