I am using ODS Excel to print two tables on one Excel sheet. SAS adds one empty row between these tables. How can I avoid this empty row? I want two table printed one under another without any empty rows. ... View more

What is the right way to check access for all nested groups in SAS Viya?   I have group1 and group2 which is a member of group1. So, group2 should inherit access given to group1.   Part 1. Is there a way to see permissions on objects (caslib, tables) for all nested group (and possibly users)? When I use: proc cas; accessControl.whatIsEffective / objectSelector={objType="caslib",caslib="mylib"},ReturnDecisionText=true; run;quit;   I only get group1 in the list (no group2 though it inherits access):  Can I get something like this? group1 - Authorized (explicit) group2 - Authorized (inherited)   Part 2. SAS is not showing that a nested group has an access.   When I use: proc cas; accessControl.whatIsEffective / ids={{identity="group2", identityType="group"}}, objectSelector={objType="caslib",caslib="mylib"}, ReturnDecisionText=true; run; quit;   I get:  though it should be Authorized because group2 is a member of group1 and: Why it does not show that group2 is Authorized?      ... View more

There a dataset. I need to call a macro for every value of a certain column. This column has some values with an "elision" French symbol which is like an unmatched single quote. How can I pass this value to a macro in a loop using call execute?   Here is an example: /* Initial dataset. Need to loop over its values. In reality this dataset has many rows. */ data test; mvar="L'université"; run; /* Macro to call for every row in the dataset. */ %macro test(obj=); /* Some code...*/ %put &obj.; %mend; /* Loop to call macro for every row in the dataset. */ data _null_ ; set test ; str=catt('%test(obj=%nrstr(',mvar,'));'); call execute(str); run;   This code results in errors: ERROR: Expected close parenthesis after macro function invocation not found. ERROR: Macro parameter contains syntax error.   Thanks for any help. ... View more