Determining Server Context (Workspace Server vs Stored Process Server)
I'd like to conditionally execute code depending on whether I'm in a Workspace or Stored Process server context.
I could do this by testing the existence of an automatic STP variable, eg _metaperson, but this wouldn't be very robust.
Assuming I already have a metadata connection, how best to check my server type?
Solution
Hurrah - there is, in fact, an automatic variable that does just this - sysprocessmode (available since 9.4)
Extract from documentation:
SYSPROCESSMODE is a read-only automatic macro variable, which contains the name of the current SAS session run mode or server type, such as the following:
- SAS DMS Session
- SAS Batch Mode
- SAS Line Mode
- SAS/CONNECT Session
- SAS Share Server
- SAS IntrNet Server
- SAS Workspace Server
- SAS Pooled Workspace Server
- SAS Stored Process Server
- SAS OLAP Server
- SAS Table Server
- SAS Metadata Server
Being an automatic variable, it is of course read only:
- Cannot open %INCLUDE file, file doesn't exist. SAS Studio
- Exported file from R using `haven` cannot be opened by SAS
- SAS change data type when sending it by ODBC
- Move values of a variable where not missing the value of another one
- Make histogram in SAS from aggregated data
- Create table that splits records on specific dates using SAS
- Pattern matching in any position of a variable value
- How to loop to get column name?
- In SAS, is there a way to run multiple proc freqs with different formats in a macro?
- Sum values only over replicated dates
- Set the value of a variable based on the previous value of another variable
- remove trailing spaces inside SAS macro
- Dedup based on the value of a variable
- Uniform a variable value by other variables
- Replace values in a dataset with values in another dataset but only when a variable takes a specific value
- Add a flag based on another dataset
- Update an Index variable based of the values it takes
- Retain only the first value of a variable
- Assign as value of a variable the output of a proc summary
- Remove a specific suffix in variable names
- Update actual records of a variable based on the date before
- Can anyone help me write a R data frame as a SAS data set?
- SAS Modified Program Date/Time
- Sum by IDs and variables
- How to sort data using Data step in SAS
- SAS Proc transpose wide to long multiple variables
- How to use folders with spaces in SAS x "copy ..."?
- Flag observations with same ID/Date but different result
- How is the SAS proc sql create table (where=()) option different to a where clause in the sql query and when should it be used?
- Order of the relative operator in SAS?