{"id":"https://openalex.org/W2183161125","doi":null,"title":"DATA Step and PROC SQL Programming Techniques","display_name":"DATA Step and PROC SQL Programming Techniques","alternate_titles":[],"publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2183161125","mag":"2183161125"},"language":"en","primary_location":{"id":"mag:2183161125","doi":null,"is_oa":false,"landing_page_url":"http://mwsug.org/proceedings/2010/tutorials/MWSUG-2010-11.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2183161125"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5026255237","display_name":"Kirk Paul Lafler","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Kirk Paul Lafler","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5026255237"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.4637,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.92152898,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13820","display_name":"SAS software applications and methods","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13820","display_name":"SAS software applications and methods","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13398","display_name":"Data Analysis with R","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.000699999975040555,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-step","display_name":"DATA step","score":0.8029999732971191},{"id":"https://openalex.org/keywords/proc-sql","display_name":"PROC SQL","score":0.9990000128746033},{"id":"https://openalex.org/keywords/conditional-logic","display_name":"conditional logic","score":0.8740000128746033},{"id":"https://openalex.org/keywords/if-then-else","display_name":"if-then-else","score":0.9769999980926514},{"id":"https://openalex.org/keywords/case-expressions","display_name":"case expressions","score":0.8550000190734863},{"id":"https://openalex.org/keywords/inner-join","display_name":"inner join","score":0.7820000052452087},{"id":"https://openalex.org/keywords/outer-join","display_name":"outer join","score":0.9819999933242798},{"id":"https://openalex.org/keywords/sas-programming","display_name":"SAS programming","score":0.6679999828338623}],"concepts":[{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.8441833257675171},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7727571725845337},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7700765132904053},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6927142143249512},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.46982669830322266},{"id":"https://openalex.org/C203763787","wikidata":"https://www.wikidata.org/wiki/Q371029","display_name":"Null (SQL)","level":2,"score":0.43431344628334045},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.43061190843582153},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.42835599184036255},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.42420560121536255},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.353395938873291},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.24526256322860718},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.16128283739089966},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:2183161125","doi":null,"is_oa":false,"landing_page_url":"http://mwsug.org/proceedings/2010/tutorials/MWSUG-2010-11.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.605.634","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.605.634","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.dc-sug.org/DATA Step and PROC SQL Programming Techniques by Kirk Paul Lafler.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2111400712","https://openalex.org/W2129884316"],"related_works":["https://openalex.org/W2186462563","https://openalex.org/W2186397639","https://openalex.org/W7210064072","https://openalex.org/W2188675356","https://openalex.org/W2183861895","https://openalex.org/W7096451380","https://openalex.org/W2574100426","https://openalex.org/W2272959930","https://openalex.org/W7098083022","https://openalex.org/W7099346219"],"abstract_inverted_index":{"Are":[0],"you":[1],"considering":[2],"whether":[3],"to":[4,67],"use":[5],"a":[6],"DATA":[7,25,60],"step":[8,12,26,61],"or":[9],"PROC":[10,28,37,63],"SQL":[11,29,38,64],"in":[13],"your":[14],"next":[15],"project?":[16],"This":[17],"presentation":[18],"explores":[19],"the":[20,47],"similarities":[21],"and":[22,27,36,44,46,53,74,76,81],"differences":[23],"between":[24],"programming":[30,65,84],"techniques.":[31],"Topics":[32],"include":[33],"IF-THEN-ELSE,":[34],"SELECT-WHEN,":[35],"CASE":[39],"expressions":[40],"conditional":[41,69],"logic":[42,70],"concepts":[43],"constructs;":[45],"techniques":[48,66],"for":[49],"constructing":[50],"effective":[51],"merges":[52],"joins.":[54],"Attendees":[55],"explore":[56],"examples":[57],"that":[58],"contrast":[59],"versus":[62],"conduct":[68],"scenarios,":[71],"one-to-one":[72],"match-merges":[73],"match-joins,":[75],"an":[77],"assortment":[78],"of":[79],"inner":[80],"outer":[82],"join":[83],"constructs.":[85]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2183161125","counts_by_year":[{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-06-24T00:00:00"}
