Prompt value in a table name

[DBAgFinance]

Does anyone know how to use a prompted value to select an existing table in a SAS program using EG.  In the example below I am trying to create a table from the values in the table fact_qtr1_year2015.  Can a prompted value be used in a table name.

Example:

Proc SQL;

     Create table work.example as

     select    company,

               portfolio,

               balance

     From libname.Fact_qtr(prompted value)_year(prompted value)

Quit;

run;

[slchen]

You could try to define prompted value as macro variable, such as:

%let qtr=1;

%let year=2015;

Proc SQL;

     Create table work.example as

     select    company,

               portfolio,

               balance

     From libname.Fact_qtr&qut._year&year;

Quit;

[DBAgFinance]

Thank you for the help.  Worked great

[Kurt_Bremser · Accepted solution]

The results from user defined prompts in Enterprise Guide are stored in macro variables. So your final "from" would look like this:

From libname.Fact_qtr&qtr._year&year

Note the dot after the first reference to a macro variable; this is necessary so that the macro processor knows it must look for &qtr and not for &qtr_year.

The actual macro variable names depend on the definition of your prompts.