SAS Viya- html+sas macro- html select not displaying all the value

[saifislam]

I have html in Viya Job Execution, which connect with SAS Macro-

bug-  html drop down is only displaying 1000 values from the table col- the table have 14,000 rows with value.

Any solution?

html Code in Viya Job Execution

<div class="form-group">

                    <label for="var_origin" class="col-sm-3 control-label">Choose a ID Number</label>

                    <div class="col-sm-4">

                <select name="estabNumber"   id="estabNumber" data-colname="PrimaryIDNumber" data-library="REPORT" data-table="P_EST_TEST2">

              </select>

                    </div>

                </div>

SAS Macro:

%global originStmt ;

%macro generate; 

%if %symexist(estabNumber) %then %let originStmt = PrimaryEstablishmentNumber in ("&estabNumber") ; 

%mend; 

%generate; 

[Vince_DelGobbo]

Try specifying the data-threshold attribute:

Creating HTML Forms with Dynamic Data > Attributes

https://documentation.sas.com/doc/en/pgmsascdc/v_029/jobexecug/p0zom39gtjeq29n17jspywuzebvv.htm

Performance in your Web browser will likely degrade as the number of items in the widget increases.

Vince DelGobbo

ex-SAS R&D