https://communities.sas.com/t5/Developers/using-sas-stored-process-parameters-how-to-dynamically-change/m-p/3971#M1868 Hi<BR /> <BR /> I created 5 parameters in sas stored process,newdatasetname,groupno,groupsub,groupstatus,datasetlist,i am creating every time with newdata set and inserting with multiple values in(groupno,groupsub,groupstatus).<BR /> <BR /> example:newdataset name:group<BR /> <BR /> groupno groupsub groupstatus<BR /> 100 123 yes<BR /> 200 456 no<BR /> 300 789 yes<BR /> <BR /> my problem is when i creating with newdataset,new dataset name(group) must be adding to other parameter name datasetlist,i need to popup all these newdatasets list in this box.i need to updated values dynamically.<BR /> <BR /> Is it possible in sas stored process,please help me in this issue,please suggest any other solutions.<BR /> <BR /> thank you<BR /> arunpadman<BR /> 301-326-7115 Thu, 26 Jul 2007 17:29:08 GMT deleted_user 2007-07-26T17:29:08Z https://communities.sas.com/t5/Developers/using-sas-stored-process-parameters-how-to-dynamically-change/m-p/3971#M1868 Hi<BR /> <BR /> I created 5 parameters in sas stored process,newdatasetname,groupno,groupsub,groupstatus,datasetlist,i am creating every time with newdata set and inserting with multiple values in(groupno,groupsub,groupstatus).<BR /> <BR /> example:newdataset name:group<BR /> <BR /> groupno groupsub groupstatus<BR /> 100 123 yes<BR /> 200 456 no<BR /> 300 789 yes<BR /> <BR /> my problem is when i creating with newdataset,new dataset name(group) must be adding to other parameter name datasetlist,i need to popup all these newdatasets list in this box.i need to updated values dynamically.<BR /> <BR /> Is it possible in sas stored process,please help me in this issue,please suggest any other solutions.<BR /> <BR /> thank you<BR /> arunpadman<BR /> 301-326-7115 Thu, 26 Jul 2007 17:29:08 GMT https://communities.sas.com/t5/Developers/using-sas-stored-process-parameters-how-to-dynamically-change/m-p/3971#M1868 deleted_user 2007-07-26T17:29:08Z https://communities.sas.com/t5/Developers/using-sas-stored-process-parameters-how-to-dynamically-change/m-p/3972#M1869 Hi:<BR /> At this time (SAS 9.1.3), dynamic or cascading parameter values are not possible using the "standard" client applications, such as Enterprise Guide, or the SAS Add-in for Microsoft Office.<BR /> <BR /> Dynamic parameters would be stored process parameters whose value changes when the underlying data changes (for example -- you build a stored process and are doing business in Spain, France and Germany -- so you make a parameter for COUNTRY and only those 3 countries show up in the parameter value constraint/selection list. When you start doing business in Belgium -- then Belgium automatically shows up as a parameter selection choice for the COUNTRY parameter.) Cascading parameters are the kind of parameter where you pick a country from a list and the next parameter choice for city will only show you the cities in the country that you picked.<BR /> <BR /> If you need or want that kind of functionality, right now, then you are going to have to go down the path of writing your own front end application -- either with PHP or JavaScript or ActiveX or C++ or JSP or ... <BR /> <BR /> Consult with Tech Support or refer to the Integration Technologies and Stored Process Web Application documentation for examples of custom applications that use SAS Stored Processes.<BR /> <BR /> cynthia Sat, 28 Jul 2007 19:01:50 GMT https://communities.sas.com/t5/Developers/using-sas-stored-process-parameters-how-to-dynamically-change/m-p/3972#M1869 Cynthia_sas 2007-07-28T19:01:50Z