Data is actually coming in excel (three tabs, 4 tabs,depends) and i use pcfiles (libname mylib pcfiles.....)to import it into SAS. The tabs are named differently every time i receive this excel creating different datasets after the import but i have a macro that takes care of it (picking all the datasets in my library and appending them)
Now the problem is before running that macro some times i have to convert the value of the second field and conversion not a problem as long as that header does not keep changing its name.
The data in the excel tabs is kinda messy(some titles on the top rows which are always in the second column of the sheets),then empty rows and then data) so when i try importing it that title behaves as the 2nd header in my tables and that title is always different in each tab, every month
The rest of the headers are ok, always F1,F3,.......F23. It is the second one that messes up and prevents me from automating this so i was hoping SAS is capable of calling the fields in the datasets using indexes
... View more