|Think about Loose Coupling|
Re: SAS Dataset moduleby BazB (Priest)
|on Dec 15, 2005 at 12:37 UTC||Need Help??|
Note that my SAS is a little rusty, I've not touched it in about 6 months, and I'm working from memory.
As a previous poster has said, SAS stores it's data in a proprietary format (however this is irrevelant - I don't read MySQL data directly, so why should I care about SAS?).
If I remember correctly, it is possible to have SAS read it's input from a pipe; you might what to look at setting up a process that your CGI injects data into to have SAS read it from the other end.
Another alternative would be to dump the data from the CGI into a database that has a Perl friendly interface that SAS can also access, but frankly that's just introducing other pointless layer and, knowing SAS, more cost.
To be honest, I've always found that the simplest way is usually the best: if all you need to do is store data in SAS, dumping the data to a file and calling SAS from Perl to process the data (possibly generating the SAS code to do it first) is simple and relatively fast.
I hope that gives you a few ideas.
If the information in this post is inaccurate, or just plain wrong, don't just downvote - please post explaining what's wrong.