Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

comment on

( #3333=superdoc: print w/replies, xml ) 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?).
SAS doesn't exactly make it easy to access data from other applications. ODBC is the only means of DBI compatible way of connecting to the database/application that I'm aware of.

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.
That way everyone learns.


In reply to Re: SAS Dataset module by BazB
in thread SAS Dataset module by ab1447

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2022-05-16 11:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (63 votes). Check out past polls.

    Notices?