In EG 4.3 I have set up a Stored Process using dynamic prompts with inputdata from tables. They are multi-select enabled which gives a listbox showing the first few rows with data values of the selected variable from the table. My problem is that the box listing the records of the variable is much too narrow. It is about 7 rows high and 15 characters wide, but my data are 32 characters wide, some even wider, and I see no way of making the box wide enough to fit all data. You have to scroll to the right all the time to read the full value.
It makes no difference if I use a format for the "Formatted (displayed) values" that is $32.
How do I scale the box to match the data width? Any advice is much appreciated
Maybe you can check and see if any of these work.... sorry i cannot check at my end...
In the prompt you can define the MAX Length for a text, try changing it to 40 and see if it works.
Or Check and see if your box size increases if you define your longest value as the default value.
Thanks for the suggestions - I had tried the min/max length before, but that did not help. I tried your idea with the default value, but that only led to that value being preselected.
Just to clarify to potential readers: You set up a prompt as a multiselect object by setting
If you run or Preview, you get two "boxes", Available and Selected. The data from the attached data set appear in Available. The boxes are both tiny and seemingly do not scale with anything, not the window width, the data properties or anything.
Sorry, just saw that you were executing your STP on EG.. Cannot be of much help here... Somehow the window size for Mutiple select is too small in EG..
Maybe some of the experts will point you in the right direction where maybe the properties of the STP web forms can be somehow be edited..
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.