I have a stored procedure that takes 2 lists:
List of LotIDs (returned as a table from a DB query)
List of Columns (returned as a list from a modal Dialog box)
The list of LotIDs passed to the SQL stored procedure is in the format of: 'Lot1,Lot2'
The list of Column Names passed to the SQL store procedure is in the format of 'SomeText1,SomeText2,...,SomeTextN'
The stored procedure clal is something like:
open database"execute p_StoredProc 'Lot1,Lot2','SomeText1,SomeText2,...,SomeTextN' "
What can I do to get the list of lots as a checkbox list that I could select from?
How do I get the lists into the format I need to pass to the stored procedure?
Thank you,
Tim
There are a few ways to d this. Here is one simple way:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.