@spastranas wrote: Thank you. The task at hand, is to take the report as it is, and automate the transposing of the columns so that it can be consumed in tableau. Thus, why I need to figure out how it import as number rather than percent.
Will there be more columns the next time the data is read? More rows?
The process for matching multiple rows of data into different variables is not going to be trivial and may be fragile if that source file ever changes layout, such as adding columns.
You might be ahead of the game by going to whatever creates that not-very-nice layout file and discuss whether that could create a nicer file, i.e. the actual transpose.
Some solutions that might work may require lots of maintenance if the file layout changes at all.
Relying on proc import to read data for multiple files is not a good idea as every single file is examined and variables can receive different properties. When the file has "garbage" like blank rows there becomes increasing chance of getting character values instead of numeric as expected. If the file adds columns you also run a risk of not all values on a row being treated as the same type.
... View more