The problem you are having is that when a Stored Process is registered in the SAS Management Console (SMC), there is no facility to enable you to point to a SAS data set containing the values for the parameters. EG does allow this when you register a stored process, but it takes the values at the time you register the stored process and inserts them as values in the SMC.

If you want to make the list dynamic and control what the default is, I know of two choices:

1. Write another stored process which accesses the data set and presents the user with the dynamic list and then invokes your current stored process.

2. If you are using the SASStoredProcess web app, you can write a custom JSP page as defined in this link:

http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/webinput.html

Scroll down to "Custom Input Form" to see the details.

HTH, Don Henderson

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of A Royal Sent: Tuesday, October 03, 2006 9:19 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Stored Process parameter default of today's date

I have a stored process which runs a web report by the date selected. The program was written in SAS but the stored process was set up in Enterprise Guide, including the parameter list of the date variable.The parameter given is several months worth of dates on a drop down menu which a user selects one. These dates are past present and future dates. For example, the dates are Sept 1 thru Nov. 30th.

Is there a way I can programatically set the default date showing on the drop down menu to be the current date? In the parameter menu it only allows me to choose one date from the list, and I would have to manually reset that everyday. Currently the default is the first one on the list.

Any ideas?

_________________________________________________________________ Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip