借助 SAS 引擎表现出色
是否可以使用 SAS 引擎运行 excel 并在其上运行 SAS 代码?
这样做的目的是我想学习一点SAS,但我不想购买它,所以也许我可以通过excel使用它?
is it possible to run excel with an SAS engine and run SAS code on it?
the purpose of this i want to learn SAS a little bit and i dont want to buy it, so maybe i could use it through excel?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(6)
不,Excel 没有对运行 SAS 代码的内置支持。但是,SAS 确实有一个 Office 插件,可让您与 SAS 交互来自 Excel。但是,您需要获得 SAS 许可才能使用此功能。
No, Excel has no built-in support for running SAS code. However, SAS does have an Office Add-in that allows you to interact with SAS from Excel. However, you are required to have licensed SAS to use this.
出于学习目的,请查看“学习版”
For learning purposes, check out the "Learning Edition"
Sas Base 是一种非常容易学习的语言。我认为在学习 SAS 之前了解数据建模、ETL、报告、数据挖掘等更重要。我在实际工作中使用 SAS,SAS Base 是一种重复的语言,就像 COBOL 我的意思是不是一种万能的语言没有java那么大。
Sas Base is a very easy to learn lenguage.. I think is more important to learn about data modeling ETL Reporting Data Mining etc before to learn SAS I work with SAS in my actual job and SAS base is a repetitive language as COBOL i mean is not an all purpose language is not as big as java is.
据了解,SAS9.3版本有一个Microsoft Excel插件,可以与SAS交互。
它提供了许多有关SAS的功能。我认为它很强大。
As far as know,The SAS9.3 version has a add-in for Microsoft Excel which can interact with the SAS.
It provides many functions about SAS. I think it's powerful.
如果您有幸能够访问 *nix 系统(例如 Linux 或 BSD 之一),您可以查看 DAP,一个开源统计包,应该能够运行此类程序。
If yo are fortunate enough to have access to a *nix system (such as Linux or one of the BSD's), you could take a look at DAP, an open source statistics package that should be able to run this type of programs.
实际上,是的 - 您可以使用 Excel 来运行 SAS 代码 - 使用 IOM 和 SAS 代码。 VBA。 Excel 中可以有一个代码窗口、日志窗口和结果窗口,从而有效地模拟 BASE SAS(我们在办公室中做到了这一点)。
但是:
所以 prob 不适合你的目的。但这是可以(并且已经)完成的!
Actually, YES - you CAN use Excel to run SAS code - using the IOM & VBA. It is possible to have a code window, log window and results window within Excel, effectively emulating BASE SAS (we did this in our office).
However:
So prob doesn't suit your purposes. But it can be (and has been) done!