08-24-2016 09:24 AM - edited 08-24-2016 09:47 AM
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.
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.