I don't fully understand what you want to do. But a prompt is mainly used to select input parameters for the rest of your code. It is not specifically used to feed a table with data.  The prompt generates macro variables that could be used in the dialog boxes in EG or in code. The code could of course use the macro to create data in a data set, but I don't think that you want this.  If you want a way to look at a new data set and figure out what it is about, then prompts are not the way to go. ... View more

I don't fully understand what you want to do. But a prompt is mainly used to select input parameters for the rest of your code. It is not specifically used to feed a table with data.  The prompt generates macro variables that could be used in the dialog boxes in EG or in code. The code could of course use the macro to create data in a data set, but I don't think that you want this.  If you want a way to look at a new data set and figure out what it is about, then prompts are not the way to go. ... View more

Modify the PROC COPY to select only the sheets of interest, using the SELECT statement. proc copy in=mylib out=work; select sheet1 sheet2; run; ... View more