topic Re: Change the output name of a table based on a processmonth parameter in SAS Enterprise Guide

Change the output name of a table based on a processmonth parameter

DanielLopez — Sat, 05 Dec 2015 15:41:36 GMT

How can I "actively" change the output name of a Table in Sas Enterprise Guide using a &processmonth parameter, using a query builder?
For example if I'm running data for 2015-12 and i want for the final table to have a standard name prefix such as: "SAS_PM_BEHAVIOR_&processmonth"
Can this be done with Query Builder? I tried but it disn't work.
Help please to all you SAS gurus out there!

Re: Change the output name of a table based on a processmonth parameter

Reeza — Sat, 05 Dec 2015 18:04:07 GMT

I believe so. There's a place in Query Builder to specify the output table name. There you can place the code you have above.

Re: Change the output name of a table based on a processmonth parameter

Patrick — Sat, 05 Dec 2015 22:26:32 GMT

What @Reeza proposes works in my EG version (7.11) only if changing the table name via Options/Change Button as shown below.

If I just enter the name into the "Output name" field then it get's quoted as name literal and generates code like

CREATE TABLE WORK.'test&test'n AS

Only after the rename via "options" drop-down I'm getting the table name generated without quoting.

CREATE TABLE WORK.test&test AS

Re: Change the output name of a table based on a processmonth parameter

DanielLopez — Mon, 07 Dec 2015 16:04:43 GMT

First of all thanks for answering so quickly.

I just tried this but I get the following error:

Any clues?

Re: Change the output name of a table based on a processmonth parameter

Patrick — Mon, 07 Dec 2015 19:31:02 GMT

It works in my 7.11 EG version.

Re: Change the output name of a table based on a processmonth parameter

DanielLopez — Mon, 07 Dec 2015 20:34:55 GMT

Do I have to set up a special condition under the Prompt Manager option or Tools>Options?

Do you think it might be due to the EG version that I have which is earlier than yours?

DLP

Re: Change the output name of a table based on a processmonth parameter

Patrick — Tue, 08 Dec 2015 11:56:51 GMT

I've run first the following code for my test.

%let test=myTest;
data test;
  set sashelp.class;
run;

Then I've used the query builder as alredy posted.

If this doesn't work for you then I must assume it's caused by an earlier version of SAS EG.

Re: Change the output name of a table based on a processmonth parameter

Reeza — Tue, 08 Dec 2015 15:41:28 GMT

What version of EG do you have? I would also considering a quick call to Tech Support or a repost to EG group so that some of the EG users can help.

Re: Change the output name of a table based on a processmonth parameter

DanielLopez — Tue, 08 Dec 2015 16:15:10 GMT

I'm using version 5.1. Could that be the reason it does not work?
I will try calling Tech Support. Any other help on this is deeply appreciated.
Thanks

Re: Change the output name of a table based on a processmonth parameter

ChrisHemedinger — Tue, 08 Dec 2015 16:16:20 GMT

The solution that @Patrick supplied is creative, but it's a bit of a trick that might be working by accident, and not by design.

As far as I know, there isn't an official method to substitute in a macro value for the output data name in the Query Builder. My suggested workaround would be:

- Create the query to output to a known, static name (ex: work.currentmonth).

- Link a subsequent program node that renames/copies that data set to the name you want, using the macro variable that you supply. You could do this with DATA step or PROC COPY or PROC DATASETS.

Chris