Desktop productivity for business analysts and programmers

Prompts causing errors after migrating from EG 4.1 to 4.3

Reply
N/A
Posts: 1

Prompts causing errors after migrating from EG 4.1 to 4.3

We have recently migrated from EG 4.1 to 4.3. I have a query set up which prompts for both the time period (example format = April_11) and a scenario (example format = Plan). Whenever I attempt to run the query in 4.3, the prompt entry box will come up and allow me to enter my selections. However, the query fails and tells me I have syntax errors. I also see the following error message in the log file...

ERROR: The following columns were not found in the contributing tables: April_11, Calculation1, Calculation2, Calculation3, ROA.

Is this a migration issue? Or do prompts work differently in 4.3 than in 4.1 to where the queries will need to be re-written?

Any help is much appreciated!

Thanks!
Trusted Advisor
Posts: 1,056

Re: Prompts causing errors after migrating from EG 4.1 to 4.3

It's very hard to tell with this amount of information. In future, it will make it easier to diagnose these if you post the log as well.

My feeling is that you didn't use the "Enclose value in quotes" option, so SAS is picking up one of your selection constants as a variable.

Tom
Ask a Question
Discussion stats
  • 1 reply
  • 79 views
  • 0 likes
  • 2 in conversation