Tag: Administration

Angela Hall 2
My Favorite SAS Resources

New and Long Standing SAS Customers alike ask for advice on where to find information to troubleshoot and learn about SAS. Included below is a running list of URLs that SAS Users can find useful for finding information! SAS Community     http://www.sascommunity.org SAS Conferences Paper Search     http://www.lexjansen.com/ SAS Support

Angela Hall 0
Supporting a SAS Server Architecture

My prerogative has always been to share my knowledge with the entire SAS user community (hence this blog & all my SAS papers). For an approach to supporting the entire SAS Server Architecture, I presented a paper at the SGF 2009 conference and created a Wiki page in SASCommunity.org to

Angela Hall 4
SAS Enterprise Guide across a proxy firewall

We recently confirmed (via http://support.sas.com/forums/forum.jspa?forumID=10&start;=0) that SAS Enterprise Guide does not support proxy servers between itself and SAS servers (metadata, workspace, stored process, etc). However, if the proxy server can be transparent then EG can work through it. While implementing SAS BI at a customer site we needed to access

Angela Hall 4
Example to Encode SAS Passwords

Within SAS Run the following code (the purple text is the password you would like to encode): proc pwencode in='myn3wpwd4u'; run; After submitting this code (F3), the resulting encoded password in available only in the log file. The results from this example are below, the highlighted line is the encrypted

Angela Hall 0
Stored Process - Pass through Authentication

In the past we’ve had a lot of issues with calling stored processes from the SAS Portal without being “re-prompted” for authentication. We’ve tested this approach out and it works. http://support.sas.com/kb/19/234.html (Submitted by Brian Miles, Zencos Consulting)

Angela Hall 0
Perfmon for Windows - or Souped up Task Manager

I have used this with much success with clients' Windows servers. It makes searching on .sas batch programs, determining which sas.exe is for what BI server, etc. Use the 'Find' function and simply type in the .sas file or BI service component you are looking for. This also provides more

Angela Hall 0
Password Changes in BI

Included are some resources to help those of you who need to change SAS account passwords on your BI installation. (Notice: This is not for the faint of heart.) http://support.sas.com/rnd/papers/sugi31/securedeployment.pdf http://support.sas.com/documentation/configuration/bisecag.pdf (Chapter 5 & specifically pg98-102) http://support.sas.com/techsup/technote/ts736.pdf Side Note: SAS Technical Support and R&D; have a utility in their 'toolpool'

Angela Hall 0
Password Tricks

By the way if you want to decode a {sas001} encoded password just remove the prefix and feed it into this page: http://www.opinionatedgeek.com/dotnet/tools/Base64Decode/Default.aspx

Angela Hall 0
SAS Service Configuration Utility

For BI Installations, a SAS Service Configuration Utility is available to manage your sas services in a window's environment. Go to Start->Programs->SAS->SAS 9.1 Utilities->SAS Service Configuration Utility. You can install, remove, and set options on the Windows Services. (Thanks goes to Bryan for pointing neat utility out.)