how to create drop down in storeprocess

[Ashwini]

I  have a sas datasetcustomer detail like

Customerno   Customerid  customername  productname productcode  porchdate 

CN111           111                RAM               FREEZE         PD1              09JAN2012

CN112           112                HARI              TV                   PD2             10JAN2012

CN113           113                GOPAL           FAN                PD3             04JAN2012

CN111           111                RAM               TV                   PD2             12JAN2012

CN112            112                HARI              FREEZE          PD1            13JAN2012

CN113            113                GOPAL           TV                   PD2             15JAN2012

Productcode:-PDI is FR

                       PD2 is T

                      PD3 is  FN

I have to create a stored process .In this store process  I have to create 3 dropdown selection like Customername ,Productname, productcode.

1. If I     select customername RAM  and TRUE .

      It show below detail like

Customerno   Customerid  customername  productname productcode  porchdate 

CN111           111                RAM               TV                   PD2             12JAN2012

CN111           111                RAM               FREEZE         PD1              09JAN2012

2. If  select customername HARI and TRUE

              Customerno     CN112

Then it show like

Customerno   Customerid  customername  productname productcode  porchdate

CN112           112                HARI              TV                  PD2              10JAN2012

CN112            112                HARI              FREEZE          PD1            13JAN2012

3. If  select productcode FR only it show

Customerno   Customerid  customername  productname productcode  porchdate

CN111           111                RAM               FREEZE         PD1              09JAN2012

CN112            112                HARI              FREEZE          PD1            13JAN2012

If we select customername  HARI and TRUE

                    Customerno       CN112

                   Productcode       FR

It show like

Customerno   Customerid  customername  productname productcode  porchdate

CN112            112                HARI              FREEZE          PD1            13JAN2012                   

As per mention logic how we create drop down selection instored process .using sas macro, base sas and sas sql .Kindly help me .

Thanks and Regards,

Ashwini

[NN]

Hi,

Which version of sas are u using ?

In 9.2 and above you can create dyamic and cascading prompts using a registered sas table.

I Think the below document should guide you ...

... additionally you should also look at the sas stored process developers guide.

http://support.sas.com/resources/papers/sgf09/355-2009.pdf

hope it helps