Desktop productivity for business analysts and programmers

Big database linear regression

Reply
N/A
Posts: 0

Big database linear regression

Hello

I'm developing a website where customers should be able to value a house. I have no experience in SAS programming,but I have good experience in many other languages.

I have a server, with mySQL database, SAS 9.1, SAS enterprise guide. And in my database I have a big table where there are sold houses the laste 4 years all over the country. It'saround 150.000 rows.

I've been able to open ODBC connection to the database table. How shall I go on? Shall I create datasets? How do I do that?

Can someone guide me through this? Even smalll hints will be very helpful.

Best regards
HuGoB
N/A
Posts: 0

Re: Big database linear regression

If you want to make this interactive from a web interface, with SAS underneath, then you may need some additional SAS tools.

I expect you can prototype a bunch of stuff with EG, but I also expect that you will need to ultimately program directly in SAS.

As an intro to SAS programming:

SAS is a data centric language, not process and control. The focus is on "this is my data, this is what I want to do with the data" not "I have a box, this is what I want the box to do".

This is why the base programming block stucture is a "Data" step, and opening and closing files are generally implicit operations, not explicit.

There is a new user around here -- Joshua -- who's picked himself up by his bootstraps. I would recommend searching for his postings to find out which books he's used/read to get himself started.

Chris@SAS is around here as well, and he is one of the favored authors.

I started programming in PL/C back in 1977, and have touched/programmed/reviewed a large number of languages, including (but not limited to, and in no particular order) Pascal, C, COBOL, SNOBOL, ForTran, Ada, Forth, Tutor, Basic, 4th Dimension, FoxBase, awk, Korne shell, Perl, VisualBasic, C++, VBscript and Java. My favorite languages include SAS, C and Java, each of equal standing to the other (right tool for the job kind of thing). I said many years ago "SAS is the greatest data processing language on the planet".

Happy programming.
N/A
Posts: 0

Re: Big database linear regression

I found these references very helpful in grounding myself in the basic principles: SAS for dummies, the little SAS book, the little SAS book for EG4.1 & Learning SAS by Example: A Programmer's guide.

Once I was through these books, it became more meaningful to pick up the product documentation, white papers, and the webcast materials. I also found the materials on thotwave very helpful.

That said, I am still a resident noob, barely 8 weeks into the world of SAS.
-
http://support.sas.com/resources/papers/
http://www.sascommunity.org/wiki/Main_Page
http://www.thotwave.com/
http://blogs.sas.com/sascom/index.php?/categories/21-SAS-Global-Forum
http://www.sas.com/apps/webnet/customer_success.jsp?index=cs_sgf2008&player=wm&type=cs&quindex=sgf20... Message was edited by: Joshua
N/A
Posts: 0

Re: Big database linear regression

Is it necessary to perform the work through SAS? You have a web server and a database, so perhaps what is lacking might be an application server that encapsulates the business logic and is able to pull the necessary information from the database. I'd try JBoss with Mysql leveraging on innodb storage engine. Thats just my humble opinion as the resident noob.
Trusted Advisor
Posts: 2,114

Re: Big database linear regression

Josh has a point. You could use SAS in the background to build the regression equations (say run every night) and then store the coefficients to a table. The web ap could then just do the arithmetic to get the expected values for the specific parameters set by the customer. If your customers are sufficiently sophisticated, you might also store the covariance matrix so you could compute error bars for the estimates.

Doc Muhlbaier
N/A
Posts: 0

Re: Big database linear regression

Hello again.

Thank you for the replies. It's very helpful.
I really thought that I won't be needing any middleware between the webapplication and the SAS program. Do I really need that or isn't there any other solutions to get on with this?

I wanted to make the calculation directly when there is a new user trying to make a valuation of a house. I really coan't understand why I should run batches during night?
N/A
Posts: 0

Re: Big database linear regression

Okej, I hereby confirm that I don't need any middleware application to communicate with the SAS software:

http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/index.html

I'm going to store the SAS program as a stored procedure, and then make a webservice to access it!
Ask a Question
Discussion stats
  • 6 replies
  • 149 views
  • 0 likes
  • 2 in conversation