Greetings everyone!   Is it possible to calculate the percent change between to values in a SAS VA crosstab? I have an example attached which I could make more straightforward but the way the data is displayed is what was requested. I would like to calculate the percent difference between for example the value for 2017 Female Asian (36) and the 2016 Female Asian value (61) and all other values down the columns.   ((36 - 61) / (61))*100 = 40.98%   The data driving this report is student level meaning one row per student which is grouped and totaled by SAS using distinct count on a dummy id text variable.    Thanks,   Gary     ... View more

Greetings,   I am not sure but as it turns out neither of these statements work as filters in a VA Report or on a table at the row level;   ( 'InstrID'n Contains 'SUB::SAS.Userid' ) or ('SUB::SAS.Userid' Contains 'InstrID'n)   In either row level security on a table or as a filter. I would really like to use a filter on a report so that I can use the same table for multiple reports and restrict access to the reports themselves.   Is there any way, at all, (and I have looked and cannot find it) to see what the value is for SUB::SAS.Userid or SUB::SAS.ExternalIdentity in VA? Our User Ids are eight numeric values saved as text. Something like '12345678'. I have attempted to use GETLENGTH and REMOVEBLANKS with the SUB::SAS.Userid before comparing it using a CONTAINS statement as listed above. I have even tried an "=" assignment.   I can't find a way to "see" what the SUB::SAS.Userid value is. I have to think there is some change or manipulation that occurred but without validating what I am comparing to I can't be sure. Both fields are eight characters in length. In SAS EG I can see the userid value and it is indeed eight characters long matching what I have in my table.   Thanks for the help.   Gary   SAS VA 7.3 (Soon 7.4) SAS EG 9.4 ... View more

Philosophical question...   We are hopefully to the point where we can begin rolling out VA reports to the campus and wanted to ask what some of you are doing to restrict/grant access to groups of users? Our initial thoughts were to create groups and give them access to folders that contain meaningful reports. We are just looking for some feedback on what approach may work the best.    For clarity, we basically have a College Administration (Provost, President, VP's etc), Department chairs, faculty (who should only see reports of their data which we are attempting through row level security using the USERID:: functionality). From there we have directors and office staff which may have the need to see reports in one of the other folders listed.   Again, not looking specifically at any one answer just some guidance/insight and approach.   Thanks,   Gary ... View more

Greetings everyone,   OK, so I have a VA report that uses a table on our LASR server and everything works fine until I need to update the table. I would like to update the table from the program that creates the data when it runs every semester. I do have an "Upload to LASR" step in the Process Flow for the project.   I can delete the table using Management Console but I lose my row level security. Once I delete the table I can reload it using my project. Outside of this though, I would like to be able to update/reload any table without having to manually delete it first. I am thinking this is probably pretty routine. If I autoload the table it replaces/updates the table without issue but our Autoload places tables in a specific folder not always where we want it for organizational reasons. The attached image has autoloaded tables along with the table I am trying to update, EOT_IR_GRADE_DIST_PROVOST.    The document attached has the images and code and I have full access to the system as an administrator.   Thank you all as always, Gary   ... View more

Greetings!   OK, so I am trying to delete a report using Management console and I get an error message stating I cannot do this with reference to a log that I or our IT guys can't locate. I have a screenshot in the attached pdf.   Each of us has all the rights possible so we are scratching our heads as to why we cannot simply delete a report.   Thanks,   Gary ... View more