Currently in the SAS-Viya/SAS Studio (Version Stable 2024.02) QUERY interface, it is difficult to control where new columns are inserted in the Query column listing.
The interface is set up for a user to drag a new column from the tables/Columns window on the left into the QUERY>SELECT>Columns Tab on the right for insertion. It highlights the row the user hovers over, but upon insertion, the new column is not inserted there. Instead it shows up at the bottom of the Query column listing. SAS Technical Support informs me this is the "expected" behavior in the current version.
Request:
Please improve this interface to allow users to insert new columns where they are desired in the overall Query column listing. i.e. provide ability to:
- Select where in the column listing to insert new column(s) and put them there when executed.
- Allow selection of multiple columns by holding SHIFT or CNTRL keys and selecting them. Then allow user to drag them to the desired position in the listing.
- When insertion/move occurs, leave the display showing the same section of the column listing so the user can confirm where they went. Currently, when a move is done, the entire listing changes to a different view so you have to go looking for what was done.
