topic Re: Creating a Prompt in a Query in a Computed Column in SAS Enterprise Guide

Creating a Prompt in a Query in a Computed Column

winterfell — Thu, 30 May 2019 19:39:11 GMT

I have large datasets that I need to calculate fees on. The fee is constantly changing. Currently I have a query with a computed column that I edit with the new percentage in order to get the fee amount. Is there a way to create a prompt so I can just enter in the new percentage amount, and the computed column formula will change without going into the query?

For a simple example, all of the rows in my data will have a 1% fee today. Tomorrow my new data will have a 2% fee.

Or is there at least a way to get a prompt to come up that says "remember to change the % amount"?

Thanks!

Re: Creating a Prompt in a Query in a Computed Column

Patrick — Fri, 31 May 2019 06:44:54 GMT

1. Define a prompt. Let's call it Fee

2. Use the prompt in the formula of your calculated column, i.e. amount * &Fee

Re: Creating a Prompt in a Query in a Computed Column

winterfell — Fri, 31 May 2019 12:56:50 GMT

This worked perfectly, thank you so much for your help!