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
Tag: Administration
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
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
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
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)
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
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'
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
So you have installed the SAS System, and you can check what is licensed with the proc setinit command, but what if something hiccuped in the install. Or your supporting (I mean validating) someone else's install and you need to quickly see what is available? Included below is some 'found'
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.)