If oracle permissions created(new user) for every set of tables then it will be too many users to be on each schema.(for example - each schema having 500 tables, 20 schemas). and every time if we need to add or remove the permissions on the one user then need to ask DBA to grant or remove permissions. is it correct? ... View more

thank you. we need to register all the tables as business user are using the EG so they need to know the what are all the tables are there to explore the data. because some business users need to access all the tables. some of the are dont require to access all the tables in a library (which is configured in sas smc) . I want to know how to restrict in sas smc by table wise in sas smc for some users.   as you mentions by Oracle database permissions can you share some more info if not possible in smc. ... View more

Hi Markus,   department task_list aaa 1001 bbb 1002 ccc 1003 ddd 1004 ccc 1004 ccc 1005   there is no column which contains groups with all value , so I cant choose in the if condition to select the values. requirement is : when we use button bar by department we get as per the example: 5 dep and on the same button bar we would like to have All so when user would like to see statistics of all the all the departments stats then he will choose all otherwise dept.  as we don't have all in the new customized category as I have created custom category to define the 5 groups and in the custom category we dont have options to choose all as one group.     ... View more

hello Koen please ignore my previous post it is working thank you . ... View more

Hi , little change in the order in the libaname libname abc cas caslib=mydatt_cas_data; but this time i have problem of saving table proc casutil; save casdata="xxxx" incaslib="xxxx" outcaslib="xxxx" casout="xxxx" replace; quit; ERROR: The action stopped due to errors ERROR: Failed to save the table "xxxxx" from the "xxxx" caslib to the "xxxxx" caslib here from and to caslibs are same. 🙂 ... View more

Thanks Koen, proc datasets library=mydatt_cas_data NoList memtype=DATA; delete MTEST; run; quit; ERROR : mydatt_cas_data is not valid name i already creaed as pathbased library in cas as mydatt_cas_data where i used to save the all cas tables. ... View more

Thank you very much for the information. proc casutil outcaslib="public"; promote casdata="MTEST" incaslib="public"; quit;     proc casutil outcaslib="public"; promote casdata="MTEST" incaslib="public"; quit; after using the above code I can see the table has been loaded as in-memory table in the target cas library. but the problem is if I want to replace by executing the same code in sasstudio i am getting error as table already exist.  ERROR: There is no session-scope table xxxx in caslib test_cas_data of could analytic services. ERROR: The action stopped due to errors.   If I unlod the table by manually then run the above code of proc then table loaded as in-memory table.   I am confused how come the able in showing as in studo as in-memory table (with symbol) mycas of libraries . on the same if I go  environment manager and tables then my cas library the able is only available .sashdat table, not as in-memory table copy.(as when we load the table two copies one physical .sashdat , and memory table as cas with same name).     ... View more

Thank you! ... View more

thanks, what is the difference in 202x.x to viya 3.5 8.5.2. if 202x.x features are not backported to 8.5.2 then what is the alternative solution to get the all the features of 202x.x. ... View more

about logs of the va report, when we click on the id value it must be passing the id_num to the url link. so if want to see the log of the report where can we find about parameters are passed. ... View more