A*******s 发帖数: 3942 | 1 suppose we have binary-tree-structure dataset containing id and their parent
id like:
id parent
1 .
2 1
3 1
4 2
5 2
6 4
7 4
8 5
9 5
for example, 1 is the parent of 2 and 3, and 8 and 9 are the children of 5...
I want to transform the dataset as following :
id offspring
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
2 4
2 5
2 6
2 7
2 8
2 9
3 .
4 6
4 7
5 8
5 9
6 .
7 .
8 .
9 .
any idea? |
o****o 发帖数: 8077 | 2 index parent variable
check my blog's post on DFS |
A*******s 发帖数: 3942 | 3 i 服了 you... 你的sas blog就像叮当的百宝袋...
无以为谢,包子奉上。
【在 o****o 的大作中提到】 : index parent variable : check my blog's post on DFS
|
o****o 发帖数: 8077 | 4 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没
有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
【在 A*******s 的大作中提到】 : i 服了 you... 你的sas blog就像叮当的百宝袋... : 无以为谢,包子奉上。
|
A*******s 发帖数: 3942 | 5 数据结构的我肯定想买,好像没见过这方面的书
书价贵点无所谓,反正用得着这些的人都会用公费买吧
【在 o****o 的大作中提到】 : 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没 : 有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
|
d*******o 发帖数: 493 | 6 兽哥收伪币吗?
【在 o****o 的大作中提到】 : 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没 : 有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
|
h***i 发帖数: 634 | 7 便宜了
不过可以联系SAS让他们给你额外补助
【在 o****o 的大作中提到】 : 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没 : 有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
|
w*******t 发帖数: 928 | 8 Can you please give a link? Thank you!
【在 o****o 的大作中提到】 : index parent variable : check my blog's post on DFS
|
D******n 发帖数: 2836 | 9 your blog is blocked in our company...sigh.
I guess there must be a market there. Many companies mainly uses SAS and
they wanna do data mining too. But I wonder what hardcore data-mining
ppl(and who are these ppl?what companies are they in?) use for writing
codes.
【在 o****o 的大作中提到】 : 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没 : 有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
|
o****o 发帖数: 8077 | 10 implement popular DM algorithms using BASE+STAT is a breach to the market of
EM, so I don't think SAS will be interested in supporting such a book
【在 h***i 的大作中提到】 : 便宜了 : 不过可以联系SAS让他们给你额外补助
|
s********p 发帖数: 637 | 11 That would be a great book in technical aspect.
I think only person who wants to challenge himself will complete popular data structures and mining algorithm using SAS.
Most people only care about the applications instead of implements, and I
really double the efficiency of the data structures realized by SAS. Most operations in SAS are actually disk based, not in memory.
【在 o****o 的大作中提到】 : 如果我把我自己实现各类数据结构算法和数据挖掘算法的SAS代码写本书,不知道有没 : 有人买,能在amazon上卖多少钱?79刀是贵了还是便宜了?
|
s******r 发帖数: 1524 | 12 is
http://sas-programming.blogspot.com/
right link?
but I did not find idex parent variables.
I had similar problem two years ago. Thanks for the reply on this board, I
got it fixed. However I forgot the ID who helped me. So sorry
【在 o****o 的大作中提到】 : index parent variable : check my blog's post on DFS
|
o****o 发帖数: 8077 | 13 i used hash table, in v8 solution, you index the parent variable. On SAS-L
there was a similar discussion and Sorenson Larson provided a neat SQL
solution.
someone on this board once brought out similar question where he wanted to
calculate total length of a stream counting in all connected sub-streams, I
am not sure that is the one you refer to.
here is the link
http://www.sas-programming.com/2008/11/deep-first-search-dfs-in-sas.html
【在 s******r 的大作中提到】 : is : http://sas-programming.blogspot.com/ : right link? : but I did not find idex parent variables. : I had similar problem two years ago. Thanks for the reply on this board, I : got it fixed. However I forgot the ID who helped me. So sorry
|