Greetings,   We are no longer using SAS Visual Analytics or SAS Enterprise guide and have moved to SAS 9.4 Analytics Pro. Is it possible to run SAS Enterprise Guide (.egp) projects in Analytics Pro? We were told by SAS we could do this, but I am not seeing a way to accomplish it.   If not, is it possible to run multiple programs, as you would in a project in EG in SAS Analytics pro?   Thanks,   Gary ... View more

Greetings... I need to export a csv file from SAS EG to a SharePoint site. I can sort of do it, but I need to export to the institution's SharePoint site, not my personal SharePoint site. For example, I can export to here; C:\Users\12345678\OneDrive - Santa Fe College\Institutional Research Reports Data\ But I need to export to here; https :// sfcollegeedu.sharepoint.com/sites/InstitutionalResearch/Institutional%20Research%20Reports%20Dat      I am not an IT admin, so I apologize up front for any lack of clarity. Thank you,   Gary   P.S. We are moving to PC SAS in the near future. This a centers around moving to Power BI. Thank you,   Gary     ... View more

Greetings everyone,   So, I have been asked to provide in a single crosstab and accompanying graph(s) for the following scenario an overall success rate for an entire division, an overall success rate for an entire Department, an overall success rate for an entire Program, an overall success rate for an entire course, and then a specific faculty members success rate for the course(s) they have taught. The faculty member's information comes from a dataset/LASR table of all faculty at the college and their individual success rates, but the faculty member viewing the SAS VA report only sees their information.   I do not believe this is possible if for no other reason than information being displayed is filtered by each subsequent area thus eliminating the possibility of calculating metrics for an overall data point. I am wondering if there is a some functionality that would allow the combining of data such as the overall metrics from multiple sources with the table using row level security?   The attached PDF is an idea of what the users are looking for. The "My Courses" bar would be the specific faculty member success rate for the course(s) they taught for a given term and year. The "All CHM1025" and "ALL CHM2046" are the overall success rates for those courses for a given term and year. The "Chemistry" bar is the Department success rate for all courses in the given Department for a given term and year. The "Nat Science" is the Program success rate the given Department for the given term and year.(Division isn't included here, but would be another bar titled "Liberal Arts & Sciences))   I can create each of the metrics as individual crosstabs and line /bar charts, but the users are looking to have all of this information in one crosstab and graph.   Thank you as always for your help.   Regards,   Gary       ... View more

Greetings,   We have loaded a table to our LASR server via the autoload process and now need to access it via the SAS® Environment Manager Administration tool to apply filtering for specific users. We have done this a few times before and it works well. We are using something similar to  ( 'Instructor_ID'n Contains 'SUB::SAS.UserID' ) OR ( 'SUB::SAS.UserID' Contains 'Instructor_ID'n )   Our problem is that the list of tables when we navigate to the proper location via the "Folders" icon in the SAS® Environment Manager Administration. What we see are tables with titles starting with A though P, but we have many tables with names that start with letters after "P" in the alphabet. Those do not appear in our list.   If we select the "LASR" icon in the SAS® Environment Manager Administration webpage we do see the table and if we use SAS Management Console we see the table as well. It seems that the Environment Manager Administration only allows the displaying of a certain number of tables.   I have attached a PDF of a few screen shots to help clarify what I am trying to describe.   Thank you for your help.   Gary   Product name: SAS® Environment Manager Administration Release: 2.6 Build date: May 8, 2019 at 9:33:45 PM EDT   And we are running SAS VA 7.5. ... View more