having a bit of trouble - reading data out of excel
so thought I'd try the user community for support (as well)
client data now has some blank rows (apart from one cell with a second column heading) before the "amount" data starts.
Unfortunately now, the first amount is in row 11 - beyond the depth of the default search for data-type metadata. Previously the data started straight away so there was no problem determining that the column should be numeric.
This is a locked down dest-top environment so "fixing" the relevant cell in the windows registry looks like being the very-slowest solution.
I understand "guessing-rows" is a PROC IMPORT option - but my application is using a "common macro" that uses the libname engine to proc copy all ranges/objects from excel that appear in that libname without a $ in the name.
So here's the question >>>>
do you know of a Libname statement option for SAS Access to PC files that alows the excel "guessing rows" to be specified?
peterC
In earlier thread
http://support.sas.com/forums/thread.jspa?messageID=30629瞥 Doc@Duke points out that a SAS solution to avoid a registry change is unlikely
😞
Message was edited by: Peter.C