sas query file

[mernamaher]

Hello Dears,

When using sql query file in sas and write a select query as this example in sas documentation

SELECT debtRatio AS {:debtinc:decimal}, cause AS {:reason:string:8} timestamp AS {:ts:datetime}
    FROM hmeq_test WHERE badloan = {?:bad:decimal}

this query on loaded table in sas memory or query database direct ?

Thanks 

[ballardw]

Can you provide a link to the documentation page where you find that example.

There is a great deal of "documentation" available for SAS and some of it uses examples that connect to external data bases that have a wide variety of SQL syntax. It may not be possible to answer your question without seeing the context in the entire documentation.

[mernamaher]

https://documentation.sas.com/doc/en/edmcdc/5.4/edmug/p0zqdi1bacsmexn1va2096e6i5or.htm

[mernamaher]

My question is the data query file selects from database or from the loaded in memory table ?

[ballardw]

From https://documentation.sas.com/doc/en/edmcdc/5.4/edmug/p1p9vjnjkwwv94n15qdqcst8o5jd.htm

code file authoring and management

You can define custom code files to do things that are not possible in rules, models, or treatments. For example, you can define a code file that makes HTTP calls to REST APIs, interacts with a database, manipulates files in the file system, or performs custom data transformations. In SAS Intelligent Decisioning, you can easily create, edit, and manage custom data query files, DS2 files, and Python files. You can create and edit data query files by using the SQL editor or by launching SAS Studio.

So it appears that is going to depend where you point the source of the query to.

I don't have any experience with SAS Intelligent Decisioning so if the question is more nuanced than it appears I don't recognize it.