Tag Archives: sas

Quora asks What are the advantages of using R/SAS/Matlab/SPSS over Excel on Microsoft WIndows 8?

Quora asks What are the advantages of using R/SAS/Matlab/SPSS over Excel on Microsoft WIndows 8?

Excel is still useful no matter what you think

http://www.quora.com/What-are-the-advantages-of-using-R-SAS-Matlab-SPSS-over-Excel-and-all-associated-advanced-packages

Join my FREE newsletter to learn more about these powerful tools

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

A true tech smackdown: SAS vs. R (vs. Python) – which tool should I learn? Matlab could be same as SAS

A true tech smackdown:  SAS vs. R (vs. Python) – which tool should I learn? Matlab could be same as SAS

There you go, the truths speaks for jobs opportunity and support. I think you can equate Matlab to SAS or maybe even better in a number of areas.

http://www.analyticsvidhya.com/blog/2014/03/sas-vs-vs-python-tool-learn/

Do I still use Python is the questions?

Join my FREE newsletter to see if what we use

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Webinar on using Matlab Production Server for Financial Application with financial analytics into Excel SAS databases, and Hadoop big data , and web applications

 

Webinar on using Matlab Production Server for Financial Application with financial analytics into Excel SAS databases, and Hadoop big data , and web applications

Here is the best sample use for this powerful product:

http://www.mathworks.com/videos/matlab-production-server-for-financial-applications-81937.html

Join our FREE newsletter to see how this product can be implemented 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

This could be a hopeful reference source to reverse engineer a bunch of Econometric Excel, Strata, or SAS functions and files

This could be a hopeful reference source to reverse engineer a bunch of Econometric Excel, Strata, or SAS functions and files

Here is an ebook to understand it:

http://economia.unipr.it/DOCENTI/GOZZI/docs/files/using_excel_for_principles_of_econometrics3e.pdf

Files

http://principlesofeconometrics.com/poe4/poe4.htm

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Did you learn C and C++ courses before you learn SAS . ? are they useful and helpful to learn SAS software ?

Did you learn C and C++ courses before you learn SAS . ? are they useful and helpful to learn SAS software ? How do you master it without more computer science knowledge? thank you very much

 

==

There is no need to know C (or any object oriented programming language) prior to studying SAS as SAS is a procedural based language. SAS utilizes keywords that kick off embedded pre-coded procedures that run underneath the GUI that SAS is.

I would recommend learning something like a combo of Java and Python if you are interested in building algos and the like. If you can learn Java or Python, you can easily pick up SAS.

This is my opinion of course.

 

==

I am not SAS expert, but I remember looking at SAS code and it looked a lot like … COBOL. But for the love of everything that is holy, please, do not learn COBOL. If you must use SAS, just go right to SAS. “The Little SAS Book” by Delwiche is a nice introduction.

Of course there is a better language for statistical computing. It is called R. Check it out. It looks more like C, and is pretty easy to learn given a ton of help available online.

Good luck!

 

==

COBOL !? Yee gads. I’ve still got my Cobol textbooks (next to the punch card decks I produced for lab assignments :>] ) ah, memories.
The previous comment is correct in that SAS is much more procedural. It has a good GUI (Enterprise Guide) that speeds most programming tasks and reduces pesky syntactical errors. Like Oracle, MSQLServer, and Terradata it’s another flavor of SQL so if you have exposure to one, you have a start with SAS. There’s also a “…For Dummies Book”.

 

=

To me, SAS is a lot like FORTRAN. C/C++ classes will help in terms of just general programming, but not so much specific techniques. And I’ve coded SAS for 12 years with no programing degree. To master it — think carefully about what is going on in the code and always strive to do better.

 

==

If your goal is to learn about SAS architecture and integration with other languages, you are much better off learning Java rather than any of the C dialects.

 

To learn SAS there are no pre-requisites. You don’t have to have computer science knowledge to start learning basic SAS. Some advanced SAS (hashtables, lookups, macro programming) might require basic knowledge of computer science.

To master SAS (or any programming language for that matter), I recommend coding, not reading codes.

 

=-=

I agree 100%. Modern day data scientists are using Java, Ruby, and Python much more than SAS.

Interestingly, a friend of mine interviewed at a very prestigious data company (I would mention but not my place). At any rate, he, like I, has been programming in SAS and R for upwards of 4 years, and is a very good programmer in SAS.

Long comment short, my friend was asked about the underlying algos that SAS employs through simple proc calls like “proc sort” or proc means, etc. Due to not knowing the underlying algos, he wasn’t able to perform up to the standards of the companies hiring protocols, and wasnt able to compete.

Going back to what I said earlier, Java or C#, even C++ are much better learning tools than SAS and R in that they force you to understand the underlying procedures and functions that SAS and R both employ, respectively. When you call a proc sort in SAS, SAS calls its pre-written algos to perform the task. I think that is the drawback of modern data analysis and can be turned into a strength if we learn underlying code.

 

=-=

I agree with most of the comments here. Sounds like you are just starting. If that’s the case no. SAS is actually a very unique language in my opinion. It has outlasted most languages and it has lots of quirks that won’t work in other languages. As already mentioned it isn’t object oriented. It’s base is very archaic actually. But the simplicity of the data step for instance makes it quick to pick up. The comments about R are accurate. There is a great deal of similarity to C with R so if you asked “would learning C help me with R?” then the answer is yes. R is object oriented and similar in syntax and structure to C. The comments about more advanced understanding of the algorithms is accurate but it doesn’t sound like you are going to be there for awhile.

 

