Altair slc determining type and length of excel columns before importing
Too long to post on a list, see github
https://github.com/rogerjdeangelis/utl-altair-slc-determining-type-and-length-of-excel-columns-before-importing
Altair Community
https://community.altair.com/discussion/65575/unable-to-select-attributes-from-read-excel-or-read-csv/p1?tab=all
Problem:
Given an excel sheet with columns
NAM SEX AGE. WGT
Determine optimum type and length
NAM $7. Character length 7 bytes
SEX $1. Character length 1 byte
AGE $2. Character length 2 bytes
WGT 3. Numeric length 3 bytes (sas can create 3-8 byte floats that are automaticall converted IEEE 8 byte Floats)
Possible excell commands and functions
https://ss64.com/access/
RELATED REPOS
https://github.com/rogerjdeangelis/utl-Import-excel-sheet-as-character-fixing-truncation-mixed-type-columns-and-appending-issues
https://github.com/rogerjdeangelis/utl-altair-slc-determining-type-and-length-of-excel-columns-before-importing
https://github.com/rogerjdeangelis/utl-avoid-storing-numbers-as-text-when-exporting-mixed-type-to-excel
https://github.com/rogerjdeangelis/utl-concatenating-thirty-seven-excel-tabs-while-correcting-column-types-and-using-longest-length
https://github.com/rogerjdeangelis/utl-find-out-which-excel-columns-are-dates-and-assign-date-type
https://github.com/rogerjdeangelis/utl-fix-excel-columns-with-mutiple-datatypes-on-the-excel-side-using-ms-sql-and-passthru
https://github.com/rogerjdeangelis/utl-select-type-and-length-using-odbc-excel-passthru-query
https://github.com/rogerjdeangelis/utl_excel_combining_sheets_without_common_names_types_lengths
https://github.com/rogerjdeangelis/utl_excel_determine_type_length
https://github.com/rogerjdeangelis/utl_excel_fix_type_length_on_import
