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.
It show below detail like
Customerno Customerid customername productname productcode porchdate
CN111 111 RAM TV PD2 12JAN2012
CN111 111 RAM FREEZE PD1 09JAN2012
Customerno CN112
Then it show like
Customerno Customerid customername productname productcode porchdate
CN112 112 HARI TV PD2 10JAN2012
CN112 112 HARI FREEZE PD1 13JAN2012
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.