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

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

saifislam — Fri, 22 Jul 2022 01:12:26 GMT

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

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

</select>

</div>

SAS Macro:

%global originStmt ;

%macro generate;

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

%mend;

%generate;

Vince_DelGobbo — Mon, 08 Aug 2022 23:00:36 GMT

Try specifying the data-threshold attribute:

Creating HTML Forms with Dynamic Data > Attributes

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

Vince DelGobbo

ex-SAS R&D