Can I use a Prompt to name the source column in a transpose table in SAS Enterprise Guide?

ralizadeh — Thu, 27 Apr 2023 21:34:35 GMT

How to use a prompt to name the Source column showed below something different?

I used it, and it gave me this:

Thank you.

Re: Can I use a Prompt to name the source column in a transpose table in SAS Enterprise Guide?

JOL — Mon, 12 Jun 2023 19:39:41 GMT

Yes you can use a Prompt to name the source column, but it requires modifying the underlying code.

Are you sure you need to modify the Source column name, or do you need to choose the source transpose variable from a list?

If so create a Variable Prompt and add as below

If you really need to modify the Source column name:

1) Create a Text Prompt, with the list of values

2) Add the Text Prompt as in your example under Options. Run the task.

3) Start typing in the generated Code to create a copy

4) Right-Click on the code under the Project tree on the left to modify the code properties. Select Prompts, add the Text Prompt.

5) Modify the PROC TRANPOSE, NAME= option as follows:

change NAME='&prompt_2'n to NAME=&prompt_2