handle formats with `multilabel` and `notsorted` options - Githubissues

sasjs / core

Macros for SAS® App Developers

https://core.sasjs.io

MIT License

119 stars 17 forks source link

handle formats with `multilabel` and `notsorted` options #337

Closed allanbowe closed 1 year ago

allanbowe commented 1 year ago

The previous assumption that a format catalog had a primary key was.. completely wrong.

START / END / LABEL may all contain missing values, and the entire CNTLOUT dataset itself may contain duplicate rows (eg with multilabel option). The order is also important and must be preserved.

To cater for these scenarios we will need to add a new column to the exported catalog data, and use this as a key column in place of start/end/label:

FMTROW - an integer showing the position of each row, windowed by TYPE FMTNAME

Tests will be needed covering the multilabel and notsorted options.

Affected macros:

mp_cntlout.sas
mp_loadformat.sas
mddl_sas_cntlout.sas

sasjsbot commented 1 year ago

:tada: This issue has been resolved in version 4.46.2 :tada:

The release is available on:

Your semantic-release bot :package::rocket: