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

[jb9977]

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

[FredrikE]

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

[Vince_SAS]

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