{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.007423849,0.0005785666,0.0007388499,0.001124674,0.000757699,0.004002779,0.001172023,0.001236878,0.07056817],"category_scores_gemma":[0.0181475,0.0009571175,0.0003410675,0.002261653,0.001380461,0.007386201,0.002555626,0.002224765,0.05044467],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0009029253,"about_ca_system_score_gemma":0.001575333,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002689043,"about_ca_topic_score_gemma":0.005380013,"domain_scores_codex":[0.9961352,0.00132837,0.0003870875,0.0005485466,0.001441774,0.000159072],"domain_scores_gemma":[0.9884996,0.006997658,0.0005591467,0.001467777,0.001727204,0.0007486986],"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.0001938729,0.00003626306,0.002639124,0.000313065,0.00001649957,0.0002635479,0.0009214233,0.0003457486,0.004161389,0.04428612,0.5882856,0.3585373],"study_design_scores_gemma":[0.00003347515,0.00003589243,0.001097576,0.0001980945,0.00001075789,0.0007769234,0.0008168122,0.00263222,0.003888722,0.01310474,0.9773471,0.00005758851],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.006049568,0.01335062,0.752858,0.04823709,0.001965822,0.0002674925,0.004910344,0.05780824,0.1145527],"genre_scores_gemma":[0.05092919,0.02253147,0.6987607,0.0166545,0.002335166,0.0003098055,0.006798816,0.02799182,0.1736885],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.07056817,"threshold_uncertainty_score":0.2360741,"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."}}