BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
6 REPLIES 6
deleted_user
Not applicable
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.
deleted_user
Not applicable
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
deleted_user
Not applicable
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.
Doc_Duke
Rhodochrosite | Level 12
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
deleted_user
Not applicable
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?
deleted_user
Not applicable
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!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 773 views
  • 0 likes
  • 2 in conversation