How to create dynamic column names in SAS EG Query Builder using a prompt value?

[sass_numero_uno]

Using a prompt, which takes a single integer numeric value, eg 4. How can I use this prompt to create a dynamic column name.

I use the prompt value to bring through certain columns, called something like "Names".

I would like to be able to name the columns something like "Names_Year_X".

Where X is the prompt value.

I have tried referring to the prompt value by using methods such as "Names_Year_&Prompt" and "Names_Year_&&Prompt&Prompt". 

However, none of the above methods work, nor do a number of others I've tried. Does anyone have any advice for house this might work? Preferably using the Query Builder, but if not using a program node for some code is a secondary back up option. 

[tomrvincent]

Have you tried adding a computed column with the name Names_Year_&Prompt?

[sass_numero_uno]

Yes. I have attempted this, and it just appears as what a literally type, so in this instance, "Names_Year_&Prompt"

[andreas_lds]

Please post the full code you used to create the dynamically named column.

[tomrvincent]

Take the code from your query builder and put it into a new program, then just change the single quotes to double quotes.