In that case, you would need to apply the row-level security on the second table as well. Mapping the two data sources together won't be sufficient.  ... View more

Hi,    Did you verified ModelRiskManagement Mid Tier logs for more details ?. Does screen shows any pop-up error message?  ... View more

Hello @LOVE_SAA, Your question requires more details before experts can help. Can you revise your question to include more information?    Review this checklist: Specify a meaningful subject line for your topic.  Avoid generic subjects like "need help," "SAS query," or "urgent." When appropriate, provide sample data in text or DATA step format.  See this article for one method you can use. If you're encountering an error in SAS, include the SAS log or a screenshot of the error condition. Use the Photos button to include the image in your message. It also helps to include an example (table or picture) of the result that you're trying to achieve. To edit your original message, select the "blue gear" icon at the top of the message and select Edit Message.  From there you can adjust the title and add more details to the body of the message.  Or, simply reply to this message with any additional information you can supply.   SAS experts are eager to help -- help them by providing as much detail as you can.   This prewritten response was triggered for you by fellow SAS Support Communities member @BeverlyBrown . ... View more

You can have multiple data sources / tables in a VA report. A visualisation or a single report object is necessarily based on one data source / table which can be the result of joining several tables either in VA or when you prepare data outside VA. Please note a data source could be a single table or a star schema of multiple tables.   I don't follow why you think you can't incorporate multiple tables. ... View more

Thanks for the suggesitions. But I am looking something like -noautoexec option ... View more

In general you cannot since PROC SQL doesn't know anything about order. But your example seems to just be using RETAIN to generate a group level condition. It is easy to do this with binary variables since to test if any observation met the condition you can just take the MAX() over the whole group.   proc sql ; create table output as select by_va1 , by_va2 , max(col1 = 1 and col2 = 9) as flag1 , max(col1 = 1 and col2 = 13) as flag2 , max(col1 = 1 and col2 = 14) as flag3 from sample group by by_va1, by_va2 ; quit; If you need to translate to ORACLE code you can replace the boolean expressions with equivalent CASE clause instead. , max(case when (col1 = 1 and col2 = 9) then 1 else 0 end) as flag1 ... View more