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;
... View more