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.
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 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.