For those who finds this track searching for how to identify and eliminate duplicate librefs in SAS 9 metadata, here is a blog post that addresses this in detail: SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata   It also presents a solution on how to prevent duplicate librefs in SAS metadata. ... View more

Hello David,   We also have the same of SAS and SAS VA.   Could you please give me the detailed step of all the checks you had to do and the final solution given by SAS Tech Support ?   looks like my root cause is going to be different that yours .   I have only one directory @ /opt/sas/SASHome/SASVersionedJarRepository/eclipse/plugins/ which is  > sas.grid.broker_703000.0.0.20150403143723_d4vaar9   thanks in anticipation.   Cheers, Ritesh ... View more

We manage a SAS VA environment also running on SAS 9.4M4 with SMC 9.4M5 and getting the same warning. Haven't run into any problems to date although we don't use the scheduling in VA.   Personally if you aren't having any problems then I wouldn't be too worried about the warning.  ... View more

I checked if a simpler calculation would work:   DatePart( Now() ) - timestamp   But it did not.  I think this is because the underlying SAS date value is not a supported format for VA content, but I can check on it with some folks I know in development. ... View more

Yes. The best way in my opinion is to schedule a SAS batch job, which you can do in Management Console, which reads the excel file at the appropriate time then updates the LASR table. I'd also recommend using a SAS data library on disk to stage the data prior to loading into LASR, and if the table isn't large do any updates in the staging library first and then do a complete table replace in LASR.  ... View more

Use   datepart(t1.timestamp_dttm) as timestamp_dt,   and   WHERE calculated timestamp_dt > '31DEC2018'd ... View more

The most likely explanation is that the user is no longer in a Visual Analytics role that has the Email capability.   Log into SAS Management Console with an administrative account. Open the user's account under User Manager, and look at the Groups and Roles tab. Roles are identified by the gold key in the icon. View the properties of his Visual Analytics roles. Make sure the Email capability is selected. ... View more

These look like SAS VA queries. One way is to open them in VA Data Builder then do a File Save As. ... View more

Hi @c4th1,   there are many ways and options, however, probably the easiest would be to log in in SAS Management Console as an unrestricted user (such as sasadm@saspw) and go to the Search tab. Then, if you start your search from the root folder and make it recursive, and you filter by User and later by Report, you will get the list of your users and reports and it should show at the bottom how many objects it did found. ... View more

@c4th1,   That's right. Data provider library is used for participating tables to be reloaded each time the associated server starts. Backing store for this LASR library can be only a Base SAS library. ... View more