Stack Overflow
Stack Overflow

Questions tagged [sas-stored-process]

24 questions
4
votes
1 answer

Use a SAS Stored Process in ASP .NET Visual Studio. SAS integration technologies?

I have some SAS Stored Processes. When i run the stored processes in SAS Enterprise Guide I get some HTML returned. What i would like to do is make my ASP .NET project connect to the Stored Process and return the HTML in my ASP .NET application. I…
crellee
  • 855
  • 1
  • 9
  • 18
3
votes
1 answer

How to show message if the output is empty after filtering in sas

I’m trying to show a message or another table with empty record if the result is empty after putting an input. See below codes: %if (&number ne) %then %do; Proc print data=Lib.table; Var “number”n “name”n “age”n; Where…
Samantha
  • 31
  • 3
3
votes
0 answers

SAS IOM Bridge with Python

I'm making a connection to a remote SAS Workspace Server using IOM Bridge: import win32com.client objFactory = win32com.client.Dispatch("SASObjectManager.ObjectFactoryMulti2") objServerDef =…
submit
  • 53
  • 2
3
votes
3 answers

Get values of Macro Variables in a SAS Table

I have a set of input macro variables in SAS. They are dynamic and generated based on the user selection in a sas stored process. For example:There are 10 input values 1 to 10. The name of the macro variable is VAR_. If a user selects 2,5,7 then 4…
learnlearn10
  • 169
  • 1
  • 3
  • 15
3
votes
4 answers

Use image in a SAS Stored Process's HTML Stream

I am creating a report with SAS STP and I want to display a image(a logo) on the report. Okay here is what is happening: data _null_; file _webout; put ''; put ''; run; I am PUTing HTML because I have complex table formats…
Moon
  • 19,518
  • 56
  • 138
  • 200
2
votes
3 answers

Is there a easy method to copy Stored Process in SAS?

I am creating 40+ Stored Processes in SAS EG (Programs already written) and I am creating Stored Processes so that end users can run them without my intervention. Its a sloooow progress! Each SP has to be created individually. The SPs are generally…
Jeff Haynes
  • 83
  • 2
  • 9
2
votes
2 answers

Execute SAS Stored Process with Python

I know there is a method where you can call a stored process via the SAS Stored Process Web Application, but I was wondering if there is a method where i can call the stored process server directly. The goal is to call a stored process which…
submit
  • 53
  • 2
2
votes
3 answers

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…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
2
votes
2 answers

CACHE access method

I'm debugging a Stored Process Web Application that writes a PDF to _webout. I'd like to avoid the following ERROR when running in a workspace session: ERROR: Function is only valid for filerefs using the CACHE access method. I've tried filename…
Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
2
votes
1 answer

In SAS/HTML/javascript, how do you close a STP _webout html page immediately after it opens?

From a form in a web page, I'm opening a stored process (STP) in a new window.
that STP does someting and when it's done I need to close it's window. So…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
2
votes
1 answer

Which version of SAS is compatible with SAS Stored process version 2.0? Is it compatible from version 9?

SAS Stored process 2.0 is compatible with SAS 9.3, but wanted to know if it is compatible with all versions starting from SAS 9 to SAS 9.4?
Kary231
  • 21
  • 1
  • 2
1
vote
2 answers

SAS Stored Process STP web: How to reference html file for file _webout instead of put statements?

So I've seen various pages that inform SAS Stored Process users creating stored process web pages how to do something like: https://support.sas.com/documentation/cdl/en/stpug/62758/HTML/default/viewer.htm#p0q383asmm4bejn1i7z4q7iv5eke.htm data…
Krusaderjake
  • 479
  • 1
  • 7
  • 19
1
vote
2 answers

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…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
1
vote
1 answer

In a SAS stored process, is there a way to identify the server which called it via ajax

I have a public Stored process (STP) in which I would like to be able to identify which page is calling it, via ajax. The STP is momentarily set to run with a guest account and is thus public. I thought to do it by inserting a secret Key in the STP…
stallingOne
  • 3,633
  • 3
  • 41
  • 63
1
vote
1 answer

SAS - Stored process is greyed out

I am very new to using the SAS Enterprise Guide but have been using older versions of SAS for a while. I also work a little in Javascript. Until today I was not aware these can be combined. I am trying to follow this tutorial. Interactive Charts and…
Catnipper
  • 53
  • 5
1
2