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;
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.
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;
Thank you for the help. Worked great
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.