About PaulHomes

PaulHomes · ‎02-26-2014

As BIC_USER_3@SAS mentioned processing of a relational information map will be done in a SAS Pooled Workspace Server which is typically launched using the operating system identity sassrv (as directed during installation). You might also want to check the permissions on the Oracle client with respect to sassrv and it's operating system groups. From the error it looks like they are getting access denied when trying to open the shared library /export/app/oracle/product/10.2.0/client_1/lib/libclntsh.so.10.1

PaulHomes · ‎02-13-2014

Oops, I got my left and right mixed up again. The "Functions: Restricted" indicator, when displayed, will be seen in the bottom right hand corner.

PaulHomes · ‎02-13-2014

BTW if your role memberships only provide you with access to a subset of the SAS Enterprise Guide capabilities, then you'll see an indication of this on the status bar. If you see "Functions: Restricted" on the status bar in the bottom left hand corner of the SAS Enterprise Guide window then you have a limited set of capabilities. You can click on the link to open a dialog and see which capabilities you do and don't have. If you don't see "Functions: Restricted" on the status bar then it means you have every capability available in SAS Enterprise Guide.

PaulHomes · ‎12-30-2013

In that case I'd suggest following it up with SAS Technical Support.

PaulHomes · ‎12-30-2013

Have you seen this SAS usage note 48235 - When you use the SAS® Framework Data Server 2.2 to install SAS® 9.3, an install.log is created but the SAS® Software is not fully installed

PaulHomes · ‎12-13-2013

You will find some useful information about this in the Q&A for SAS OnDemand for Academics at support.sas.com and in particular this one: Can I point to local SAS data sets or files using a LIBNAME or a FILENAME statement?No. The SAS Server is unable to access or recognize the local drives of your PC. If you write a LIBNAME statement or a FILENAME statement that references a local directory path, you will receive processing errors. If you are using SAS® OnDemand for Academics: Enterprise Guide, then you can upload the SAS data sets that you want to work with to the SAS Server. For more information, refer to the appropriate usage manuals available from the SAS® OnDemand for Academics Support Site.

PaulHomes · ‎12-10-2013

Thanks for that info Chris, that's really useful. I tried SAS AMO 6.1 RegAddIn.exe on my Windows 7 64 bit install but it wouldn't start - I saw WerFault.exe running in the background and there's a note about a System.IO.FileNotFoundException in the Windows application event log. It might be something odd with my install, so I'll try a clean install before tracking it to SAS tech support. Nick, I did have a look at using the SAS Open Metadata Interface today to delete the custom task capability metadata added by the SAS Enterprise Guide Task Import Wizard. I used the SAS Management Console XML Metadata Interface plug-in to drive it and ran into a small issue along the way. I took notes and wrote up a blog post about it this evening: Removing Custom Task Capability Metadata It's mainly a reminder to me about using the XML Metadata Interface plug-in, but I hope you find something useful in it too. Cheers Paul

PaulHomes · ‎12-09-2013

Hi Nick, I get a similar result to you with our custom tasks. I can register them as capabilities using SAS EG 6.1 Task Import Wizard (it seemed to only work for add-in deployment and not drop-in deployment - I need to test again to confirm that - once I can remove the capabilities). After registering via EG they then only appear in SAS MC role capabilities tab underneath the SAS EG 6.1 application tree's Custom Tasks folder. They do not appear under the SAS AMO 6.1 application tree's Custom Tasks folder. I'm assuming from reading the documentation that the SAS EG Task Import Wizard is supposed to register them for both EG and AMO (and I can't find a Task Import Wizard within AMO). Equally, now I have the capabilities registered under EG I can't remove them. I even tried uninstalling the custom tasks and rerunning the Task Import Wizard hoping it might offer to remove them The only way I can think of removing them now is to use the metadata API's DeleteMetadata method. I might give that a go tomorrow. Cheers Paul

PaulHomes · ‎09-07-2013

