Using Altair SLC to fill gaps in proc sql select third place in the daily double r python solutions

Roger DeAngelis_21630

Too long to post here, see github

Problem: Pick the horse that comes in third in the daily double horse race
The daily double is usaully the first and second race

SELECT THIRD PLACE FOR HORSES IN THE DAILY DOUBLE

SORTED FOR DOCUMENTATION
ONLY. PRE SORTING IS
NOT NEEDED.

RACE HORSE TIME Partition

1 lady_Joyce 70.5 1
1 gent_Thomas 85.0 2
1 gent_Henry 102.0 3 THIRD PLACE
1 gent_Alfred 112.0 4
1 gent_William 112.0 5

2 gent_John 99.0 1
2 lady_Alice 100.0 2
2 lady_Carol 102.0 3 THIRD PLACE
2 lady_Mary 112.0 4
2 lady_Barbara 113.0 5

CONTENTS (proc sql does not support the rank function)

 1 slc r sql

   supports export/import


 2 slc python sql

   (see the compact json below)

   I could not get export/import tp work with python

github
https://tinyurl.com/yc3d84r5
https://github.com/rogerjdeangelis/utl-altair-slc-to-fill-gaps-in-proc-sql-select-third-place-in-the-daily-double-r-python-solutions

related to
https://communities.sas.com/t5/SAS-Programming/6th-max-value/m-p/703006#M215365