topic Re: View code of stored procedures in Developers

View code of stored procedures

deleted_user — Thu, 23 Apr 2009 09:45:51 GMT

Hi,

I am very new to SAS but need to view the code of a stored procedure through DI studio and I am unsure how to do this and as it is on a live system I do not want to experiement.

Thanks

Re: View code of stored procedures

Cynthia_sas — Thu, 23 Apr 2009 14:52:55 GMT

Hi:
SAS uses stored process programs (not stored procedures) which are stored in a location known to the metadata. This location is called a stored process repository.

If you use SAS Management Console to look at the stored process property information, you will see where that location is on the Execution information tab. In addition, on another tab, you will see the parameters that are set for that particular stored process.

Once you know the correct location, you could look at the stored process code with Notepad or any text editor. However, I suggest that you talk to the stored process developer or author or your SAS Administrator for more help with your task. It is possible that looking at the stored process code won't answer your question, (particularly if the stored process is using a lot of macro programming) and it's handy to know who the other folks are who are responsible for configuring and using the SAS Enterprise Intelligence Platform.

cynthia

Re: View code of stored procedures

deleted_user — Tue, 28 Apr 2009 14:41:03 GMT

Please can you tell me how to check the stored process property information in SAS management console so I can check its location please?

Many thanks.

Re: View code of stored procedures

venkatesh — Wed, 29 Apr 2009 14:03:28 GMT

Hello Kevrow,

If u want see the stored process(sp) program code which is created in DI studio.

While creating sp in di studio, u will get stored process name with icon----right click-->properties--> execution
here u will find the path(location of the stored process) it will be saved in the form of xxx.sas

u can open these with note pad or eg or sas 9.1.3.

Cheers,
Venky.

Re: View code of stored procedures

deleted_user — Fri, 01 May 2009 13:24:41 GMT

Many thanks, I have now found the code using your description and we are investigating.