TLDR: How to specify column format, informat, lenght, type in PROC IMPORT.My database is in xlsx format Longer Version I am importing my 3 excel databases A, B, C PROC IMPORT. I want to append this datasets after importing. These databases consists of date variables in different columns Database A will have values in column DateA Database B will have values in column DateB Database C will have values in column DateC All the three database will have columns DateA, DateB, DateC.But values in those columns will depend on what database it is. So when I import Database A the column type of DateB and DateC is set to character since they dont have values in them.How can I specify at the import itself that DateB and DateC should be considered as Date type. Another problem is the lenghts, format, informat of columns is set as it is in Database A.Due to which when I try to append B with A it gives me a truncation warning.I dont want my data to be truncated. I have in all 50 columns so manually specifying each columns lenght, format, informat etc. wont be a feasible thing.Is there any better alternative
... View more