b******2 发帖数: 654 | 1 1) 如何有效地用SAS做multiple merge?有什么好方法?
2) large-scale database data cleaning 的常用方法?
欢迎回答!! |
p*****0 发帖数: 3104 | 2 eli lilly?
【在 b******2 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 1) 如何有效地用SAS做multiple merge?有什么好方法? : 2) large-scale database data cleaning 的常用方法? : 欢迎回答!!
|
d*******o 发帖数: 493 | 3 1) 如何有效地用SAS做multiple merge?有什么好方法?
1. array 2. sort-sort-merge;3. proc sql; 4. proc format; 5. hash object
Coding efficiency: 3>2>4>1>5
I/O resource: 5>4>1>3>2
flexibility: 3>>others
2) large-scale database data cleaning 的常用方法?
Using proc sql to access database via DBMS. Then use it to check outlier/
missing/invalid/duplicate values, do hard
coding correction, and update integrity constraint. Also use proc sort/means
/freq/univariate/datasets/compare/rank and SAS functions
(date/regular express |
f****r 发帖数: 1140 | 4 哇塞。。好牛的答案。但是。。啥是 hash object?
outlier/
sort/means
【在 d*******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 1) 如何有效地用SAS做multiple merge?有什么好方法? : 1. array 2. sort-sort-merge;3. proc sql; 4. proc format; 5. hash object : Coding efficiency: 3>2>4>1>5 : I/O resource: 5>4>1>3>2 : flexibility: 3>>others : 2) large-scale database data cleaning 的常用方法? : Using proc sql to access database via DBMS. Then use it to check outlier/ : missing/invalid/duplicate values, do hard : coding correction, and update integrity constraint. Also use proc sort/means : /freq/univariate/datasets/compare/rank and SAS functions
|
b******2 发帖数: 654 | 5 好牛啊! 谢谢回答!
不是eli lilly!
means
【在 d*******o 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 1) 如何有效地用SAS做multiple merge?有什么好方法? : 1. array 2. sort-sort-merge;3. proc sql; 4. proc format; 5. hash object : Coding efficiency: 3>2>4>1>5 : I/O resource: 5>4>1>3>2 : flexibility: 3>>others : 2) large-scale database data cleaning 的常用方法? : Using proc sql to access database via DBMS. Then use it to check outlier/ : missing/invalid/duplicate values, do hard : coding correction, and update integrity constraint. Also use proc sort/means : /freq/univariate/datasets/compare/rank and SAS functions
|
r********e 发帖数: 1686 | |