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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.