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

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

sass_numero_uno — Wed, 29 Jan 2020 12:12:28 GMT

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.

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

tomrvincent — Wed, 29 Jan 2020 13:44:50 GMT

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

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

andreas_lds — Wed, 29 Jan 2020 16:47:14 GMT

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

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

sass_numero_uno — Wed, 29 Jan 2020 16:58:00 GMT

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

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

tomrvincent — Wed, 29 Jan 2020 17:11:55 GMT

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