BookmarkSubscribeRSS Feed
SAS Employee
HI, all
I am a newlearner of sas stored process server.My situation is :
1.There is one stored process server in one host;
2. I connect the server from different machine through IE;
3. If I connect the server at almost the same time, how many sessions in the stroed process server. If different client has different session , how can I get the sessionID. Can you give some document to learn about such issues.
4. when I investigated the sas document of stroed process ,there are reserved macro variables ,such as _SESSIONID, but this macro variable is created only if a session has been explicitly created. I do not want to create a new session ervery time .
5.When I use the macro variable in a sas stored process , the value of _RMTADDR is different during every time I connect the server through different IE.How can the server realize this?

Thanks in advance!

Message was edited by: tony@sas Message was edited by: tony@sas
The answer to this question is very installation specific. For an overview of one company's experience with installing and configuring the Enterprise Intelligence Platform, this SAS Global Forum paper gives you a good idea of what your SAS Administrator had to know to set things up at your installation.

Generally, the person writing stored processes does not worry about how many sessions are available or how the servers are handling requests. This falls under the category of tasks taken care of by the SAS Administrator for an installation.

All of these questions fall under the general category of "Platform Administration" and the person who installed the Enterprise Intelligence Platform should have a set of manuals available that go over the WHOLE installation process, including setting up the stored process server and using sessions.

We have a set of classes under the Platform Administration category:

and a self-paced learning class (that I've heard takes about 13-15 hours to complete):

So as you can see, this is not a quick question. If you have an urgent or immediate need for help, you might consider contacting SAS Technical Support.

SAS Employee
Hi, Cynthia,
Thanks a lot for your so quick response!

I have readed the log of the store process, I find that every time I connect the stored process server, the sas.portal.sessionid and the sas.stp.sessionid are different . But during every connection ,these two variable are unique. The every connection is every time I login from the same machine or different host.During once login, these two variable are unique.

Now , my question is how can I get the value of these two variables?

I can get the value of the macro variable, such as _RMTADDR .But these two variables are not the macro.

The log is listed below, and the sas.portal.sessionid and the sas.stp.sessionid have been marked by black fonts.

Thanks in advance!

NOTE: %INCLUDE (level 1) ending.
=============== STP Context 36 Log End ===============
20070821: 00002659: 35:sasadm: STP: Releasing Lock on Session 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821: 00002659: 35:sasadm: STP: 36: Not Saving session 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821: 00002708: 35:sasadm: STP: 36: Context Close
20070821: 00002708: 35:sasadm: STP: Session Deleted 1391CA6F-2EDB-48C6-9D61-449A609D99BE
20070821: 00002708: 35:sasadm: STP: Sending cost=0 to Load Balancer. tkStat=0
20070821: 00002712:ERROR: The tcpSockRead call failed. The system error is 'The connection was reset by a peer.'.
20070821: 00002712:NOTE: Bridge protocol engine socket access method failed to read from socket, error 10054 (The
connection was reset by a peer.).
20070821: 00002708: Client connection (35) closed.
20070821: 00002714: New client connection (36) accepted from server port 8631 for user sasadm@CRDIT012TONY.
Encryption level is Credentials using encryption algorithm SASProprietary. Peer IP address and port are
20070821: 00002675: 36:sasadm: STP: Creating New Context: Data\misdata\proccode\spo, sessionID=
20070821: 00002675: 36:sasadm: STP: CreateContext: Context ID: 37, Address=0x1dd7c80
20070821: 00002675: 36:sasadm: STP: Sending cost=101 to Load Balancer. tkStat=0
20070821: 00002717: 36:sasadm: STP: Setting Lock on Session 3CE1EF5E-2414-4508-A179-EEC4DDEFAB65
20070821: 00002717: 36:sasadm: STP: 37: Executing Data\misdata\proccode\spo
20070821: 00002717: 36:sasadm: STP: 37: Execution Complete. Status=0
=============== STP Context 37 Log ===============
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)

94 The SAS System 15:19 Tuesday, August 21, 2007

Licensed to Employee SID, Site 0047162208.
NOTE: This session is executing on the NET_SRV platform.
NOTE: SAS 9.1.3 Service Pack 4
WARNING: Only Base procedures and SAS/STAT procedures have been tested for use with VALIDVARNAME=ANY. Other use of this option is
considered experimental and may cause undetected errors.
NOTE: SAS Initialization used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

>>> SAS Macro Variables:
__utmz=234506268.1185257397.9.3.utmccn=(organic)|utmcsr=google|utmctr=sas%2Fshare|utmcmd=organic; sasitvid=2942428441.856029;
sas.portal.sessionid=GL02jGY7FwLvZVSbPnkLQvNKdMznH0qVcmVkKNGxWMvW5xKTWr32!494598364; sas.stp.sessionid=GL0GpfV2ZFtM5z5PK0v4TpTPKBBrL4WQvXrbqFpMFwgV1vz6GrRB!494598364

_HTUA=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
_VERSION=Version 9.1.3 (Build 348)
_METAPERSON=SAS Administrator
1 options nosource source2 center notes nodate nonumber ls=195 formchar='|----|+|---+=|-/\<>*' pagesize=40 noovp nomprint
nomlogic nosymbolgen; title; footnote;

Depending on how you're running the stored process, this documentation may help you:

Your best bet for help with this question is to contact Technical Support.

SAS Employee
Thanks a lot!



Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.


Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 2 in conversation