06-29-2017 05:13 PM
I have created a store procedure where user can enter multiple values not selecting from dynamic lists. the problem is i can copy and past values in rows of a excel sheet like
1234 2345 4567
but when the values are in columns like
the promt takes only the first value . How do solve this issue and is there a way to increse the size of input section of a promt.
06-30-2017 07:48 AM
transform them in excel before you c&p them
Copy the rows in excel and then paste in again into excel and use the transform option of the paste....
07-07-2017 08:22 AM
Try changing the "Text type" to "Multi-line text field" in the prompt definition, as shown in the attached screenshot from the SAS Management Console.