Dynamic parameter creation

[sunilreddy]

Button   Date            status

1.1      03FEB2012     OK

1.1      05MAR2012    SKP

I have above data in SAS dataset. I have a stored process to select the Button(1.1, 1.2, 1.3 etc), if i select any button it needs to validate the data against to month in above table and it should display the status as active or inactive in stored process prompt.

any one can help me in this

[Cynthia_sas]

Hi:

  It sounds to me like you are defining a dynamic prompt or building a selection group that will be linked to some kind of macro programming logic in your program. You might want to look in the Stored Process Developer's guide for more information about building dynamic prompts and using selection groups. Here's a place to start:

http://support.sas.com/documentation/cdl/en/stpug/62758/HTML/default/viewer.htm#n04zozyzrfsilkn10wjv...

http://support.sas.com/documentation/cdl/en/stpug/62758/HTML/default/viewer.htm#p01mnxrcktko66n1ihl5...

  Here's a blog about selection groups:

http://blogs.sas.com/content/bi/2009/11/10/using-multiple-selection-prompts-in-sas-stored-process-co...

  Or these papers:

http://support.sas.com/resources/papers/proceedings11/050-2011.pdf

http://support.sas.com/resources/papers/proceedings10/041-2010.pdf

cynthia