topic Prompt value in a table name in SAS Procedures

Prompt value in a table name

DBAgFinance — Tue, 26 May 2015 21:11:21 GMT

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;

Re: Prompt value in a table name

slchen — Tue, 26 May 2015 21:27:06 GMT

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;

Re: Prompt value in a table name

Kurt_Bremser — Wed, 27 May 2015 07:20:29 GMT

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.

Re: Prompt value in a table name

DBAgFinance — Wed, 10 Jun 2015 21:31:39 GMT

Thank you for the help. Worked great