Hi Kim, When I work remotely I tend to establish a VPN connection and run SAS Management Console locally on my workstation and then connect to the remote server. It's by no means fast, but is quite usable. I tend to do this more from habit than anything else, and the fact I have all the profiles and settings already configured on my workstation anyway. An RDP / terminal server session should perform ok too - I just don't tend to run it that way when I'm connecting to Linux servers. I have also found that SAS Management Console when run remotely and displayed locally via ssh with X forwarding over a slowish connection is very slow. Because the term "slow" can be very subjective I've captured some rough timings for comparison. I used a workstation with a 3G mobile broadband connection to a remote network (containing a SAS 9.3 server) which itself was connected via an ADSL modem. To give you an idea of the network performance an SCP of a 10MB file from the client to the server took about 1.5m (~120KB/s) and back from the server to the client about 2m (~90KB/s). i.e. not a very fast connection. These are some timings from running SAS Management Console on the remote Linux server via ssh with X fowarding to the local workstation over this 3G mobile broadband connection: sasmc command line to login dialog: 1m38s login dialog connection to usable SAS MC session: 2m31s switch from plugins to folders tab: 40s select a different folder in folders tab: 37s This was quite painful and I'm guessing you were getting similar results. I did some Googling and saw that Java apps have historically had user interface performance problems when run remotely over SSH with X forwarding. There are some settings that can be tweaked but I think a VPN connection is simpler (if you can get one). For comparison here are some timings for running SAS MC on a local workstation connecting to the remote SAS server over a VPN over the same 3G mobile broadband connection: Running SAS MC on a local Linux workstation with a VPN connection to the server network: sasmc command line to login dialog: 8s login dialog connection to usable SAS MC session: 1m58s switch from plugins to folders tab: 5s select a different folder in folders tab: 6s Running SAS MC on a local Windows workstation with a VPN connection to the server network: from clicking shortcut to login dialog: 5s login dialog connection to usable SAS MC session: 1m55s switch from plugins to folders tab: 5s select a different folder in folders tab: 5s In this case, when using SAS MC locally and connecting remotely over a VPN, whilst the initial connection is similar (a little bit faster), moving around in the local SAS MC is much faster (than the remote SAS MC via ssh with X forwarding). I would suggest you try that method to see if you get similar results. Alternatively, as Quentin and Jaap have suggested, RDP into a Windows server in the remote network and run SAS MC on that remote Windows server (after installing the SAS clients on it). I hope this info helps you with your choices. Cheers Paul

PaulHomes · ‎09-05-2013

As Linus mentions, if you want to use call system or x then you may need to talk to your administrator about enabling operating system commands for workspace server sessions (the default is they are disabled). I wrote a blog post about this a while back: NOXCMD: NO eXternal CoMmanDs! - platformadmin.com. There's lots of handy links in the post and in the comments. If you use the DCREATE function instead then you won't need to get the admin to open up xcmd access - easier for both of you. If you are using SAS 9.3 or above then I suggest you also take a look at Chris Hemedinger's blog post: SAS trick: get the LIBNAME statement to create folders for you - The SAS Dummy. It's a neat new hassle-free technique for creating dirs.

PaulHomes · ‎07-24-2013

Hi Rob, No worries, happy to help where I can. If you want to send me your email address via a communities direct message I can arrange a copy of the custom task for you when it's available. I also remembered that I heard about something at SAS Global Forum 2013 that you might be interested in. SAS 9.4 has a new product, DataFlux Business Data Network, that provides data dictionary features for ETL. There was a paper about it: What's New in SAS® Data Management and there's a product page too. It's a web app so you could run it in a browser side by side with EG. I don't know if there are any plans to provide access to this information directly from within EG - that might be a good question for your SAS account rep. Cheers Paul

PaulHomes · ‎07-24-2013

