Cascading Prompts dynamically

[vasireddy]

Hi,

I am trying to populate the dataset based on the previous selection from a different dataset. How ever, I am not successful doing so. Could you please guide me on this topic.

Example: 

Prompt1: User selects the module from dataset1.Based on the module, the xlsheet is uploaded to a dataset2.

Prompt2: Should contain the values of dataset2.

proc import datafile=&DD_location. out=SASTEMP.tablelist
DBMS=dlm REPLACE;
GETNAMES=YES;
delimiter=";";
RUN;

But this code should be executed immediatly after selecting the Prompt1. So that, in Prompt2 I could use the tablelist.

Thanking you.

Kind regards,
Ajay

[Cynthia_sas]

Hi:
If you are generate dynamic prompts for a SAS Stored Process, then this should be posted to the Stored Process Forum.
cynthia