How do you prevent SAS stored process to show the log when users add _debug=log in the url
When you run a SAS Stored Process (STP) with some url parameters
https://xxx.xxx.xxx/xxx?_program=yyy/yyy&aaa=aaa
anyone can see the log by adding _debug=log in the url parameters.
Is there a way to prevent that possibility?
I would like to hide the log from my users.
(Not only when errors occur, for that cf. http://support.sas.com/kb/16/225.html)
EDIT: I forgot to specify that I'm looking for a solution that would not impact other STP's, only one.
If you're using SAS Enterprise Guide these are the steps that I went through to reject showing the SAS Log running the stp on the web:
1) Right Click to modify the stored process
2) Go into "prompts" and create a new prompt
3) Set the first tab values to this:
4) In the second tab, select prompt type of "variable"
5) Click to check the default value box and leave the default value blank
Now when a user tries to run the stored process from the web with &_debug=log they should see an error not allowing them to:
- 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?