What is underlying requirement for splitting them up? Is is security related? Is it to provide faster resources to one group of users, or perhaps more generally spread the work load over multiple storage volumes? The -work option has some builtin abilities to distribute the work directories over multiple locations. There are some links to documentation in this blog post: Spreading the WORK load For more complex requirements you could look at custom per-user/per-group configurations using something like metadata access controls on multiple application servers or restricted options. Are they mutually exclusive sets of users? Do any DI users use EM or any EM users use DI? If they are different sets it makes it easier because then you can use different SAS application servers (e.g. SASDI & SASEM) with different work configurations (and maybe other settings too) and then use metadata access controls to hide the SASDI app server from the EM users and vice versa. If there are some users that use both DI and EM then it becomes more of a training issue where you could train the users to use different app servers depending on the client app they are using (I have often thought it would be nice to also have client/application level access controls or flags that tell the clients which app servers they are allowed to use). You can see an example of using metadata access controls to direct users to different application servers in the SAS Global Forum 2010 paper A Practical Approach to Securing a SAS® 9.2 Intelligence Platform Deployment. The application servers have different config files and so can have different -work option settings. There's also the potential to use restricted options to dynamically change the -work option for different users or groups. I did a blog post about it in relation to the -xcmd option (but you can us the same method for the -work option): SAS Restricted Options on UNIX. Although the post was originally about UNIX, if you check the comments there are also some links to SAS 9.3 documentation for restricted options with Windows.

PaulHomes · ‎07-24-2013

Hi Rob, Are you primarily interested in browsing the column metadata or editing it? I did write a basic metadata column finder as a custom task for SAS Enterprise Guide (after being inspired by reading Chris Hemedinger's book on custom tasks). There's a little more info about it in a blog post I wrote at the time: Reading Custom Tasks for SAS Enterprise Guide Using Microsoft .NET. The custom task is currently read-only to metadata and provides several of the column metadata attributes (but doesn't go into associated notes, documents and extended attributes). It needed a little more polish so I'd put it on the back-burner for a while whilst I worked on other projects. When I get a chance to work on it again I can send you a copy if you're interested. I'm also quite keen to do another EG custom task that interfaces with the Metacoda Commutual product we are working on, since that will provide deeper access to SAS metadata (and associated comments/discussions). Cheers Paul

PaulHomes · ‎07-23-2013

- thanks for mentioning Metacoda and my platformadmin.com blog - In addition to everything that Jaap mentioned, there are a few other papers that might help you: These ones are quite old but they do relate specifically to SAS 9.1 and EG 4.1: TS-788 What SAS® Administrators Should Know about Libraries, Metadata, and SAS® Enterprise Guide 4.1 TS-760 Metadata Security and the DefaultACT in SAS®9 TS-750 Securing SAS®9 Business Intelligence Content Managed in Metadata These ones are for more recent versions of SAS, although many of the underlying concepts are similar so you might gain some additional info from them too: Best Practice Implementation of SAS® Metadata Security at Customer Sites in Denmark Best Practices with SAS® 9 Metadata Security A Practical Approach to Securing a SAS® 9.2 Intelligence Platform Deployment

PaulHomes · ‎07-09-2013

Hi Rob, I don't know if you've seen it but there's an interesting SAS Global Forum 2012 Paper on the topic of DI studio reporting plug-ins: Developing Custom Metadata Reports for SAS® Data Integration Studio by Michael Kilhullen. My company has written some plug-ins and applications using the SAS metadata and plug-in APIs. You can see some examples of the types of things we've done here and here. We primarily use the Java APIs. You don't necessarily have to write custom applications for querying metadata in Java. If you're a C# or VB programmer you can also the .NET APIs and write custom tasks for SAS Enterprise Guide or maybe a full blown standalone application. Chris Hemedinger wrote a great book on this (and several blog posts too). I found Chris' book very helpful when I built a basic custom task for finding tables and columns in metadata - there's a little more info in a blog post I did at the time. There are lots of different pathways for getting the metadata out and making it available, so you can pick the one that best suits your requirements and skills. Personally I prefer using Java (or .NET) for plug-ins, tasks and applications for the very rich and integrated user interface possibilities they afford, but you can also achieve a lot by using proc metadata (or the data step functions) in SAS Stored Processes too. You'll also want to study the extensive documentation on the SAS metadata model too (if you haven't already) I hope this helps. Cheers Paul

Online Status	Offline
Date Last Visited	‎02-11-2025 08:08 PM