SAS is singularly one of the worst programming language designs that I have ever run into. The fact that the FDA requires it be used in clinical trials further supports the fact. I avoid it at all costs. There are a zillion other programs out there that are far more userfriendly and more easily understood. Besides, the fact that anyone that can make a living writing programs in SAS means that the language is too hard for most people to use.

 

==

Learning C++, Java, Python or R will make it difficult for you to learn SAS further down the road.

 

==

Even a 4th generation language such as SAS requires two basic skills…

1) Desire
2) Aptitude

Of course, this applies to many things in life but especially in the SAS realm.

 

==

Not sure what parts of SAS you’re interested on, but the basic data manipulation syntax (DATA and PROC steps) did not require any previous knowledge of C or C++. All I needed was a basic idea about tables, columns, and joins.

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

Did you learn C and C++ courses before you learn SAS? are they useful and helpful to learn SAS software?

Did you learn C and C++ courses before you learn SAS . ? are they useful and helpful to learn SAS software ? How do you master it without more computer science knowledge? thank you very muchsas
–There is no need to know C (or any object oriented programming language) prior to studying SAS as SAS is a procedural based language. SAS utilizes keywords that kick off embedded pre-coded procedures that run underneath the GUI that SAS is.
I would recommend learning something like a combo of Java and Python if you are interested in building algos and the like. If you can learn Java or Python, you can easily pick up SAS.
This is my opinion of course.
==I am not SAS expert, but I remember looking at SAS code and it looked a lot like … COBOL. But for the love of everything that is holy, please, do not learn COBOL. If you must use SAS, just go right to SAS. “The Little SAS Book” by Delwiche is a nice introduction.
Of course there is a better language for statistical computing. It is called R. Check it out. It looks more like C, and is pretty easy to learn given a ton of help available online.

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

The great R vs Matlab vs Python SciPy, Excel, SAS, SPSS, Stata for serious quant analytics and quant development

The great R vs Matlab vs Python SciPy, Excel, SAS, SPSS, Stata for serious quant analytics and quant development
Here are a few great links to start it off:
http://brenocon.com/blog/2009/02/comparison-of-data-analysis-packages-r-matlab-scipy-excel-sas-spss-stata/
http://stackoverflow.com/questions/1738087/what-can-matlab-do-that-r-cannot-do
From my perspective, I like Matlab over any of these with the same reasons suggested. I do like the Matlab community, documentation, IDE, and Coder/Builder JA toolboxes. It is easy to work with so you are looking up some useless info or working with some dated R package. I have seen some recent R demos and presentations but it just seems Matlab does the trick for me. R looks good but it just always seems Matlab looks better for my needs. It does cost but the productivity I save with something like R would cost me in time. This is my own opinion at this point.

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

5 Ways to Convert SAS Data to R for quant development

5 Ways to Convert SAS Data to R for quant development

The process of importing SAS datasets into R is fairly simple.  As with most R and SAS tasks, there are multiple approaches to achieving the outcome, and this list is by no means exhaustive.  Below we outline five methods to…

http://rconvert.com/sas-vs-r-code-compare/5-ways-to-convert-sas-data-to-r/

 

==

JMP integrates with the R open-source statistical programming language. This means R programmers can quickly leverage the interactive graphics in JMP to provide the much-needed multiple dynamic views that are so useful for data exploration and model interpretation. Conversely, JMP users can exploit any of the cutting-edge statistical functionality the open-source community provides – without being exposed to unnecessary and distracting complexity. You can exchange data between JMP and R, submit R code from JMP within a JMP script, and render R graphics directly in JMP. Combining these elements allows R developers who know a little JMP, or JMP developers who know a little R, to build JMP add-ins that use the advanced capabilities in R whenever they are valuable, surfacing them in a way that is appropriate for any user.

 

==
However as far as reading SAS datasets goes JMP has the same issue as R in that currently a Local copy, or a connection to SAS server is needed to read sas7bdat.

JMP can read V5 transport datasets directly.
SAS 9.3 can read JMP tables using a special engine on a libname.
JMP would make a great interface (GUI) for an R application. There are other ways (e.g web interface) but the JMP way has the great advantage that users can go further with what you give them in a proper exploration environment…
They can generate scripts and ask you to incorporate them.

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!

modeling in sas

modeling in sas

Having more than two models testing the same thing and i want to check if the the models are the same. that is if y1=a1+b1x1 is not different from y2=a2+b2x2. is there, there an option in sas that can check whether a1=a2 and b1=b2 simultaneously without testing their intervals differently

I don’t exact command/reference in SAS, but technique which helps you to know whether two models are same or not is “ANOVA”, in R programming, you can use it as anova(test1model, test2model).

Hope, my two cents help you.

—-

am sorry taking too long to comment on your comment, a i know, ANOVA test whether a model is significantly important (R-square and F value). but my problem is that i have tow different models both significantly important according to ANOVA but i just want to know which is better among the 4 models i have. do i need just to look at the largest R-

 

 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!