I would like to check on what's the behavior of SAS VA when let's say I unload a table then delete it through VA Administrator page. Afterwards, I load the table again, same name and no changes.    With the tasks done above, do I need to re-map the VA table to the reports in which they were used? Or would SAS VA be able to load the report with no issues? This is with an assumption that the VA table was loaded into the SAS LASR Library and respective folders in SAS Metadata.   Thank you! ... View more

I keep getting this error on one of my VA tables. Others are working fine and I've checked the permissions that it's the same for all the tables.   Other infor: This is executed through Windows Task Scheduler by a service account (with logon as batch job permissions) Service account has full control on physical paths related to VA(Monitoring, PID, Logs, etc) Service account triggers the task but internal account sasadm@saspw is used to initialized the LASR library  The task runs 2 times daily. One at 7:45am then another at 1:45pm. The morning one always fails and the afternoon completes w/o errors. Does the SAS Auto-load do something with it? Our Auto-Load task runs every hour (6am, 7am, ...).   Any idea how to resolve such error?   MPRINT(RELOADINTOLASR): data LASRLIB.vatable; MPRINT(RELOADINTOLASR): set saslib.source; MPRINT(RELOADINTOLASR): run; ERROR: Metadata Server denied access to operation. ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1062 observations read from the data set SASLIB.SOURCE. WARNING: The data set LASRLIB.vatable may be incomplete. When this step was stopped there were 1062 observations and 18 variables. ERROR: Metadata Server denied access to operation. ERROR: Member or library LASRLIB.VATABLE.DATA unavailable for use.   ... View more

How will I be able to generate this layout using proc report where the "TOTAL" label is on the User column and not on the Group column?    Group User Jan  Feb Mar Apr May Jun Total Group 1 A 12 43 8 23 76 9 171   B 32 65 86 12 12 43 250   C 12 34 23 12 6 12 99   TOTAL 56 142 117 47 94 64 520 Group 2 A 0 0 0 0 0 0 0   B 1 1 0 0 0 1 1   TOTAL 1 1 0 0 0 1 1 ... View more