Your SAS programs, embedded in web apps and elsewhere

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

Reply
Occasional Contributor
Posts: 16

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

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


Sp_example.PNG
Regular Contributor
Posts: 191

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

transform them in excel before you c&p them Smiley Happy

Copy the rows in excel and then paste in again into excel and use the transform option of the paste....

 

BR

Fredrik

SAS Super FREQ
Posts: 304

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

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


PromptType.PNG
Ask a Question
Discussion stats
  • 2 replies
  • 304 views
  • 0 likes
  • 3 in conversation