I’ve been seeing some ‘Too many open files‘ exceptions in the SAS® mid-tier JBoss logs on my Ubuntu Linux server. I was surprised about this because I remember during installation I had followed the guidance in the SAS documentat…
Tag: SAS 9.3
OLAP Cube Studio: Looking at PROC OLAP Code
If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve’s posts about OLAP Code] Exporting PROC OLAP Code There are two methods to export your cube to a SAS program from SAS OLAP Cube Studio. Use Method 1 after you have added custom measurements. Click cube name > Export Code. The Export Code window appears. Use Method 2 after you have completed the Cube Designer wizard. Click the Export Code button. The Export Code window appears. From the Export Code window you can select if you want standard (long) OLAP procedure code or the shorten code. Either way – just add the path and program name. [More at SAS Support about when to use short/long form. ] Under the Hood After opening the BUILD_GA_BLOGSITE.sas program in Enterprise Guide, you see how the OLAP procedure code appears. You can learn to code your own cubes, just by reviewing how the OLAP wizard wrote the code. For instance, […]
SAS & IWA: Verifying Trusted for Delegation Status
I mentioned in a previous post that host machines need to be Trusted for Delegation when a SAS® software component, such as a SAS Workspace Server, needs to make outgoing connections to secondary servers when the initial incoming connection was ma…
Ready for the Next Generation of SAS?
There’s so much excitement about big data, data scientists, and all things that mean you need some serious SAS BI skills. On Monday I was discussing the Kinsey Insitiute projections for data related jobs, but even the New York Times ran The Age of Big Data an article about it. Appears everyone is talking about it! oooh … Buzz! I love it. SAS BI Developer Demand is Growing The past December, BusinessIntellience.Com, reported that SAS Business Analytics SMB Sales Jumped 42 Percent and went on to comment that ”[this] jump demonstrates that enterprises of all sizes are seizing business analytics as a vital competitive tool.” Last week, the same webzine was reporting that SAS in Leaders Quadrant for Business Intelligence Platforms according to the Gartner Inc report. As SAS Institute sells more SAS BI solutions, naturally more SAS BI Developer jobs become available. On the Indeed.Com you can search out job trends to determine which fields seem to be growing. [Disclaimer! These figures are based on Indeed.Com job postings and I have no idea what their counting rules are – so I realize this could be that more recruiters use Indeed or Indeed has a better aggregation methodology.] With that said, check out the SAS BI […]
Role-Based Access to Metacoda Security Plug-ins in SAS Management Console
This post explains how to provide role-based access to Metacoda Security Plug-ins in the SAS® Management Console (versions 9.2 and 9.3). Metacoda Security Plug-ins are initially only available to administrators, specifically members of the Managem…
SAS BI Dashboard Rocks My Google Analytics Data Analysis
I have to say I’m in love with the new SAS BI Dashboard and it’s many features. It really brings the Google Analytics to life and helps me understand how the Website traffic changed over time along with the key influences. The following figure gives you an idea of how you can integrate dashboard indicators for an interactive user experience. The best part is how easy it is. Once I understood the how the feature worked, this indicators below took less than an hour to setup and most of that was deciding what data I wanted to see. [More articles about Google Analytics here.] Quick Dashboard Tour This dashboard has two indicators, a line graph that shows the traffic over time and a spark table that contains specific data about site visitors. As the user drags the slider and clicks, the data in spark table updates. I left the Week variable in the Spark Chart to help you understand what was happening. Also in the Last Wk Delta, New Visitors (%) and New Visitor Delta columns, you can see the various gauges available. Creating an Interactive Dashboard For several weeks I’ve been discussing using Google Analytics with the SAS […]
Login Reviewer: Finding Accounts with Stored Passwords
In a previous post I mentioned how the Accounts tab in SAS® Management Console 9.3 now displays a blank in the password field when logins don’t have a stored password, and only displays ******** when there is a stored password. Compare this …
Export to Excel 2010 just got a little bit easier
In case you missed it, the first maintenance release for SAS 9.3 was recently released. Because we’re all friends here, you may call it “SAS 9.3M1” for short. Maintenance releases are usually about fixing problems that SAS has found or that customers have reported. However, sometimes a new capability might […]