topic Re: SAS EG 5.1 prompt macro vars not resolving correctly in SAS Enterprise Guide

SAS EG 5.1 prompt macro vars not resolving correctly

glmsas — Thu, 13 Mar 2014 15:14:01 GMT

Hello, i create a project and added a prompt window at the first object to run.

it ask for several items. in the middle there's one line that shows listin prompt with a folder/file location

here's the log from after this prompt ran with the copy files to/from SAS server tool that Chris wrote.

the folder in blue below is not what is in the prompt window above.

running a %put _user_; show me this in the macro var

GLOBAL LISTIN G:\ICQ\Pricing Quality\Projects\2013 EG Test Folder\gm_test

which is what the macro resolvs to below.

i've hit the reset button at top right and re-entered the prompts and still not getting my current line entry above.

Suggestions?

thanks

gary

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %let _egcopySource = &listin;
4          %let _egcopyTarget = &work278_location;
5          %put Source files resolve to &_egcopySource;
Source files resolve to G:\ICQ\Pricing Quality\Projects\2013 EG Test Folder\gm_test
6          %put Target folder resolves to &_egcopyTarget;
Target folder resolves to /users/work278/nbk1hhk/test
7
8          QUIT; RUN;
9

NOTE: Source file resolved to G:\ICQ\Pricing Quality\Projects\2013 EG Test Folder\gm_test
NOTE: Target folder resolved to /users/work278/nbk1hhk/test

ERROR: File G:\ICQ\Pricing Quality\Projects\2013 EG Test Folder\gm_test does not exist on FF01FAF2C0774

Re: SAS EG 5.1 prompt macro vars not resolving correctly

Reeza — Thu, 13 Mar 2014 15:46:47 GMT

Are the other variables changing? If so you most likely set it somewhere else in the code, for testing probably?

Re: SAS EG 5.1 prompt macro vars not resolving correctly

glmsas — Thu, 13 Mar 2014 16:08:05 GMT

no this is the first object in the project.

i did run the prompt window several times before and had that directory in there at one time.

But on subsequnent runs the macro var never got updated.

and that seems to be the problem

Re: SAS EG 5.1 prompt macro vars not resolving correctly

Reeza — Thu, 13 Mar 2014 16:20:35 GMT

Add some %put statements at various points to see your variable status, directly after the prompt, before being used and any other place.

This will allow you to narrow down where to look.

Also, check the scope, is it global or local variable.

Re: SAS EG 5.1 prompt macro vars not resolving correctly

glmsas — Thu, 13 Mar 2014 16:30:55 GMT

see the first post for the log from that prompt from that object.

the listin in the prompt window does not match what is in the log macro resolution

G:\ICQ\Pricing Quality\Projects\amn.xlsx in the prompt window

and

G:\ICQ\Pricing Quality\Projects\2013 EG Test Folder\gm_test in the macro var

Re: SAS EG 5.1 prompt macro vars not resolving correctly

glmsas — Thu, 13 Mar 2014 18:44:39 GMT

ok, i put a data _null_; program before the Copy object and put the Prompts in that Program and then linked it to the Copy and the macros resolved fine.

So it doesn't look like the Prompt macro timing is not availible in the step that uses it?

gary

Re: SAS EG 5.1 prompt macro vars not resolving correctly

Reeza — Thu, 13 Mar 2014 19:03:59 GMT

When you defined your macro variable did you set it as global?

See the screenshot from Chris@SAS

Re: SAS EG 5.1 prompt macro vars not resolving correctly

jakarman — Thu, 13 Mar 2014 19:09:06 GMT

How did you define the prompts in the EG-project:
- which options (global?)

- which macro-vars for each prompt (not being duplicated?)

- as running on Unix (/users/work) any settings for parallel execution activated?

Re: SAS EG 5.1 prompt macro vars not resolving correctly

glmsas — Thu, 13 Mar 2014 19:19:24 GMT

yes the use though out project box was checked for all

Re: SAS EG 5.1 prompt macro vars not resolving correctly

Reeza — Thu, 13 Mar 2014 19:20:52 GMT

Contact tech support then.