From an Enterprise Guide user’s perspective, a SAS library is a library. Whether it was defined in the autoexec or in the metadata or by magic, it is there for them to use with no issues. However, there is a difference as metadata defined libraries do …
Tag: Administration
Verifying a SAS BI installation
After installing SAS Business Intelligence, I would also suggest verifying that all is working appropriately before adding users or importing content from another machine. (My template checklist is included below.) The act of creating the content is an…
SAS Code: Simple Macro to Benchmark Data Performance
When troubleshooting data performance problems, IO problems, or simple library connectivity, I use a simple snippet of code to push the data storage to the limits. It is useful because it stresses the data storage component, whether it be a SAS dataset on local file storage or an external database like Oracle, and it provides useful performance metrics. To make it even better, since this is a SAS Macro it can easily be called multiple times for different libraries by setting the 2 parameters in the %BENCHMARK() macro. Data Benchmark Macro Code The following code will take the CLASS dataset from the SASHELP library and continually append a specified number of iterations. Be sure to include the OPTIONS statement to get the vital statistics in the log. [crayon-502242bf5ab3d/] Output This is the output produced when the FULLSTIMER option is set. These statistics were produced on my laptop with a solid state drive. NOTE: DATA statement used (Total process time): real time 15.08 seconds user cpu time 13.55 seconds system cpu time 1.45 seconds memory 414561.92k OS Memory 439844.00k Timestamp 08/01/2012 11:00:11 PM How fast can you run this code? Remember to set […]
SAS BI: Easy Customizations for SAS Portal and SAS Web Report Studio
Last week I talked about how you could customize the style sheet for Web Report Studio. One reader, Kushal Ramani, a SAS consultant from Epoch Research India, suggested that I list some other items that you can easily change in Web Report Studio and SAS Portal. All of these changes require access to SAS Management Console – so if you don’t have that access you will need to work with your SAS site administration. Also I’m using SAS 9.3 – if you are using a previous version then your windows or these locations may be slightly different. Change the SAS Portal Banner Title You can make a small tweak to the SAS Information Delivery Portal to replace your organization’s name with the word “SAS Portal” as shown in the following figure. It’s actually a change so simple it should probably be a sin. You can find complete details in the SAS Usage Note 37734. Just open up SAS Management Console and do the following: In the Plug-ins tab, go to Application Management > Configuration Manager. Locate the Information Delivery Portal item in the list. Right-click Information Delivery Portal 4.3 and select Properties. From the Advanced tab, change the Portal.Banner.Title value […]
Business Intelligence: Good Things to Share!
I have been very busy in the past month writing guest post for some of the different blogs that I follow and find interesting. I’ve also been reading some books that I wanted to share with you! Blogging! Blogging! and More Blogging! Here’s some of the guest posts that I have contributed around the web. Password Encoding with SASPaul Homes writes the most incredible blog (Platform Administrator) for SAS system administrators. I was honored when he asked me to contribute to his blog – considering I’m nowhere near the powerhouse of administration knowledge he is. However, I did have one tip about how to encode your password and use it in SAS programs or SAS Enterprise Guide profiles. User Conferences = Busy SummerWaynette Tubbs seems to be the social media face for SAS. Her blog about the SAS User Groups always has a few gems. She asked to reprint one of my other blog posts about the conferences I’m planning to attend this summer. I did appreciate that folks who have already contacted me to let me know I would be seeing them in Milwaukee, London, and Long Beach. Woot! Woot! [Make sure you follow Waynette on Twitter – @waynettetubs] […]
Leverage metadata user synchronization macros for other uses
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is…
SAS Enterprise Guide: Best Practice for Centralized User Storage
A nice feature of SAS Enterprise Guide is the “Files” folder. This provides direct access to the file system where the workspace server is running. You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful. If this is not configured it defaults to a user-specific area. In some cases this may be the most appropriate location of the “Files” link. Simple Ways to Use Centralize SAS code developed by users Centralize SAS datasets or other types of data for users Stage incoming files from external sources for end users to consume and analyze Important Note: Make sure file permissions are set appropriately for the file system location on the server! How to Configure the “Files” Folder Use SAS Management Console to configure the location of the “Files” folder. This requires an administrative role to accomplish because it is seen across the enterprise. The workspace server runs SAS code from EG so it will be the item of interest in Management Console. Since users will access data and submit code through the SASApp context server, you will want to navigate to the workspace server through the […]
Change your passwords without locking out your connection
Did you change your LinkedIn password yesterday? (If you didn’t, you should!) But did it happen to be the same as your corporate password? First, tisk tisk. Second, change your corporate password NOW! Ok, now that this is done ~ don’t let your save…