k*p
发帖数: 1526 | 1 还是一般就是文本文件，再用perl读取，sas统计？
thanks | z**k
发帖数: 378 | 2 it depends
if you always read data sequencially, Perl is enough, but if you need random
access, sorting, merging, or other basic database operation, you'd better
use a database.
SAS has it's own relational database system. Using SAS is essentially using
a database, for most of time SAS beats other databases. | v*******g
发帖数: 334 | 3 what is it ?
How big is the dataset that SAS can handle?
【在 z**k 的大作中提到】
: it depends
: if you always read data sequencially, Perl is enough, but if you need random
: access, sorting, merging, or other basic database operation, you'd better
: use a database.
: SAS has it's own relational database system. Using SAS is essentially using
: a database, for most of time SAS beats other databases.
| d*******o
发帖数: 493 | 4 I feel SAS is not an ideal DBMS.
(1) For large data sets, building indexes is necessary to merge or sort. SAS
has no performance tuner. It is very hard to optimize the indexing.
(2) SAS runs with single-tread. Most CPU right now have more than one core.
(3) No automation for database maintenance including backup/restore.
(4) Not many security options. | z**k
发帖数: 378 | 5 i v no idea about the scalability of SAS, but I guess it can handle really
large dataset.
My understanding is SAS is not using any of the mainstream database system
like oracle, sql server, etc ... it developed it's own relational database,
and thus has lots of nice buildin functions, like transpose and _N_. It's
true SAS do not maintain index (based on my SAS Adv cert guide), but you can
always index tables right before a complicated query. Of course you could beat SAS if you write all code in
【在 v*******g 的大作中提到】
: what is it ?
: How big is the dataset that SAS can handle?
|
|
