https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-causing-errors-after-migrating-from-EG-4-1-to-4-3/m-p/69494#M6933 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...<BR /> <BR /> ERROR: The following columns were not found in the contributing tables: April_11, Calculation1, Calculation2, Calculation3, ROA.<BR /> <BR /> 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?<BR /> <BR /> Any help is much appreciated!<BR /> <BR /> Thanks! Wed, 25 May 2011 19:14:02 GMT RLee 2011-05-25T19:14:02Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-causing-errors-after-migrating-from-EG-4-1-to-4-3/m-p/69494#M6933 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...<BR /> <BR /> ERROR: The following columns were not found in the contributing tables: April_11, Calculation1, Calculation2, Calculation3, ROA.<BR /> <BR /> 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?<BR /> <BR /> Any help is much appreciated!<BR /> <BR /> Thanks! Wed, 25 May 2011 19:14:02 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-causing-errors-after-migrating-from-EG-4-1-to-4-3/m-p/69494#M6933 RLee 2011-05-25T19:14:02Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-causing-errors-after-migrating-from-EG-4-1-to-4-3/m-p/69495#M6934 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.<BR /> <BR /> 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.<BR /> <BR /> Tom Thu, 26 May 2011 01:13:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-causing-errors-after-migrating-from-EG-4-1-to-4-3/m-p/69495#M6934 TomKari 2011-05-26T01:13:36Z