In a lot of SQL implementations, though, you would rather answer such questions by recursive queries, (like in this example from SQL Server). Although SAS SQL has not yet implemented recursive queries, you can easily do something similar with a datastep. First, put indexes on your data if...
The public methods that cause this error as they useSTR."...\{myVariable}..."are in the top-level class and not in the nested public class. When I replaceSTR."...\{myVariable}..."with normal string concatenation"..." + myVariable + "..."the project compiles fine. I also use...
model[2].Inthispaperweshowhownestedsemi-structureddata,inthepresenceofwebform,can bemodelledandqueried.AWebform,likedatabaseview,isusedtolimitthetypeofqueriesthat canbeposedontheWeb.Theproblemaddressedhereishowtotraduceaqueryposedonsemi- structureddataandwebformstoasetofqueriesposedonthenesteddb-graphthatre...
Data queries and local selections: Whenever the data mapping or chart type changes, a data query is made, and the selection of the node is updated accordingly. The data mapping and chart type of the VC-node is used to query the dataset, and thus infer the cardinality of the selection. ...
I have done this with macro loops of SQL queries for both path analysis of social contacts for criminology research and program dependencies for system development. I also had some success using the NETDRAW procedure from SAS/OR to do the analysis. 0 Likes Reply Astounding PROC Star PreLoad...