We do have SAS WRS 4.2 M2 with SAS 9.2 in our environment. We are just converting our reports to SAS EBI. We have particular set of report where prompts have 100+ values. Entering each values one by one and clicking add is time consuming job. I am expecting WRS to take inputs for prompts from a delimited file (or) string.
I did check with SAS tech support and got reply WRS does not have this feature for now. Do any of you guys have work around/solution for this scenario?
From Add-in they could upload tables using 'Copy to SAS Server'.
Another option altogether is to allow users to choose from a dynamic list (proc sql select distinct) by editing the data item in the information map, moving to 'Value-Generation Method', and choosing 'User selects values from a dynamic list'.
Then from WRS all the values existing in the data table would be available for users to pull in for their prompt. At least this would save on typing time.
I tried approach of creating SAS data sets and using it as input to prompts. I am not successful. Here is summary of what I did.
1. Create SAS Dataset with list of values for huge filter.
2. Register the SAS Dataset as table in library. The library is assigned to sas application of WRS. The table is given read metadata permission.
3. Create prompt in Information map with "Method of polulating prompt" selected as "User selects values from a dynamic list", Under DataSource options specify "Specify a data source" and point to table registered through management console.
When I tried to use this filter in WRS, I get error message as below in WRS logs:
2011-03-03 16:54:18,188 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN [ad13c8161727db9e:-74c6b0bf:12e749b56e6:4126sasdemo] com.sas.prompts.valueprovider.dynamic.workspace.PromptColumnValueProvider - Cannot resolve data type
2011-03-03 16:54:44,289 [[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR  com.sas.prompts.valueprovider.dynamic.DataProviderUtil - Unable to find physical table
com.sas.storage.exception.ServerConnectionException: Unable to find physical table.
Please be aware that using the dynamic generation of these values does require a query to be run against the data to populate the distinct values. If you are using large data, this may take a bit of time to return. This may be acceptable in your situation. If not, you may explore using an external table as Angela mentions and possibly build that table periodically as it makes sense with your data.