Matches in SemOpenAlex for { <https://semopenalex.org/work/W2189386594> ?p ?o ?g. }
Showing items 1 to 81 of
81
with 100 items per page.
- W2189386594 abstract "The open connectivity that SAS provides towards major data processing software like Microsoft Excel is always appreciated and heavily used across various industries. A complex but necessary Excel format was pre-designed as a data source template that has a lock mechanism to a block of data conversion settings needed to build up a SAS dataset library. Two major macros were developed to read vertical and horizontal stretching data blocks that had predefined SAS variable names anchored anywhere inside the template. Several approaches including PROC ACCESS/IMPORT were implemented but two major problems occurred: 1) lacking flexibility to handle ‘floating’ data blocks mentioned above and 2) SAS does not accept Excel versions like Excel97 or Excel2000 for either SAS v6.12 or the newest v8. This paper presents the powerful SAS macros with utilization of good old but reliable DDE (Dynamic Data Exchange) technique to overcome the limited function provided by other SAS procedures. Also, DDE still can automate reading multiple Excel workbooks into a SAS dataset library. This program is built on intermediate high SAS Macro skill set and works with SAS612 and SAS801 on Windows95-2000 platforms." @default.
- W2189386594 created "2016-06-24" @default.
- W2189386594 creator A5009148612 @default.
- W2189386594 creator A5024382564 @default.
- W2189386594 date "2000-01-01" @default.
- W2189386594 modified "2023-09-27" @default.
- W2189386594 title "When PROC ACCESS Says NO to Excel 97/2000, DDE says YES Still" @default.
- W2189386594 hasPublicationYear "2000" @default.
- W2189386594 type Work @default.
- W2189386594 sameAs 2189386594 @default.
- W2189386594 citedByCount "0" @default.
- W2189386594 crossrefType "journal-article" @default.
- W2189386594 hasAuthorship W2189386594A5009148612 @default.
- W2189386594 hasAuthorship W2189386594A5024382564 @default.
- W2189386594 hasConcept C105795698 @default.
- W2189386594 hasConcept C111919701 @default.
- W2189386594 hasConcept C115903868 @default.
- W2189386594 hasConcept C14036430 @default.
- W2189386594 hasConcept C154945302 @default.
- W2189386594 hasConcept C166955791 @default.
- W2189386594 hasConcept C177264268 @default.
- W2189386594 hasConcept C199360897 @default.
- W2189386594 hasConcept C2524010 @default.
- W2189386594 hasConcept C2777210771 @default.
- W2189386594 hasConcept C2777904410 @default.
- W2189386594 hasConcept C2780598303 @default.
- W2189386594 hasConcept C3018901056 @default.
- W2189386594 hasConcept C3019730874 @default.
- W2189386594 hasConcept C33923547 @default.
- W2189386594 hasConcept C41008148 @default.
- W2189386594 hasConcept C58489278 @default.
- W2189386594 hasConcept C77088390 @default.
- W2189386594 hasConcept C78458016 @default.
- W2189386594 hasConcept C86803240 @default.
- W2189386594 hasConceptScore W2189386594C105795698 @default.
- W2189386594 hasConceptScore W2189386594C111919701 @default.
- W2189386594 hasConceptScore W2189386594C115903868 @default.
- W2189386594 hasConceptScore W2189386594C14036430 @default.
- W2189386594 hasConceptScore W2189386594C154945302 @default.
- W2189386594 hasConceptScore W2189386594C166955791 @default.
- W2189386594 hasConceptScore W2189386594C177264268 @default.
- W2189386594 hasConceptScore W2189386594C199360897 @default.
- W2189386594 hasConceptScore W2189386594C2524010 @default.
- W2189386594 hasConceptScore W2189386594C2777210771 @default.
- W2189386594 hasConceptScore W2189386594C2777904410 @default.
- W2189386594 hasConceptScore W2189386594C2780598303 @default.
- W2189386594 hasConceptScore W2189386594C3018901056 @default.
- W2189386594 hasConceptScore W2189386594C3019730874 @default.
- W2189386594 hasConceptScore W2189386594C33923547 @default.
- W2189386594 hasConceptScore W2189386594C41008148 @default.
- W2189386594 hasConceptScore W2189386594C58489278 @default.
- W2189386594 hasConceptScore W2189386594C77088390 @default.
- W2189386594 hasConceptScore W2189386594C78458016 @default.
- W2189386594 hasConceptScore W2189386594C86803240 @default.
- W2189386594 hasLocation W21893865941 @default.
- W2189386594 hasOpenAccess W2189386594 @default.
- W2189386594 hasPrimaryLocation W21893865941 @default.
- W2189386594 hasRelatedWork W2125249333 @default.
- W2189386594 hasRelatedWork W2181885102 @default.
- W2189386594 hasRelatedWork W2182207605 @default.
- W2189386594 hasRelatedWork W2182299937 @default.
- W2189386594 hasRelatedWork W2182850362 @default.
- W2189386594 hasRelatedWork W2182899201 @default.
- W2189386594 hasRelatedWork W2183886948 @default.
- W2189386594 hasRelatedWork W2185250772 @default.
- W2189386594 hasRelatedWork W2185461516 @default.
- W2189386594 hasRelatedWork W2185991247 @default.
- W2189386594 hasRelatedWork W2186024023 @default.
- W2189386594 hasRelatedWork W2186606464 @default.
- W2189386594 hasRelatedWork W2186818861 @default.
- W2189386594 hasRelatedWork W2187195256 @default.
- W2189386594 hasRelatedWork W2188163824 @default.
- W2189386594 hasRelatedWork W2188470109 @default.
- W2189386594 hasRelatedWork W2188796347 @default.
- W2189386594 hasRelatedWork W2189139516 @default.
- W2189386594 hasRelatedWork W2567402067 @default.
- W2189386594 hasRelatedWork W43788442 @default.
- W2189386594 isParatext "false" @default.
- W2189386594 isRetracted "false" @default.
- W2189386594 magId "2189386594" @default.
- W2189386594 workType "article" @default.