Dear Members, May I ask for your assistance? My first problem I am facing with is that using proc import I cannot import XLSM files. Is it even possible? The second one is that I have to import these files in a stuctured table, but the data is scattered in the excel. Let me tell an example: to SAS column 1 -> excel E8 cell would go, column 2 -> F8, column 3 > excel E9, column 4 -> excel F9 etc... Is it possible to specify somehow these rules? Thank you very much in advance for the hints!
... View more