topic Re: Change the size of the Input put prompt in a store procedure in Developers

Change the size of the Input put prompt in a store procedure

jb9977 — Thu, 29 Jun 2017 21:13:35 GMT

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

Re: Change the size of the Input put prompt in a store procedure

FredrikE — Fri, 30 Jun 2017 11:48:18 GMT

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....

Fredrik

Re: Change the size of the Input put prompt in a store procedure

Vince_SAS — Fri, 07 Jul 2017 12:22:11 GMT

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