At our site, the LDAP settings and security layers mean that I have to add user accounts in metadata as: blah123@domain.yyy.zzz However, SAS VA authenticates directly to LDAP Enterprise Directory using their main user ID, i.e. blah123. So they don't need to add @domain.yyy.zzz when logging on to VA. The LDAP authentication system options are in our SAS config file. They handle the domain suffix. (In the metadata server log, user logins appear as blah123@domain.yyy.zzz) Possibly Windows Active Directory SAS system options exist that pass the domain\user ID to the SAS metadata server for the identity account look-up? ... View more

We have the same problem with SAS Management Console 9.4 in Windows 7. I have raised a track with SAS Tech Support. Update: Advice from Tech Support (Sydney) was to install various Logical Types modules with Deployment Manager into our Windows 7 desktops. This worked. ... View more

We tackled this problem. The solution is to write the date out as YYMMDD10. and apply an Excel format. This sample below uses PROC REPORT, but you might be able to adapt it for PROC TABULATE output by applying styles on your date variables. This exanple writes out SAS dates as DD MON YYYY, e.g. 5 Jun 2014. In Excel it is recognised as a numeric Excel date. PROC REPORT etc... ; define notified_date / display format=yymmdd10. 'Notified Date' style(column)=[tagattr='type:DateTime format:D MMM YYYY;@']; RUN; ... View more

A long-term approach is a shared drive. We have a Samba share of 100GB mounted to our SAS LINUX servers. In Windows 7, users map a drive letter automatically to this \\server\folder location when they login to the LAN. ... View more

It sounds like you are not only doing an Enterprise Guide project migration, but also a SAS platform migration (Win to LINUX), which is a completely different exercise. In short, EG projects are zip files. If you could unzip all of your EG projects, the files in the zip archive could be updated with a find-replace script to replace all Windows folder names with LINUX folder names. Then the files are re-zipped. But this assumes you have a mapping of all Windows folders into the corresponding LINUX folders. Otherwise you might have to edit the projects one by one and just use the manual find-replace function. Data libraries can be switched using the project manager in EG, but not the hardcoded folder names. ... View more

I cannot get ORIENTATION = LANDSCAPE to work for a single PDF document using SAS V9.2 M3, let alone changing it mid-stream. I will be raising a track for this. ... View more

What you can try is adding combo boxes to a spreadsheet in Excel exactly how you want it. Then save the spreadsheet as XML. Open the XML text file in an editor, and locate the combo box XML definitions. There might be a way to embed them from the SAS side into your ExcelXP output file in those columns. Sounds messy, though... ... View more

Are you generating reports using ODS? I have an EG project that generated hundreds of Excel reports using ODS ExcelXP. After creating the reports, EG would freeze while it dealt with the reports....not sure what it was doing, linking them or something like that. This could take 5-10 mins, regardless of the EG option settings mentioned above. I tried everything. From memory, I think the task status was "Collecting..." too. Anyway, I found that the following ODS statement stopped this behaviour dead in its tracks: ods noresults; This was fortunate, because in a few days I had to handover the running of the project to a non-IT business customer. Having EG freeze while it churned through ODS results would have been less than ideal. ... View more

Hello, I also wanted to add an announcements page on our SAS Portal V4.3. There might be a better way to do it, but here's what I did to create a crude hardcoded HTML page... Build a simple HTML page somewhere on your SAS servers or network that can be accessed by all users as a URL. Ours sits on SAS App, which runs Apache web server. This HTML file contains the annoucements message contents. Create a new page in the portal, called something like NEWS. Set the page rank to be the lowest number relative to all other pages, e.g. zero or 1, so that it appears at the top by default for all users. Set the location group to PUBLIC. For this page, add a portlet called something like "Latest Items". Also set the location group to PUBLIC. Set the portet content to be "Display URL Display Portal". Point the portet URL to your HTML file location. Untick "Show full HTML content in an inline frame" so that the default font is inherited from the portal stylesheet. However, to make it seamless, you should set the font size and font colours etc. to match your SAS Portal theme. By editing the HTML file, you can instantly update portal news and annoucements. I have Prod and Dev portals pointing to the same HTML file. I also created a "Known Issues" portet under the NEWS page to list the status of existing problems. Of course, the URL Display portlet could point to any web page that displayed the information you want to show as portal annoucements. ... View more

OK, that makes sense. Just curious...How does your 80GB dataset cube perform? I suppose it should be fine if you have the common aggregations defined. ... View more

I have seen a couple of demos of Visual Analytics. We already have Enterprise BI V4.3 installed and running. Visual Analytics seems to depend on having high-powered hardware to provide an in-memory data warehouse for fast query response, hence VA cannot use your existing EBI hardware. One point that's obvious is that VA has a better web browser look-and-feel compared to EBI, which is stuck with an early 2000s web interface. The world has moved on and people have higher expectations. Ideally given a blank cheque, I see VA being good for informal "discovery" tasks in which business staff and business analysts can explore their data warehouses and datamarts with minimal intervention from the IT department. While EBI is used for more specific ad hoc reporting, dashboards, and smart OLAP discovery. On a personal note, I hate web apps, and wish SAS also provided a Windows thick clients for WRS etc. ... View more

To keep things simple, I refresh our cube data each month. By refresh I mean (a) perform a physical cube data file delete, then (b) do an upload step, all using PROC OLAP. Maybe you can explain why you need to keep the existing data while adding new data, instead of doing a full refresh? We extract fresh datasets each month, so it's easier just to load that dataset than perform incremental updates. ... View more

We recently got out-of-memory errors when opening cubes after upgrading from SAS V9.2 M1 to M3 and from Web Report Studio V4.2 to V4.3. Turns out that we were unknowingly selecting ALL fields in the cube for display in Web Report Studio via the Select Data panel, instead of selecting say 2 or 3 dimensions and a few measures. And so selecting all fields caused the OLAP server to generate a CROSSJOIN for all dimensions (say 25 of them) and all measures. With 250,000 rows, this blew the Java VM memory allocation every time, regardless of how much memory was allocated. ... View more