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
1234
2345
3456
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.
Thanks,
Jay
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....
BR
Fredrik
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.
Vince DelGobbo
SAS R&D
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.