TAGS :Viewed: 2 - Published at: a few seconds ago

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?

Answer 1


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.

Answer 2


For learning purposes, check out the "Learning Edition"

Answer 3


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.

Answer 4


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.

Answer 5


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.

Answer 6


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:

  • You need the SAS Addin for Microsoft Office installed
  • You need a connection to a SAS session (local or remote).

So prob doesn't suit your purposes. But it can be (and has been) done!