TPL Tables 能做什么而 Proc Tabulate 不能?
特别是,编程语言中的哪些重大更改或扩展(如果有)使其功能超出了 PROC TABULATE
的范围?
或者 Proc Tabulate
和 TPL Tables(来自 QQQ Software)中的编程语言非常接近?
听到 TPL Tables 及其前身,即 20 世纪 70 年代美国劳工部提出的表生成语言,我真的很惊讶。这么多年了,我从来没有听说过它。事实证明,表生成语言的两个商业后代是 SAS PROC 和 TPL 表。
有人同时工作过吗?为什么 TPL 表如此不为人知?
罗伯特
In particular, what, if any, are the substantial changes or extensions in the programming language that gives it functionality beyond PROC TABULATE
?
Or is it the case that the programming languages in Proc Tabulate
and TPL Tables ( from QQQ Software ) are pretty close to the same?
I was really surprised to hear about TPL Tables, and it's predecessor, the Table Producing Language from the US Department of Labor in the 1970s. After all these years, I had never heard of it. Turns out, two commercial descendants of the Table Producing Language are the SAS PROC and TPL Tables.
Has anyone worked with both? Why are TPL Tables so unknown?
Robert
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您是对的,TABULATE 和 QQQ TPL 表都是美国劳工统计局 TPL 的后代。根据此帖子,开发者劳工统计局的 TPL/PCL 主管最终离开了 BLS,并创办了 QQQ。
这篇 SAS 文章是关于 TABULATE 的好读物。文章称,80年代推出的TABULATE最初借鉴了BLS TPL的大部分语法和功能,同时解决了它的一些缺点,但没有提及具体解决的缺点。
QQQ TPL Tables 的功能随着时间的推移而发展,TABULATE 的功能也是如此。我没有发现任何信息表明正在进行的 TABULATE 开发与 QQQ TPL 功能保持同步,因此这两个系统现在可能差异太大,无法进行有效比较。作为 SAS 产品,TABULATE 旨在与其他 SAS 技术(例如 ODS)集成。 TPL 可能与其他 QQQ 技术集成。
尽管仅根据文档,TPL (v7+) 可以执行 TABULATE(自 v9.4 起)无法执行的操作,即执行统计假设检验,例如 t 检验、卡方检验和方差分析。但在 SAS 中,您还有其他可能更灵活的选择来获取这些内容。
如果您希望将其中之一集成到您的开发周期中,我建议您选择最适合您当前系统的一个。如果您已经在使用 SAS,请坚持使用 TABULATE。
谁知道呢。显然,美国劳工统计局和其他一些仍在使用它。但 SAS 是该领域的巨头,以至于它往往让竞争对手黯然失色。
You are correct, both TABULATE and QQQ TPL Tables are descendants of the US Bureau of Labor Statistics TPL. According to this thread, the developers of TPL/PCL at the Bureau of Labor Statistics eventually left BLS and started QQQ.
This SAS article is a good read regarding TABULATE. According to the article, TABULATE, which was introduced in the 80s, originally borrowed much of its syntax and features from BLS TPL while addressing some of its shortcomings, though the specific shortcomings addressed are not mentioned.
The features of QQQ TPL Tables have evolved over time, as have the features of TABULATE. I've found no information to suggest that ongoing TABULATE development kept abreast of QQQ TPL features, so the two systems are now likely too different to compare effectively. As a SAS product, TABULATE is intended to integrate with other SAS technologies, such as ODS. TPL probably integrates with other QQQ technologies.
Although, just based on documentation, something that TPL (v7+) can do that TABULATE (as of v9.4) cannot is perform statistical hypothesis tests, e.g. t-tests, chi-squared tests, and ANOVA. But in SAS you have other, likely more flexible, options to get these.
If you're looking to integrate one or the other into your development cycle, I recommend choosing the one that best fits your current system. If you're already using SAS, stick with TABULATE.
Who knows. It's still in use by the BLS and a few others, apparently. But SAS is such a giant in the field that it tends to overshadow its competition.