{"id":"W2183861895","doi":"","title":"Joining Data: Data Step Merge or SQL? Harry Droogendyk, Stratia Consulting Inc., Lynden, ON Faisal Dosani, RBC Royal Bank, Toronto, ON","year":2008,"lang":"en","type":"article","venue":"","topic":"SAS software applications and methods","field":"Engineering","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"Joins; SQL; Merge (version control); Computer science; PL/SQL; SQL/PSM; Database; Programming language; Query by Example; Information retrieval","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":false,"about_ca":true,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":["metaepi_narrow","insufficient_payload"],"consensus_categories":[],"category_scores_codex":[0.000566539,0.000358688,0.0003586079,0.00005670593,0.0002653794,0.00007406454,0.001131842,0.0001692455,0.001866605],"category_scores_gemma":[0.0002925205,0.0003061072,0.00003559466,0.0001668469,0.00005470101,0.0005128928,0.0004112259,0.000329351,0.0001767312],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0001146251,"about_ca_system_score_gemma":0.0001005365,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001101849,"about_ca_topic_score_gemma":0.001579815,"domain_scores_codex":[0.9977881,0.00007461148,0.0005329954,0.0007664743,0.0003490938,0.0004887187],"domain_scores_gemma":[0.9964531,0.0006419093,0.00007571541,0.002590523,0.00004945632,0.000189287],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0002514824,0.0005395299,0.002658591,0.0001972629,0.0006973766,0.0002025669,0.001082121,0.008765349,0.005526307,0.006280505,0.6940081,0.2797909],"study_design_scores_gemma":[0.002297903,0.0003308089,0.005473881,0.0001372518,0.0001436352,0.0001251167,0.001392462,0.3915872,0.004556124,0.00002004888,0.5924022,0.001533325],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1665381,0.003352745,0.542622,0.0002996565,0.004043435,0.002439919,0.004301435,0.006709772,0.2696929],"genre_scores_gemma":[0.671195,0.000396656,0.3211468,0.0005875159,0.0009217162,0.00008835659,0.002493026,0.0001959179,0.002975078],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.5046569,"threshold_uncertainty_score":0.9999391,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.1589400652698862,"score_gpt":0.3474919165793123,"score_spread":0.1885518513094261,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}