{"id":"https://openalex.org/W43788442","doi":null,"title":"Methods for Generating Excel Files from SAS Datasets","display_name":"Methods for Generating Excel Files from SAS Datasets","alternate_titles":[],"publication_year":2005,"publication_date":"2005-01-01","ids":{"openalex":"https://openalex.org/W43788442","mag":"43788442"},"language":"en","primary_location":{"id":"mag:43788442","doi":null,"is_oa":false,"landing_page_url":"https://www.lexjansen.com/pharmasug/2006/posters/po13.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/W43788442"],"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/A5020177733","display_name":"Xingshu Zhu","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Xingshu Zhu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5077177517","display_name":"Shuping Zhang","orcid":"https://orcid.org/0000-0002-1204-4196","observed_orcids":["https://orcid.org/0000-0002-1204-4196"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Shuping Zhang","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-1204-4196","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"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":1.0,"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":1.0,"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/T11937","display_name":"Research Data Management Practices","score":0.0,"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"}},{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.0,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/excel-files","display_name":"Excel files","score":0.7710000276565552},{"id":"https://openalex.org/keywords/data-export","display_name":"data export","score":0.9120000004768372},{"id":"https://openalex.org/keywords/data-transformation","display_name":"data transformation","score":0.7279999852180481},{"id":"https://openalex.org/keywords/method-comparison","display_name":"method comparison","score":0.6899999976158142}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8151772022247314},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.7853400707244873},{"id":"https://openalex.org/C97250363","wikidata":"https://www.wikidata.org/wiki/Q235557","display_name":"File format","level":2,"score":0.598498523235321},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5628702640533447},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4730491042137146},{"id":"https://openalex.org/C171730128","wikidata":"https://www.wikidata.org/wiki/Q5227290","display_name":"Data file","level":2,"score":0.47170400619506836},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4611196219921112},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44277554750442505},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.42075997591018677},{"id":"https://openalex.org/C150670458","wikidata":"https://www.wikidata.org/wiki/Q4272815","display_name":"Data transformation","level":3,"score":0.41119930148124695},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.25989973545074463},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.12336811423301697},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:43788442","doi":null,"is_oa":false,"landing_page_url":"https://www.lexjansen.com/pharmasug/2006/posters/po13.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}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7096655323","https://openalex.org/W2185501156","https://openalex.org/W2181442564","https://openalex.org/W7204796519","https://openalex.org/W7101173797","https://openalex.org/W2125249333","https://openalex.org/W2188185651","https://openalex.org/W2182830659","https://openalex.org/W7096999558","https://openalex.org/W2579158300"],"abstract_inverted_index":{"When":[0],"processing":[1],"data":[2],"in":[3,33],"pharmaceutical":[4],"research,":[5],"it":[6],"is":[7],"often":[8],"necessary":[9],"for":[10,26],"a":[11,16,50,72,83],"SAS":[12,17,35,73],"programmer":[13],"to":[14,19,69],"transform":[15],"dataset":[18,74],"an":[20,79],"Excel":[21,80],"file":[22,81],"format.":[23],"Several":[24],"methods":[25,47],"performing":[27],"this":[28,39],"transformation":[29],"have":[30],"been":[31],"published":[32],"previous":[34],"conference":[36],"proceedings.":[37],"In":[38],"paper,":[40],"we":[41],"briefly":[42],"introduce":[43],"each":[44,59],"of":[45,53,58,86],"these":[46],"and":[48,56],"offer":[49],"critical":[51],"assessment":[52],"the":[54,66],"advantages":[55],"disadvantages":[57],"approach.":[60],"We":[61],"also":[62],"provide":[63],"recommendations":[64],"on":[65],"appropriate":[67],"method":[68],"use":[70],"when":[71],"must":[75],"be":[76],"transformed":[77],"into":[78],"under":[82],"specific":[84],"set":[85],"circumstances.":[87]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W43788442","counts_by_year":[],"updated_date":"2025-11-06T04:12:42.849631","created_date":"2016-06-24T00:00:00"}
